Database Software

Database 11.2.0.1

I have recoved a cold backup of a primary database to a standby instance.

Method to backup: from http://www.visi.com/~mseberg/duprman2.html
RMAN RUN {
allocate channel d1 type disk;
backup format '/u01/backups/PRIMARY/df_t%t_s%s_p%p' database;
sql 'alter system archive log current';
backup format '/u01/backups/PRIMARY/al_t%t_s%s_p%p' archivelog all;
backup current controlfile for standby format '/u01/backups/PRIMARY/sb_t%t_s%s_p%p';
release channel d1;
}

Method to recover: from http://www.visi.com/~mseberg/duprman2.html
rman target sys/password@PRIMARY auxiliary /

RMAN> run {
allocate channel C1 device type disk;
allocate auxiliary channel C2 device type disk;
duplicate target database for standby nofilenamecheck;
}


Once I mounted the standby instance I'm getting the following errors. This has got me baffled. What did I do wrong? How do I correct?

MRP0: Background Managed Standby Recovery process started (finmeta)
started logmerger process
Wed Mar 21 11:05:34 2012
Managed Standby Recovery not using Real Time Apply
Wed Mar 21 11:05:34 2012
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_dbw0_26771.trc:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/finmeta/datafile/system.348.770552129'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/system.348.770552129
ORA-15012: ASM file '+DATA/finmeta/datafile/system.348.770552129' does not exist
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_dbw0_26771.trc:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '+DATA/finmeta/datafile/sysaux.347.770554015'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/sysaux.347.770554015
ORA-15012: ASM file '+DATA/finmeta/datafile/sysaux.347.770554015' does not exist
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_dbw0_26771.trc:
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '+DATA/finmeta/datafile/undotbs1.367.770556497'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/undotbs1.367.770556497
ORA-15012: ASM file '+DATA/finmeta/datafile/undotbs1.367.770556497' does not exist
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_dbw0_26771.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '+DATA/finmeta/datafile/users.368.770556893'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/users.368.770556893
ORA-15012: ASM file '+DATA/finmeta/datafile/users.368.770556893' does not exist
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_dbw0_26771.trc:
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '+DATA/finmeta/datafile/xmeta.346.770546851'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/xmeta.346.770546851
ORA-15012: ASM file '+DATA/finmeta/datafile/xmeta.346.770546851' does not exist
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_dbw0_26771.trc:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '+DATA/finmeta/datafile/iauser.366.770555491'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/iauser.366.770555491
ORA-15012: ASM file '+DATA/finmeta/datafile/iauser.366.770555491' does not exist
MRP0: Background Media Recovery terminated with error 1110
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_pr00_26826.trc:
ORA-01110: data file 1: '+DATA/finmeta/datafile/system.348.770552129'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/finmeta/datafile/system.348.770552129'
Slave exiting with ORA-1110 exception
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_pr00_26826.trc:
ORA-01110: data file 1: '+DATA/finmeta/datafile/system.348.770552129'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/finmeta/datafile/system.348.770552129'
Completed: ALTER DATABASE RECOVER managed standby database disconnect from session
Recovery Slave PR00 previously exited with exception 1110
Errors in file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_mrp0_26824.trc:
ORA-01110: data file 1: '+DATA/finmeta/datafile/system.348.770552129'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/finmeta/datafile/system.348.770552129'
MRP0: Background Media Recovery process shutdown (finmeta)
[oracle@fcndrdbdr01-adm /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace]$

cat /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_dbw0_26771.trc
Trace file /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace/finmeta_dbw0_26771.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /opt/bsaitmod/oracle/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: fcndrdbdr01-adm.aos.hqfincen.gov
Release: 2.6.18-238.19.1.el5
Version: #1 SMP Sun Jul 10 08:43:41 EDT 2011
Machine: x86_64
Instance name: finmeta
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 26771, image: oracle@fcndrdbdr01-adm.aos.hqfincen.gov (DBW0)


*** 2012-03-21 11:05:34.778
*** SESSION ID:(111.1) 2012-03-21 11:05:34.778
*** CLIENT ID:() 2012-03-21 11:05:34.778
*** SERVICE NAME:() 2012-03-21 11:05:34.778
*** MODULE NAME:() 2012-03-21 11:05:34.778
*** ACTION NAME:() 2012-03-21 11:05:34.778

DDE rules only execution for: ORA 1110
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/finmeta/datafile/system.348.770552129'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/system.348.770552129
ORA-15012: ASM file '+DATA/finmeta/datafile/system.348.770552129' does not exist
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 2: '+DATA/finmeta/datafile/sysaux.347.770554015'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/sysaux.347.770554015
ORA-15012: ASM file '+DATA/finmeta/datafile/sysaux.347.770554015' does not exist
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '+DATA/finmeta/datafile/sysaux.347.770554015'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/sysaux.347.770554015
ORA-15012: ASM file '+DATA/finmeta/datafile/sysaux.347.770554015' does not exist
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 3: '+DATA/finmeta/datafile/undotbs1.367.770556497'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/undotbs1.367.770556497
ORA-15012: ASM file '+DATA/finmeta/datafile/undotbs1.367.770556497' does not exist
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '+DATA/finmeta/datafile/undotbs1.367.770556497'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/undotbs1.367.770556497
ORA-15012: ASM file '+DATA/finmeta/datafile/undotbs1.367.770556497' does not exist
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 4: '+DATA/finmeta/datafile/users.368.770556893'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/users.368.770556893
ORA-15012: ASM file '+DATA/finmeta/datafile/users.368.770556893' does not exist
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '+DATA/finmeta/datafile/users.368.770556893'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/users.368.770556893
ORA-15012: ASM file '+DATA/finmeta/datafile/users.368.770556893' does not exist
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 5: '+DATA/finmeta/datafile/xmeta.346.770546851'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/xmeta.346.770546851
ORA-15012: ASM file '+DATA/finmeta/datafile/xmeta.346.770546851' does not exist
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '+DATA/finmeta/datafile/xmeta.346.770546851'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/xmeta.346.770546851
ORA-15012: ASM file '+DATA/finmeta/datafile/xmeta.346.770546851' does not exist
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 6: '+DATA/finmeta/datafile/iauser.366.770555491'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/iauser.366.770555491
ORA-15012: ASM file '+DATA/finmeta/datafile/iauser.366.770555491' does not exist
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '+DATA/finmeta/datafile/iauser.366.770555491'
ORA-17503: ksfdopn:2 Failed to open file +DATA/finmeta/datafile/iauser.366.770555491
ORA-15012: ASM file '+DATA/finmeta/datafile/iauser.366.770555491' does not exist
[oracle@fcndrdbdr01-adm /opt/bsaitmod/oracle/app/oracle/diag/rdbms/finmetastby/finmeta/trace]$