Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01102: cannot mount database in EXCLUSIVE mode when dublicate database

Fatih AcarNov 29 2012 — edited Nov 29 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2012
Added on Nov 29 2012
4 comments
3,014 views