ORA-00604: error occurred at recursive SQL level "alter database register logfile"

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/';