-
issues with creating standby database with rman
DBAs,
I tried to use rman to create a standby database to the remote server. The primary database is on oracle 9.2.
The primary and the standby databases have different names.
primary: odewk standby yewk
I followed the instructions to create the standby controlfile:
COPY CURRENT CONTROLFILE FOR STANDBY TO ....
But when I issued the :
ORA-01103: database name 'ODEWK' in controlfile is not 'OYEWK'
Does that mean the standby must have the same name as the primary database?
FYI: the following is the whole output
DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK DORECOVER;
I got the following errors:
RMAN> DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK DORECOVER;
Starting Duplicate Db at 05-JAN-06
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=15 devtype=DISK
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 05-JAN-06
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: restoring controlfile
output filename=/db01/oradata/OYEWK/control/OYEWK_01.ctl
channel ORA_AUX_DISK_1: copied controlfile copy
input filename=/tmp/ODEWK_01.ctl
output filename=/db01/oradata/OYEWK/control/OYEWK_01.ctl recid=0 stamp=0
Finished restore at 05-JAN-06
replicating controlfile
input filename=/db01/oradata/OYEWK/control/OYEWK_01.ctl
output filename=/db02/oradata/OYEWK/control/OYEWK_02.ctl
output filename=/db03/oradata/OYEWK/control/OYEWK_03.ctl
sql statement: alter database mount standby database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/05/2006 15:37:06
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 01/05/2006 15:37:06
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-01103: database name 'ODEWK' in controlfile is not 'OYEWK'
Thanks,
-
Your parameter file does not match with the control file. Make sure the parameter file is fixed first, and your service name strings are correct.
Thanx
Sam
Thanx
Sam
Life is a journey, not a destination!
-
Thanks for the reply.
I found my mistake. The db_name in the standby's init file should be the same as the primary database.
After fixing this, everything went fine.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|