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

40
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 2056752 bytes
Variable Size 67112400 bytes
Database Buffers 88080384 bytes
Redo Buffers 2134016 bytes
RMAN> restore spfile from autobackup;
Starting restore at 2008-07-02
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=40 devtype=DISK
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=35 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: Data Protector A.06.00/PHSS_37147/PHSS_37148/DPSOL_00306/DPLNX_
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: sid=34 devtype=SBT_TAPE
channel ORA_SBT_TAPE_2: Data Protector A.06.00/PHSS_37147/PHSS_37148/DPSOL_00306/DPLNX_
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080702
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080701
channel ORA_SBT_TAPE_2: looking for autobackup on day: 20080702
channel ORA_SBT_TAPE_2: looking for autobackup on day: 20080701
channel ORA_SBT_TAPE_2: skipped, autobackup already found
channel ORA_DISK_1: looking for autobackup on day: 20080702
channel ORA_DISK_1: looking for autobackup on day: 20080701
channel ORA_DISK_1: skipped, autobackup already found
channel ORA_SBT_TAPE_1: autobackup found: c-2216826430-20080701-01
[Normal] From: [e-mail] "RAC1" Time: 07/02/08 12:21:23
Starting OB2BAR Restore: ita018:c-2216826430-20080701-01 "Oracle8"
[Normal] From: [e-mail] "RAC1" Time: 07/02/08 12:21:29
Completed OB2BAR Restore: ita018:c-2216826430-20080701-01 "Oracle8"
channel ORA_SBT_TAPE_1: SPFILE restore from autobackup complete
Finished restore at 2008-07-02
RMAN> restore controlfile from autobackup;
Starting restore at 2008-07-02
using channel ORA_DISK_1
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080702
channel ORA_SBT_TAPE_1: looking for autobackup on day: 20080701
channel ORA_SBT_TAPE_2: looking for autobackup on day: 20080702
channel ORA_SBT_TAPE_2: looking for autobackup on day: 20080701
channel ORA_SBT_TAPE_2: skipped, autobackup already found
channel ORA_DISK_1: looking for autobackup on day: 20080702
channel ORA_DISK_1: looking for autobackup on day: 20080701
channel ORA_DISK_1: skipped, autobackup already found
channel ORA_SBT_TAPE_1: autobackup found: c-2216826430-20080701-01
[Normal] From: [e-mail] "RAC1" Time: 07/02/08 12:33:47
Starting OB2BAR Restore: ita018:c-2216826430-20080701-01 "Oracle8"
[Normal] From: [e-mail] "RAC1" Time: 07/02/08 12:33:52
Completed OB2BAR Restore: ita018:c-2216826430-20080701-01 "Oracle8"
channel ORA_SBT_TAPE_1: control file restore from autobackup complete
output filename=/opt/oracle/product/10.2.0/db_1/dbs/cntrlRAC1.dbf
Finished restore at 2008-07-02
In our case the Control File has been restored to $ORACLE_HOME/dbs. You may need to update the
PFILE control file location.
Before proceeding with the next step (mounting the DB), edit the PFILE as mentioned above.