Prerequisites, Restoring oracle using the data protector gui, Restoring database items in a disaster recovery – HP A.06.11 User Manual
Page 96: 96 restoring oracle using the data protector gui, Restoring oracle using the data protector
run {
allocate channel dev1 type 'sbt_tape' parms
'SBT_LIBRARY=Path_to_Data_Protector_MML,
ENV=(OB2BARHOSTNAME=virtual.domain.com)';
restore datafile '/opt/ora9i/oradata/MAKI/example02.dbf';
release channel dev1;
}
Prerequisites
•
An instance of Oracle must be created on the system to which you want to restore
or duplicate the database.
•
The database must be in the Mount state if the whole database is being restored,
or in the NoMount state if the control file is being restored or a database
duplication is performed.
Restoring Oracle using the Data Protector GUI
For restore, RMAN scripts are generated with necessary commands, depending on
selections made in the GUI. To use additional commands, use them manually from
RMAN itself. You can also use the workaround described in
“
How to modify the RMAN restore script
Restoring database items in a disaster recovery
In a disaster recovery situation, database objects must be restored in a certain order.
The following list shows you in which order database items must be restored. Under
normal conditions it is possible to restore database items in any order.
If the recovery catalog was used:
1.
Restore the recovery catalog database (if it was lost)
2.
Restore the control file
3.
Restore the entire database or data items
If the recovery catalog was not used:
1.
Restore the control file from automatic backup.
If no automatic backup of the control file is available, see
“
The Recovery Catalog was lost and the control file cannot be restored
2.
Restore the database or data items.
Integrating Oracle and Data Protector
96