Hi Team
As of now We are configuring a new standby database ,after execute the ' duplicate databasse for standby ' ,i am facing the below error ,
Errror :
RMAN> duplicate target database for standby nofilenamecheck dorecover;
Starting Duplicate Db at 27-AUG-14
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=212 device type=DISK
contents of Memory Script:
{
set until scn 930228;
restore clone standby controlfile;
}
executing Memory Script
executing command: SET until clause
Starting restore at 27-AUG-14
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/product/11.2.0.3/dbs/c-4186344199-20140826-00
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /u01/app/oracle/product/11.2.0.3/dbs/c-4186344199-20140826-00
ORA-19505: failed to identify file "/u01/app/oracle/product/11.2.0.3/dbs/c-4186344199-20140826-00"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /u01/rmanbackup/infprd01/20140826_INFPRD01_03pgu8pg_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/rmanbackup/infprd01/20140826_INFPRD01_03pgu8pg_1_1 tag=TAG20140826T164737
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+FRADG_IIP/infstd01/control01.con
output file name=+FRADG_IIP/infstd01/control02.con
output file name=+FRADG_IIP/infstd01/control03.con
Finished restore at 27-AUG-14
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set until scn 930228;
set newname for clone tempfile 1 to new;
switch clone tempfile all;
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 7 to new;
restore
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
renamed tempfile 1 to +DATADG_IIP in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 27-AUG-14
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to +DATADG_IIP
channel ORA_AUX_DISK_1: restoring datafile 00002 to +DATADG_IIP
channel ORA_AUX_DISK_1: restoring datafile 00003 to +DATADG_IIP
channel ORA_AUX_DISK_1: restoring datafile 00004 to +DATADG_IIP
channel ORA_AUX_DISK_1: restoring datafile 00005 to +DATADG_IIP
channel ORA_AUX_DISK_1: restoring datafile 00006 to +DATADG_IIP
channel ORA_AUX_DISK_1: restoring datafile 00007 to +DATADG_IIP
channel ORA_AUX_DISK_1: reading from backup piece /u01/rmanbackup/infprd01/20140826_INFPRD01_02pgu8p9_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/rmanbackup/infprd01/20140826_INFPRD01_02pgu8p9_1_1 tag=TAG20140826T164737
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:16
Finished restore at 27-AUG-14
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=8 STAMP=856701057 file name=+DATADG_IIP/infstd01/datafile/system.259.856701043
datafile 2 switched to datafile copy
input datafile copy RECID=9 STAMP=856701057 file name=+DATADG_IIP/infstd01/datafile/sysaux.260.856701043
datafile 3 switched to datafile copy
input datafile copy RECID=10 STAMP=856701057 file name=+DATADG_IIP/infstd01/datafile/undo_t01.261.856701043
datafile 4 switched to datafile copy
input datafile copy RECID=11 STAMP=856701057 file name=+DATADG_IIP/infstd01/datafile/users.262.856701043
datafile 5 switched to datafile copy
input datafile copy RECID=12 STAMP=856701057 file name=+DATADG_IIP/infstd01/datafile/xdb.256.856701043
datafile 6 switched to datafile copy
input datafile copy RECID=13 STAMP=856701057 file name=+DATADG_IIP/infstd01/datafile/iip_informatica.257.856701043
datafile 7 switched to datafile copy
input datafile copy RECID=14 STAMP=856701057 file name=+DATADG_IIP/infstd01/datafile/iip_informatica95_data_t01.258.856701043
contents of Memory Script:
{
set until scn 930228;
recover
standby
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 27-AUG-14
using channel ORA_AUX_DISK_1
starting media recovery
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '+DATADG_IIP/infstd01/datafile/system.259.856701043'
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/27/2014 12:31:04
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 24 and starting SCN of 925326 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 23 and starting SCN of 847769 found to restore
RMAN>
Errors in file /u01/app/oracle/admin/infstd01/diag/rdbms/infstd01/infstd01/trace/infstd01_mrp0_27709.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '+FRADG_IIP/infprd01/onlinelog/group_3.264.856275815'
ORA-17503: ksfdopn:2 Failed to open file +FRADG_IIP/infprd01/onlinelog/group_3.264.856275815
ORA-15173: entry 'infprd01' does not exist in directory '/'
ORA-00312: online log 3 thread 1: '+FRADG_IIP/infprd01/onlinelog/group_3.261.856110663'
ORA-17503: ksfdopn:2 Failed to open file +FRADG_IIP/infprd01/onlinelog/group_3.261.856110663
ORA-15173: entry 'infprd01' does not exist in directory '/'
Both primary and standby have a same disk group i.e DATADG and FRADG .
I have configure the DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_1 on standby database ,after that 3 member successfully created but remaning 2 member is looking the primary destination on standby database .
I am thankful to you if you provide the resolution
Regards
Arya