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

29
Handle: DB10g_online_FL<DB10g_171:654105065:1>.dbf Media:
List of Datafiles in backup set 40356
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
3 0 Incr 7463626 2008-05-07 /opt/oracle/oradata/DB10g/sysaux01.dbf
4 0 Incr 7463626 2008-05-07 /opt/oracle/oradata/DB10g/users01.dbf
RMAN> list backup of archivelog from scn=7463625;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
40387 256.00K SBT_TAPE 00:00:04 2008-05-07
BP Key: 40394 Status: AVAILABLE Compressed: NO Tag: TAG20080507T155201
Handle: DB10g_online_FL<DB10g_179:654105279:1>.dbf Media:
10394b75:4821b3d4:5c7d:005f[ita022_file_lib_MediaPool_31]
List of Archived Logs in backup set 40387
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 102 7463712 2008-05-07 7463723 2008-05-07
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
40388 1.59G SBT_TAPE 00:04:58 2008-05-07
BP Key: 40395 Status: AVAILABLE Compressed: NO Tag: TAG20080507T155201
Handle: DB10g_online_FL<DB10g_178:654105122:1>.dbf Media:
10394b75:4821b3d4:5c7d:0060[ita022_file_lib_MediaPool_32]
List of Archived Logs in backup set 40388
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 101 7463367 2008-05-07 7463712 2008-05-07
RMAN> run {
2> set until sequence = 103 ;
3> restore database ;
4> recover database ;
5> alter database open resetlogs;
6> }
executing command: SET until clause
Starting restore at 2008-05-07
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=100 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=101 devtype=DISK
channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /opt/oracle/oradata/DB10g/undotbs01.dbf
restoring datafile 00005 to /opt/oracle/oradata/DB10g/example01.dbf
channel ORA_SBT_TAPE_1: reading from backup piece DB10g_online_FL<DB10g_172:654105065:1>.dbf
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 13:41:26
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_172:654105065:1>.dbf "Oracle8"
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 13:42:00
Completed OB2BAR Restore: ita022:DB10g_online_FL<DB10g_172:654105065:1>.dbf
"Oracle8"
channel ORA_SBT_TAPE_1: restored backup piece 1
piece handle=DB10g_online_FL<DB10g_172:654105065:1>.dbf tag=TAG20080507T155104
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:25
channel ORA_SBT_TAPE_1: starting datafile backupset restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /opt/oracle/oradata/DB10g/sysaux01.dbf
restoring datafile 00004 to /opt/oracle/oradata/DB10g/users01.dbf
channel ORA_SBT_TAPE_1: reading from backup piece DB10g_online_FL<DB10g_171:654105065:1>.dbf
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 13:42:51
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_171:654105065:1>.dbf "Oracle8"