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
jnyakomitta
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.

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

Output
-------

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
abhishek.se
Messages: 2
Registered: October 2006
Location: India
Junior Member
Hi,

Hope you have created the standby controlfile using either:

BACKUP CURRENT CONTROLFILE FOR STANDBY;

OR

COPY CURRENT CONTROLFILE FOR STANDBY TO '/tmp/sby_control01.ctl';


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.

Regards,

[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
ninja
Messages: 6
Registered: August 2006
Location: INDIA
Junior Member
hi
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

regards

ninja
Previous Topic: Changing passwd for sys user
Next Topic: How to recover a dropped tabled in oracle 9i
Goto Forum:
  


Current Time: Thu Dec 08 10:39:23 CST 2016

Total time taken to generate the page: 0.15375 seconds