Oracle Error From Auxiliary Database Ora-01503 Create Controlfile Failed
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of rman-06136 oracle error from auxiliary database it will not work correctly without it enabled. Please
Ora-12720
turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Recovery Manager (RMAN) All PlacesDatabasePerformance & AvailabilityRecovery Manager (RMAN) This discussion is archived 8 Replies Latest reply on Aug 13, 2015 1:12 PM by EdStevens RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed ORA-00349: failure obtaining block size for ' vdbcl01_data_01' 678298 Jul 23, 2015 12:03 AM Hi All, I am in the process of creating duplicate database on different server with different name. Both DB in same version of oracle - 11.2..0.3Both server/system - Oracle Solaris 11.1 SPARCBoth DBs using different diskgroups. Below process i used for this work. 1. Copy pfile from source db and sent to auxiliary DB machine and modify as below. *.audit_file_dest='/u01/app/oracle/admin/EW2PRD/adump'*.audit_trail='OS'*.compatible='11.2.0.3.0'*.control_files='+PRDCL01_DATA_01/EW2PRD/controlfile/current.669.879366659','+PRDCL01_RECO_01/EW2PRD/controlfile/current.2818.879366661'#Restore Controlfile*.cpu_count=2*.db_block_size=8192*.db_create_file_dest='+PRDCL01_DATA_01'*.db_create_online_log_dest_1='+PRDCL01_DATA_01'*.db_create_online_log_dest_2='+PRDCL01_RECO_01'*.db_domain=''*.db_name='EW2PRD'*.db_recovery_file_dest='+PRDCL01_RECO_01'*.db_recovery_file_dest_size=42949672960*.db_unique_name='EW2PRD'*.diagnostic_dest='/u01/app/oracle'*.db_file_name_convert=('+VDBCL01_DATA_01/EW1TST','+PRDCL01_DATA_01/EW2PRD')*.log_file_name_convert=('+VDBCL01_RECO_01/EW1TST','+PRDCL01_RECO_01/EW2PRD')*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES, ALL_ROLES)'*.log_archive_format='%t_%s_%r.dbf'*.nls_territory='AUSTRALIA'*.open_cursors=300*.pga_aggregate_target=320M*.processes=200*.remote_login_passwordfile='EXCLUSIVE'*.resource_manager_plan='DEFAULT_MAINTENANCE_PLAN'*.sessions=225*.sga_target=498M*.undo_tablespace='UNDO_01'2. perform all required steps to get this thing work (startup nomount, tnsnames, password file etc)3. rman target sys/racqld@EW1TST auxiliary /4. duplicate target database to EW2PRD;it gives me below error ...sql statement: CREATE CONTROLFILE REUSE SET DATABASE "EW2PRD" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 1266 LOGFILE GROUP 1 ( '+prdcl01_reco_01', '+vdbcl01_data_01' ) SIZE 50 M REUSE, G
operation requires database is in EXCLUSIVE mode. contents of Memory Script: { sql clone "alter system set db_name = ''RMANDP'' comment= ''Reset to original value by RMAN'' scope=spfile"; sql clone "alter system reset db_unique_name scope=spfile"; shutdown clone immediate; startup clone nomount; } executing Memory Script sql statement: alter system set db_name = ''RMANDP'' comment= ''Reset to original value by RMAN'' scope=spfile sql statement: alter system reset db_unique_name scope=spfile Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total https://community.oracle.com/thread/3771569 System Global Area 275578880 bytes Fixed Size 2227584 bytes Variable Size 159384192 bytes Database Buffers 109051904 bytes Redo Buffers 4915200 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "RMANDP" RESETLOGS ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 32 MAXLOGHISTORY 292 LOGFILE GROUP 5 SIZE 100 M , GROUP 6 SIZE 100 M DATAFILE '+DATA/rmandp/datafile/system.367.849426993' CHARACTER SET AL32UTF8 http://oraclepublisher.blogspot.com/2014/06/rman-duplicate-on-rac-database-and-ora.html RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 06/05/2014 08:03:41 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 2.Include the parameter cluster_database to false in the duplicate target statement as below to avoid the operation requires database is in exclusive mode error RMAN> duplicate target database to rmandp from active database spfile set db_name='rmandp' set instance_number='1' set control_files='+DATA','+DATA' set cluster_database='false' # Avoid ORA-12720 error set log_file_name_convert='+DATA/orcl/','+DATA/rmandp/' db_file_name_convert='+DATA/orcl/','+DATA/rmandp/'; Posted by Parandhaman Margan at 12:16 AM Labels: ACTIVE DATABASE, ORA-01503, rman duplicate, RMAN-06136 No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) SECTIONS 06577 (1) 06580 (1) 12c (2) ACTIVE DATABASE (1) Advise failure (1) Archivelog (4) ASM TO ASM (1) autobackup (1) autobackup format (1) Backed 2 times (1) backup (1) BACKUP DATABASE (1) backup location (2) backup of backupset (1) BACKUP OPTIMIZATION (1) BACKUP+DURATION+PARTIAL DURATION (1) backuppiece (1) BEFORE RESETLOGS (1) block
db When usingRMANrestoring auxiliary Duplicate db from PROD DB to the CLONE DB,Getting below error on create control http://oracletechdba.blogspot.com/2014/12/error-rman-03002-rman-05501-rman-06136.html file by investigating we have not set log file convert in init.ora file,So it failed in target destination redo creation on control file, But the restore of datafile was succesfull,So i structured the control file from sample of prod then recreated the controlfile. Error: ...... .... tdown clone immediate; startup clone nomount; oracle error } executing Memory Script sql statement: alter system set db_name = ''CLONEDB'' comment= ''Reset to original value by RMAN'' scope=spfile sql statement: alter system reset db_unique_name scope=spfile Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 2137886720 bytes Fixed Size oracle error from 2228200 bytes Variable Size 520093720 bytes Database Buffers 1610612736 bytes Redo Buffers 4952064 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "CLONEDB" RESETLOGS ARCHIVELOG MAXLOGFILES 192 MAXLOGMEMBERS 3 MAXDATAFILES 1024 MAXINSTANCES 32 MAXLOGHISTORY 16360 LOGFILE GROUP 1 ( '+asm_data01', '/oradata/CLONEDB/mzfccprd/onlinelog/group_1.315.818176805' ) SIZE 512 M REUSE, GROUP 2 ( '+asm_data01', '/oradata/CLONEDB/mzfccprd/onlinelog/group_2.259.818176815' ) SIZE 512 M REUSE DATAFILE '/oradata/CLONEDB/mzfccprd/datafile/system.261.818175365' CHARACTER SET WE8MSWIN1252 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 12/24/2014 18:27:14 RMAN-05501: aborting duplication of target database RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed ORA-00349: failure obtaining block size for '+asm_data01 RMAN> Solution: Login to the PROD and create the