| Error creating a standby database using RMAN [message #195749] |
Mon, 02 October 2006 02:17  |
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  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
