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

14
[Normal] From: [e-mail] "" Time: 05/07/08 09:43:00
Completed OB2BAR Restore: ita022:c-38758237-20080506-01 "Oracle8"
channel ORA_SBT_TAPE_1: SPFILE restore from autobackup complete
Finished restore at 2008-05-07
Once the SPFILE is restored, we decide to restart the instance with the restored SPFILE and not
leave it running with the default one.
Note:
The startup nomount force command is equivalent to first shutdown
abort the instance and then startup nomount
The same is done for the Control File autobackup restore. Note that, when the restore is finished, the
Control File is copied to the location specified in the SPFILE.
With the Control File in place, we can now mount the database.
RMAN> startup nomount force;
Oracle instance started
Total System Global Area 314572800 bytes
Fixed Size 2057944 bytes
Variable Size 100665640 bytes
Database Buffers 209715200 bytes
Redo Buffers 2134016 bytes
RMAN> run {
restore controlfile from autobackup;
}
Starting restore at 2008-05-07
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=101 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protector A.06.00/PHSS_37147/PHSS_37148/DPSOL_00306/DPLNX_
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=100 devtype=DISK
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080507
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080506
channel ORA_DISK_1: looking for autobackup on day: 20080507
channel ORA_DISK_1: looking for autobackup on day: 20080506
channel ORA_DISK_1: skipped, autobackup already found
channel ORA_SBT_TAPE_1: autobackup found: c-38758237-20080506-01
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 09:50:33
Starting OB2BAR Restore: ita022:c-38758237-20080506-01 "Oracle8"
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 09:50:36
Completed OB2BAR Restore: ita022:c-38758237-20080506-01 "Oracle8"
channel ORA_SBT_TAPE_1: control file restore from autobackup complete
output filename=/opt/oracle/oradata/DB10g/control01.ctl
output filename=/opt/oracle/oradata/DB10g/control02.ctl
output filename=/opt/oracle/oradata/DB10g/control03.ctl
Finished restore at 2008-05-07
RMAN>
RMAN> startup mount;
database is already started
database mounted
released channel: ORA_SBT_TAPE_1
released channel: ORA_DISK_1