Home » RDBMS Server » Backup & Recovery » Error creating a standby database using RMAN
Error creating a standby database using RMAN [message #195749] Mon, 02 October 2006 02:17 Go to next message
Messages: 1
Registered: July 2006
Junior Member
I am trying to create a standby database using RMAN. However, my restore fails because it keeps on looking for a standby controlfile that is missing. I have created a new standby controlfile but I am still getting the same error. Could somebody help please. Below is my sctipt and its output.

run {
set until sequence = 2745 thread =1;
allocate auxiliary channel ch1 type disk;
duplicate target database for standby dorecover nofilenamecheck;


executing command: SET until clause
using target database controlfile instead of recovery catalog

allocated channel: ch1
channel ch1: sid=13 devtype=DISK

Starting Duplicate Db at 30-SEP-06

printing stored script: Memory Script
restore clone standby controlfile to clone_cf;
replicate clone controlfile from clone_cf;
sql clone 'alter database mount standby database';
executing script: Memory Script

Starting restore at 30-SEP-06

channel ch1: starting datafile backupset restore
channel ch1: restoring controlfile
output filename=/oracle/oradata/cdsdb/control01.ctl
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/30/2006 11:28:13
RMAN-03015: error occurred in stored script Memory Script
ORA-19505: failed to identify file "/xd03/cdsdb/stby_cfile.07ht5pcg_1_1"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Re: Error creating a standby database using RMAN [message #214062 is a reply to message #195749] Sun, 14 January 2007 07:47 Go to previous messageGo to next message
Messages: 2
Registered: October 2006
Location: India
Junior Member

Hope you have created the standby controlfile using either:




Note that if you are creating the standby on another node, you have to move all your backups to the another node in exactly the same location they were backed up to on the primary server.

I think the error suggests that RMAN is unable to find the RMAN standby controlfile backup on another node.


[Updated on: Sun, 14 January 2007 07:57]

Report message to a moderator

Re: Error creating a standby database using RMAN [message #214403 is a reply to message #195749] Tue, 16 January 2007 05:23 Go to previous message
Messages: 6
Registered: August 2006
Location: INDIA
Junior Member
create control file using following cmd

sql>alter database create standby controlfile as 'c:\stby.ctl';

paste this file on standby, same loc as primary

this will definitely work


Previous Topic: Scheduling of RMAN Backup Script Stored in Recovery Catalog
Next Topic: RMAN backup command
Goto Forum:

Current Time: Sun Aug 20 04:50:57 CDT 2017

Total time taken to generate the page: 0.01036 seconds