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

24
Fixed Size 2057944 bytes
Variable Size 100665640 bytes
Database Buffers 209715200 bytes
Redo Buffers 2134016 bytes
RMAN> run {
2> restore controlfile from autobackup;
3> }
Starting restore at 2008-05-07
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: looking for autobackup on day: 20080507
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080506
channel ORA_DISK_1: looking for autobackup on day: 20080507
channel ORA_DISK_1: looking for autobackup on day: 20080506
channel ORA_DISK_1: skipped, autobackup already found
channel ORA_SBT_TAPE_1: autobackup found: c-38758237-20080506-01
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 09:50:33
Starting OB2BAR Restore: ita022:c-38758237-20080506-01 "Oracle8"
[Normal] From: [e-mail] "DB10g" Time: 05/07/08 09:50:36
Completed OB2BAR Restore: ita022:c-38758237-20080506-01 "Oracle8"
channel ORA_SBT_TAPE_1: control file restore from autobackup complete
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>
RMAN> list backup of database completed between 'SYSDATE -1' and 'SYSDATE' ;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38975 Incr 0 191.50M SBT_TAPE 00:00:29 2008-05-06
BP Key: 38979 Status: AVAILABLE Compressed: NO Tag: TAG20080506T145513
Handle: DB10g_online_FL<DB10g_159:654015314:1>.dbf Media:
List of Datafiles in backup set 38975
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
2 0 Incr 7375108 2008-05-06 /opt/oracle/oradata/DB10g/undotbs01.dbf
5 0 Incr 7375108 2008-05-06 /opt/oracle/oradata/DB10g/example01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38976 Incr 0 335.50M SBT_TAPE 00:00:36 2008-05-06
BP Key: 38980 Status: AVAILABLE Compressed: NO Tag: TAG20080506T145513
Handle: DB10g_online_FL<DB10g_158:654015314:1>.dbf Media:
List of Datafiles in backup set 38976
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------- ----
3 0 Incr 7375107 2008-05-06 /opt/oracle/oradata/DB10g/sysaux01.dbf
4 0 Incr 7375107 2008-05-06 /opt/oracle/oradata/DB10g/users01.dbf