Rman duplicate fail with RMAN-06136, ORA-01503, ORA-12720 (文件 ID 1335479.1)
In this Document
Symptoms |
Cause |
Solution |
References |
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterInformation in this document applies to any platform.
***Checked for relevance on 22-Feb-2013***
Symptoms
Trying to duplicate a RAC source database and getting this error stack:
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TABPICPY" RESETLOGS ARCHIVELOG
MAXLOGFILES 384
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 64
MAXLOGHISTORY 292
LOGFILE
GROUP 1 SIZE 2000 M ,
GROUP 2 SIZE 2000 M ,
GROUP 7 SIZE 2000 M ,
GROUP 8 SIZE 2000 M ,
GROUP 9 SIZE 2000 M
DATAFILE
'+DATA_XDHFD1/tabpicpy/datafile/system.576.755692229'
CHARACTER SET AL32UTF8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/05/2011 10:32:00
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-12720: operation requires database is in EXCLUSIVE mode
Cause
Duplicating a RAC database to RAC is not supported
Bug 10183090: RMAN DUPLICATE COMMAND FAILS WHEN TRYING TO REPEAT AFTER FAILURE ...
Status 84 - Closed, not feasible to fix
Solution
RMAN does not have support for RAC auxiliary, it can duplicate a RAC source database to
single instance and once duplicate finishes the single instance can be made RAC.
To workaround this issue, when duplicating a spfile from a RAC instance,
use SET clause of duplicate:
spfile set CLUSTER_DATABASE=FALSE
... ;
References
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1062277/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rman duplicate target database RMAN-03002 RMAN-03015 RMAN-06136Database
- Ora-12720 During Rman Duplication Of Database (文件 ID 341089.1)Database
- RMAN duplicate databaseDatabase
- RMAN 'Duplicate Database' Feature in 11G [ID 452868.1]Database
- RMAN duplicate必須指定DBID的場景
- 通過rman duplicate database!Database
- RMAN duplicate On Windows7Windows
- Performing duplicate database with ASM/OMF/RMAN (Doc ID 340848.1)ORMDatabaseASM
- RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]DatabaseASM
- RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support [ID 1079563.1]RESTPlatform
- rman duplicate操作手冊
- RMAN duplicate database到新主機Database
- Oracle rman duplicate遷移測試Oracle
- RMAN DUPLICATE建立DataGuard物理備庫
- rman duplicate搭建第二個 dg
- 使用RMAN建立Duplicate資料庫資料庫
- rman duplicate clone庫的尷尬
- 【轉】RMAN建立duplicate資料庫資料庫
- 【RMAN】使用RMAN duplicate複製同機資料庫資料庫
- DG rman duplicate 複製庫錯誤
- Oracle 11g Rman Active database duplicateOracleDatabase
- RMAN duplicate 建立standby RAC資料庫資料庫
- RMAN學習筆記_ Duplicate建立DataGuard筆記
- RMAN學習筆記_ Duplicate重做DataGuard筆記
- RMAN DUPLICATE/RESTORE/RECOVER 混合平臺支援REST
- 【RMAN】使用duplicate本地複製資料庫資料庫
- duplicate rman複製資料庫技術資料庫
- Oracle11g RMAN Duplicate from Active DatabaseOracleDatabase
- Duplicating Database using RMAN duplicate commandDatabase
- oracle實驗記錄Rman duplicate database(1)OracleDatabase
- oracle實驗記錄Rman duplicate database 2OracleDatabase
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid不同UXDatabaseOracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid相同UXDatabaseOracle
- Creating a Data Guard Database with RMAN using Duplicate Command [ID 183570.1]Database
- RMAN duplicate from active database 複製資料庫Database資料庫
- Rman duplicate資料庫複製(單系統)資料庫
- 通過RMAN Duplicate建立Oracle物理standby備庫Oracle
- 使用rman的命令duplicate複製資料庫資料庫