Home » RDBMS Server » Backup & Recovery » RMAN-03002: failure of Duplicate Db command at 06/22/2013 18:36:23 (10g, 10.2.0.1, OEL-4.5)
RMAN-03002: failure of Duplicate Db command at 06/22/2013 18:36:23 [message #588483] Wed, 26 June 2013 03:10
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
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

Previous Topic: RMAN-00554: initialization of internal recovery manager package failed
Next Topic: Data files backed up to FRA instead of specified location
Goto Forum:
  


Current Time: Fri Mar 29 08:11:31 CDT 2024