This discussion is archived
4 Replies Latest reply: Nov 29, 2012 3:49 AM by 911086 RSS

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

911086 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points