4 Replies Latest reply: Nov 29, 2012 5:49 AM by 911086 RSS

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

    911086
      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