Oracle Database migration to a remote Data Protector cell--Best practices

34
Appendix B: How to restore the DP Managed Control File
root@ita022:/.root# export OB2APPNAME=DB10g
root@ita022:/.root# /opt/omni/lbin/ob2rman.pl -restore_controlfile -session 2008/03/19-1
[Normal] From: ob2rman@ita022 "DB10g" Time: 03/19/08 16:26:37
Starting restore of target database.
Net service name: DB10g.
Instance status: OPEN.
Instance name: DB10g.
Database DBID = 38758237.
Database control file type: CURRENT.
Database log mode: ARCHIVELOG.
[Normal] From: ob2rman@ita022 "DB10g" Time: 03/19/08 16:26:43
Starting restore of Data Protector managed control file backup.
[Normal] From: ob2rman@ita022 "DB10g" Time: 03/19/08 16:27:24
Restore of Data Protector managed control file backup completed.
Location: /var/opt/omni/tmp/ctrl_DB10g.dbf.
[Normal] From: ob2rman@ita022 "DB10g" Time: 03/19/08 16:27:25
Restore of target database completed.
Once the file system restore of the DP-managed Control File is finished, we can start the restore of the
Control File using RMAN.
run {
allocate channel 'dev0' type disk;
restore controlfile from '/var/opt/omni/tmp/ctrl_DB10g.dbf';
release channel 'dev0';
}
The same applies to the Recovery Catalog. In this case the option to be used is the following:
/opt/omni/lbin/ob2rman.pl -restore_catalog -session 2008/03/19-1