Articles Tagged: ORA-17502: ksfdcre:4

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)’ ; […]