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

25
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38977 Incr 0 369.50M SBT_TAPE 00:00:38 2008-05-06
BP Key: 38981 Status: AVAILABLE Compressed: NO Tag: TAG20080506T145513
Handle: DB10g_online_FL<DB10g_157:654015313:1>.dbf Media:
List of Datafiles in backup set 38977
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 0 Incr 7375106 2008-05-06 /opt/oracle/oradata/DB10g/system01.dbf
RMAN>
RMAN> list backup of archivelog from scn=7375106 ;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
39019 1.53G SBT_TAPE 00:02:40 2008-05-06
BP Key: 39025 Status: AVAILABLE Compressed: NO Tag: TAG20080506T145657
Handle: DB10g_online_FL<DB10g_164:654015418:1>.dbf Media:
10394b75:482055a3:5c7d:0057[ita022_file_lib_MediaPool_29]
List of Archived Logs in backup set 39019
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 96 7347881 2008-05-06 7375215 2008-05-06
1 97 7375215 2008-05-06 7375238 2008-05-06
RMAN>
RMAN> run {
2> set until sequence = 98 thread 1;
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_159:654015314:1>.dbf
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 10:35:48
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_159:654015314:1>.dbf "Oracle8"
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 10:36:16
Completed OB2BAR Restore: ita022:DB10g_online_FL<DB10g_159:654015314:1>.dbf
"Oracle8"
channel ORA_SBT_TAPE_1: restored backup piece 1
piece handle=DB10g_online_FL<DB10g_159:654015314:1>.dbf tag=TAG20080506T145513
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:01:15
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_158:654015314:1>.dbf
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 10:37:03
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_158:654015314:1>.dbf "Oracle8"
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 10:37:58