Filter
Top Products
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.
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:
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
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.