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

21
As in the preceding case, we have to provide the right object that contains the Control File backup.
Again, below the session with the restore of the Control File:
RMAN> run { allocate channel dev_0 type sbt_tape;
restore controlfile from 'ita022:DB10g_online_FL<DB10g_191:654165773:1>.dbf'
;
}
allocated channel: dev_0
channel dev_0: sid=101 devtype=SBT_TAPE
channel dev_0: Data Protector A.06.00/PHSS_37147/PHSS_37148/DPSOL_00306/DPLNX_
Starting restore at 2008-05-08
channel dev_0: restoring control file
[Normal] From: [e-mail] "" Time: 05/08/08 11:33:29
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_191:654165773:1>.dbf "Oracle8"
[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
As for the other scenarios, we perform a Point in Time restore and recovery of the database:
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
{
set until sequence = 106 ;
restore database ;
recover database;
alter database open resetlogs;
}