Standby database Troubleshooting

------------------------------------------
LogFileNameConvert = Log_File_Name_Convert

DbFileNameConvert  = db_file_name_convert

----------------------------------------------

To remove the  log_archive_dest_2

--alter system set log_archive_dest_2=" ";

----------------------------------------------
If you get an error like folder is not there.
follow below steps
1. Create the folder as requests.
2. Issue the below from standby
select * from v$recover_file where error like '%FILE%';
get the file name and execute below
select file#,name from v$datafile where file#=5;
 and execute the above query from primary
select file#,name from v$datafile where file#=5;
so will understand the miss match
Now
Execute below from standby
alter database create datafile '/u01/app/oracle/product/11.2.0/db_1/dbs/UNNAMED00005' as '/u01/app/oracle/oradata/dell/hasaral01.dbf';
alter database recover managed standby database disconnect from session;
change the below parameter if get an error when adding a datafile—
on standby
alter system set standby_file_management=auto;
sho parameter standby;
-----------------------------------------------------