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

31
Session 3: Control File autobackup OFF and NO Recovery Catalog
oracle@hpu015[DB10g]:/home/oracle$ omnidb -session "2008/05/08-3"
Object Name Object Type Object Status CopyID
===============================================================================
ita022:DB10g_online_FL<DB10g_184:654165548:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_181:654165548:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_182:654165548:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_183:654165548:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_187:654165598:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_186:654165598:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_188:654165598:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_189:654165598:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_190:654165764:1>.dbf Oracle8 Completed
ita022:DB10g_online_FL<DB10g_191:654165773:1>.dbf Oracle8 Completed
ita022:DB10g DP Managed Control File Oracle8 Completed 508 (O)
ita022:Oracle Recovery Backup Catalog Oracle8 Completed 506 (O)
RMAN> set dbid=38758237 ;
executing command: SET DBID
RMAN> connect target /
connected to target database: (not mounted)
RMAN> startup nomount force;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/10.2.0/db_1/dbs/initDB10g.ora'
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> run { allocate channel dev_0 type sbt_tape;
2> restore spfile from 'ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf' ; }
allocated channel: dev_0
channel dev_0: sid=36 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: autobackup found: ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf
[Normal] From: [e-mail] "" Time: 05/08/08 11:16:21
Starting OB2BAR Restore: ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf "Oracle8"
[Normal] From: [e-mail] "" Time: 05/08/08 11:16:25
Completed OB2BAR Restore: ita022:DB10g_online_FL<DB10g_185:654165575:1>.dbf
"Oracle8"
channel dev_0: SPFILE restore from autobackup complete
Finished restore at 2008-05-08
released channel: dev_0
RMAN> run { allocate channel dev_0 type sbt_tape;
2> 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"