Dear All,
While executing command as "duplicate target database for standby nofilenamecheck;", getting below error -
RMAN> duplicate target database for standby nofilenamecheck;
Starting Duplicate Db at 22-JUN-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK
contents of Memory Script:
{
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script
Starting restore at 22-JUN-13
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: restoring control file
ORA-19625: error identifying file /u01/ora10g/oradata/proddb/stancontrol.ctl
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is control file (/u01/ora10g/oradata/proddb/stancontrol.ctl)
ORA-19601: output file is control file (/u01/ora10g/oradata/standdb/control01.ctl)
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/22/2013 18:36:23
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore
But, i have checked the file and file's path. Below is the control file path of standby.
[standdb@localhost standdb]$ pwd
/u01/ora10g/oradata/standdb
[standdb@localhost standdb]$ ls -ltr
total 6912
-rw-r----- 1 standdb oinstall 7061504 Jun 22 18:31 stancontrol.ctl
below is of primary database -
[ashish@localhost proddb]$ pwd
/u01/ora10g/oradata/proddb
[ashish@localhost proddb]$ ls -ltr
total 1104708
-rw-r----- 1 ashish oinstall 7061504 Jun 24 11:48 stancontrol.ctl
-rw-r----- 1 ashish oinstall 52429312 Jun 24 15:35 redo03.log
-rw-r----- 1 ashish oinstall 52429312 Jun 24 15:35 redo01.log
-rw-r----- 1 ashish oinstall 52429312 Jun 24 15:40 redo06.log
-rw-r----- 1 ashish oinstall 52429312 Jun 24 15:40 redo05.log
-rw-r----- 1 ashish oinstall 52429312 Jun 24 15:40 redo04.log
-rw-r----- 1 ashish oinstall 20979712 Jun 24 22:02 temp01.dbf
-rw-r----- 1 ashish oinstall 52429312 Jun 25 12:36 redo02.log
-rw-r----- 1 ashish oinstall 5251072 Jun 25 13:15 users01.dbf
-rw-r----- 1 ashish oinstall 26222592 Jun 25 13:15 undotbs01.dbf
-rw-r----- 1 ashish oinstall 503324672 Jun 25 13:15 system01.dbf
-rw-r----- 1 ashish oinstall 251666432 Jun 25 13:15 sysaux01.dbf
-rw-r----- 1 ashish oinstall 7061504 Jun 25 15:01 control03.ctl
-rw-r----- 1 ashish oinstall 7061504 Jun 25 15:01 control02.ctl
-rw-r----- 1 ashish oinstall 7061504 Jun 25 15:01 control01.ctl
Please suggest, where is the problem?
Regards,
Ishika