There are some issues with recover control files in RESETLOGS mode after executing 'ALTER DATABASE BACKUP CONTROLFILE TO TRACE',
According to instruction, we need to register log files with using the following comamnd
ALTER DATABASE REGISTER LOGFILE ''
But sometimes the following error occurred
And the work around is using the following command instead
ALTER DATABASE REGISTER PHYSICAL LOGFILE
According to instruction, we need to register log files with using the following comamnd
ALTER DATABASE REGISTER LOGFILE ''
But sometimes the following error occurred
ORA-00604: error occurred at recursive SQL level" error on "ALTER DATABASE REGISTER LOGFILE '/<path>/1_234_636797930.dbf'And the work around is using the following command instead
ALTER DATABASE REGISTER PHYSICAL LOGFILE
