we face this issue, while trying to register the archive log file with in database.
Error:-
alter database register logfile '/u03/orarch/orcl/standby/arch_1_2200_923546327.arc';
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level
Solution 1:
ALTER DATABASE REGISTER OR REPLACE LOGFILE '/u03/orarch/orcl/standby/arch_1_2200_923546327.arc';
If above fails.
Solution 2:
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u03/orarch/orcl/standby/arch_1_2200_923546327.arc';
if above fails
Solution 3:
Rman>Connect target/
Rman> catalog start with '/u03/orarch/orcl/standby/';
