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 AMHi 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.3
Both server/system - Oracle Solaris 11.1 SPARC
Both 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,
GROUP 2 ( '+prdcl01_reco_01', '+vdbcl01_data_01' ) SIZE 50 M REUSE,
GROUP 3 ( '+vdbcl01_data_01', '+prdcl01_reco_01' ) SIZE 50 M REUSE,
GROUP 4 ( '+vdbcl01_data_01', '+prdcl01_reco_01' ) SIZE 50 M REUSE,
GROUP 5 ( '+vdbcl01_data_01', '+prdcl01_reco_01' ) SIZE 50 M REUSE
DATAFILE
'+PRDCL01_DATA_01/ew2prd/datafile/system.5002.885775461'
CHARACTER SET WE8MSWIN1252
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/23/2015 00:46:45
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 '+vdbcl01_data_01'
I am out of idea here, what other things i need to do to get this working. please share your valuable views/suggestions/solutions. Thanks in advance.
Cheers.