We are going to follow some steps to solve the “ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN”.
run{
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate auxiliary channel stby type disk;
duplicate target database for standby from active database
spfile
parameter_value_convert 'oraclehelpdb01','oraclehelpdb02'
set db_name='oraclehelpdb01'
set db_unique_name='oraclehelpdb02'
set db_file_name_convert='/oraclehelpdb01/','/oraclehelpdb02/'
set log_file_name_convert='/oraclehelpdb01/','/oraclehelpdb02/'
set control_files='+DATA'
set log_archive_max_processes='4'
set standby_archive_dest = '/holding/oraclehelpdb02/standby_logs'
set log_archive_dest_1 = 'LOCATION=/holding/oraclehelpdb02/archive_logs valid_for=(online_logfile, all_roles)'
set log_archive_dest_2 = 'LOCATION=/holding/oraclehelpdb02/standby_logs valid_for=(standby_logfile, standby_role)'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(oraclehelpdb01,oraclehelpdb02)'
;
}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/19/2017 17:25:50
RMAN-05501: aborting duplication of target database
RMAN-06136: ORACLE error from auxiliary database: ORA-00200: control file could not be created
ORA-00202: control file: '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contact
Solution: In my case when I checked the permission of $ORACLE_HOME and $GRID_HOME and the permission was incorrect which caused the problem. After fixing the permission it works fine.
[root@oraclehelpdb02 ~]$ ls -al /opt/oracle/product/11.2.0.3/bin/oracle -rwxr-x--x 1 oracle oinstall 232512956 Apr 17 12:01 /opt/oracle/product/11.2.0.3/bin/oracle [root@oraclehelpdb02 ~]$ ls -al /opt/grid/product/11.2.0.3/bin/oracle -rwxr-x--- 1 grid oinstall 203972891 Jun 17 2012 /opt/grid/product/11.2.0.3/bin/oracle
The file permission should be “-rwsr-s–x”. I have change the permission using chmod 6751
[root@oraclehelpdb02 ~]$ chmod 6751 /opt/oracle/product/11.2.0.3/bin/oracle [root@oraclehelpdb02 ~]$ chmod 6751 /opt/grid/product/11.2.0.3/bin/oracle [root@oraclehelpdb02 ~]$ ls -al /opt/oracle/product/11.2.0.3/bin/oracle -rwxr-x--x 1 oracle oinstall 232512956 Apr 17 12:01 /opt/oracle/product/11.2.0.3/bin/oracle [root@oraclehelpdb02 ~]$ ls -al /opt/grid/product/11.2.0.3/bin/oracle -rwsr-s--x 1 grid oinstall 203972891 Jun 17 2012 /opt/grid/product/11.2.0.3/bin/oracle
Thank you for giving your valuable time.
Thought of the day!
“The Pessimist Sees Difficulty In Every Opportunity. The Optimist Sees Opportunity In Every Difficulty.” – Winston Churchill
Thank you for giving your valuable time to read the above information.
For More Detail , You can join us follow:
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
