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

32
[Normal] From: [e-mail] "" Time: 05/08/08 11:33:32
Completed OB2BAR Restore: ita022:DB10g_online_FL<DB10g_191:654165773:1>.dbf
"Oracle8"
channel dev_0: restore complete, elapsed time: 00:00:46
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-08
released channel: dev_0
RMAN> alter database mount;
database mounted
RMAN> list backup of database completed after 'SYSDATE -1';
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
172 Incr 0 369.50M SBT_TAPE 00:00:42 2008-05-08
BP Key: 172 Status: AVAILABLE Compressed: NO Tag: TAG20080508T083907
Handle: DB10g_online_FL<DB10g_181:654165548:1>.dbf Media:
List of Datafiles in backup set 172
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
1 0 Incr 7525243 2008-05-08 /opt/oracle/oradata/DB10g/system01.dbf
RMAN> list backup of archivelog from scn=7525243 ;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
177 113.75M SBT_TAPE 00:00:06 2008-05-08
BP Key: 177 Status: AVAILABLE Compressed: NO Tag: TAG20080508T083957
Handle: DB10g_online_FL<DB10g_190:654165764:1>.dbf Media:
10394b75:4822a021:5c7d:006a[ita022_file_lib_MediaPool_34]
List of Archived Logs in backup set 177
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ---------- ---------- ---------
1 104 7511046 2008-05-08 7525289 2008-05-08
1 105 7525289 2008-05-08 7525300 2008-05-08
RMAN> run
2> {
3> set until sequence = 106 ;
4> restore database ;
5> recover database;
6> alter database open resetlogs;
7> }
executing command: SET until clause
Starting restore at 2008-05-08
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: 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_183:654165548:1>.dbf
[Normal] From: [e-mail] "DB10g" Time: 05/08/08 11:58:34
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_183:654165548:1>.dbf "Oracle8"
[Normal] From: [e-mail] "DB10g" Time: 05/08/08 11:59:02