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

17
channel ORA_SBT_TAPE_1: restored backup piece 1
piece handle=DB10g_online_FL<DB10g_174:654105081:1>.dbf tag=TAG20080507T155104
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
Finished restore at 2008-05-07
RMAN>
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
As before, we can now proceed with the Control File restore and mount the database:
RMAN> restore controlfile;
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: starting datafile backupset restore
channel ORA_SBT_TAPE_1: restoring control file
channel ORA_SBT_TAPE_1: reading from backup piece DB10g_online_FL<DB10g_180:654105439:1>.dbf
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 13:23:07
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_180:654105439:1>.dbf "Oracle8"
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 13:23:09
Completed OB2BAR Restore: ita022:DB10g_online_FL<DB10g_180:654105439:1>.dbf
"Oracle8"
channel ORA_SBT_TAPE_1: restored backup piece 1
piece handle=DB10g_online_FL<DB10g_180:654105439:1>.dbf tag=TAG20080507T155719
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
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> startup mount;
database is already started
database mounted
released channel: ORA_SBT_TAPE_1
released channel: ORA_DISK_1
In this case, we can see that more than one backup is available in the period listed:
RMAN> list backup of database completed after 'SYSDATE';
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
40321 Incr 0 896.50M SBT_TAPE 00:00:46 2008-05-07
BP Key: 40325 Status: AVAILABLE Compressed: NO Tag: TAG20080507T154635
Handle: DB10g_online_FL<DB10g_167:654104795:1>.dbf Media:
List of Datafiles in backup set 40321
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 0 Incr 7463277 2008-05-07 /opt/oracle/oradata/DB10g/system01.dbf
2 0 Incr 7463277 2008-05-07 /opt/oracle/oradata/DB10g/undotbs01.dbf
3 0 Incr 7463277 2008-05-07 /opt/oracle/oradata/DB10g/sysaux01.dbf
4 0 Incr 7463277 2008-05-07 /opt/oracle/oradata/DB10g/users01.dbf
5 0 Incr 7463277 2008-05-07 /opt/oracle/oradata/DB10g/example01.dbf