ORA-01102: cannot mount database in EXCLUSIVE mode when dublicate database
When I run the dublicate target for standby dorecover command, I took a error which is ORA-01102: cannot mount database in EXCLUSIVE mode. Product system is Oracle 11g RAC and Standby database is 11g single instance. I edited pfile for stanby according to documents. But I did not pass this part.
RMAN> duplicate target database for standby dorecover;
Starting Duplicate Db at 29-NOV-12
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=68 device type=DISK
contents of Memory Script:
{
set until scn 24633155;
restore clone standby controlfile;
}
executing Memory Script
executing command: SET until clause
Starting restore at 29-NOV-12
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /backup/control_file.ctl
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /backup/control_file.ctl
ORA-19608: /backup/control_file.ctl is not a backup piece
failover to previous backup
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: reading from backup piece /backup/backup_db_dbname_s21_p1_20121128
channel ORA_AUX_DISK_1: piece handle=/backup/backup_db_dbname_s21_p1_20121128 tag=TAG20121128T092421
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/backup/control_file.ctl
Finished restore at 29-NOV-12
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
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 11/29/2012 09:17:36
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of sql command on clone_default channel at 11/29/2012 09:17:36
RMAN-11003: failure during parse/execution of SQL statement: alter database mount standby database
ORA-01102: cannot mount database in EXCLUSIVE mode
Edited by: 908083 on 29.Kas.2012 01:14