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

28
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>
RMAN> startup mount;
database is already started
database mounted
released channel: ORA_SBT_TAPE_1
released channel: ORA_DISK_1
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
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
40354 Incr 0 191.50M SBT_TAPE 00:00:43 2008-05-07
BP Key: 40361 Status: AVAILABLE Compressed: NO Tag: TAG20080507T155104
Handle: DB10g_online_FL<DB10g_172:654105065:1>.dbf Media:
List of Datafiles in backup set 40354
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
2 0 Incr 7463627 2008-05-07 /opt/oracle/oradata/DB10g/undotbs01.dbf
5 0 Incr 7463627 2008-05-07 /opt/oracle/oradata/DB10g/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
40355 Incr 0 369.50M SBT_TAPE 00:00:45 2008-05-07
BP Key: 40362 Status: AVAILABLE Compressed: NO Tag: TAG20080507T155104
Handle: DB10g_online_FL<DB10g_170:654105065:1>.dbf Media:
List of Datafiles in backup set 40355
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 0 Incr 7463625 2008-05-07 /opt/oracle/oradata/DB10g/system01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
40356 Incr 0 335.75M SBT_TAPE 00:00:50 2008-05-07
BP Key: 40363 Status: AVAILABLE Compressed: NO Tag: TAG20080507T155104