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:oyewk
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,