HP OpenView Storage Data Protector B6960-96008 사용자 설명서
Integrating Oracle and Data Protector
Restoring an Oracle Database
Chapter 1
73
• Oracle 9i/10g:
1. Restore the control file from automatic backup.
If no automatic backup of the control file is available, see problem
“The Recovery Catalog was lost and the control file cannot be
restored from Data Protector managed backup” on page 139.
“The Recovery Catalog was lost and the control file cannot be
restored from Data Protector managed backup” on page 139.
2. Restore the database or data items.
Changing The Database State
Before you restore any database item or you perform a duplication of a
database, ensure that the database is in the correct state:
database, ensure that the database is in the correct state:
To put the database into the correct state, run:
sqlplus /nolog
SQL>connect <user>/<password>@<service> as sysdba
;
SQL>shutdown immediate
;
To put the database into
NoMount
state, run:
SQL>startup nomount
;
To put the database into
Mount
state, run:
SQL>startup mount;
Table 1-3
Required Database States
Item to restore
Database state
Control file, duplicating a
database
database
NoMount
(started)
All other items
a
Mount
a. When restoring only a few tablespaces or
datafiles, then the database can be open with the
tablespaces or datafiles to be restored offline.
tablespaces or datafiles to be restored offline.