Wednesday 1 July 2020

Unable to open db after restore due to Orphaned FLASHBACK LOGs

Error while opening database after restore , below error from alert log 

Alert log:
NOTE: dependency between database Proddb and diskgroup resource ora.DATAC1.dg is established
2020-05-09T07:37:19.248472-08:00
Errors in file /u02/app/oracle/diag/rdbms/proddb/PRODDB01/trace/PRODDB01_ora_353006.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
2020-05-09T07:37:19.248579-08:00
*************************************************************
WARNING: Files created after time 05/09/2020 07:29:35 may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result of a crash during file creation.
*************************************************************
.... (PID:353006): Redo network throttle feature is disabled at mount time
2020-05-09T07:37:19.330604-08:00
Network Resource Management enabled for Process LGWR (pid 348793) for Exadata I/O
Successful mount of redo thread 1, with mount id 3269264632
2020-05-09T07:37:19.859145-08:00

Connect and check logs in recovery area 

[oracle@ ~]$ rman target /
connected to target database: PRODDB (DBID=3269264632, not open)

RMAN>  catalog recovery area;
using target database control file instead of recovery catalog
searching for all files in the recovery area

List of Files Unknown to the Database
=====================================
File Name: +RECOC1/Proddb/FLASHBACK/log_1.281.1054940835
File Name: +RECOC1/Proddb/FLASHBACK/log_2.279.1054940843
File Name: +RECOC1/Proddb/FLASHBACK/log_3.272.1054940925
File Name: +RECOC1/Proddb/FLASHBACK/log_4.269.1054940935

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
no files cataloged

List of Files Which Were Not Cataloged
=======================================
File Name: +RECOC1/Proddb/FLASHBACK/log_1.281.1054940835
  RMAN-07518: Reason: Foreign database file DBID: 3273557004  Database Name: PRODDB
File Name: +RECOC1/Proddb/FLASHBACK/log_2.279.1054940843
  RMAN-07518: Reason: Foreign database file DBID: 3273557004 Database Name: PRODDB
File Name: +RECOC1/Proddb/FLASHBACK/log_3.272.1054940925
  RMAN-07518: Reason: Foreign database file DBID: 3273557004 Database Name: PRODDB
File Name: +RECOC1/Proddb/FLASHBACK/log_4.269.1054940935
  RMAN-07518: Reason: Foreign database file DBID: 3273557004 Database Name: PRODDB

Orphaned FLASHBACK LOGs have been created in the Flash Recovery Area with old DBID , we have to delete those unwanted logs

Connect to asm as grid user and remove Orphaned logs
ASMCMD> rm log_1.281.1054940835
ASMCMD> rm log_2.279.1054940843
ASMCMD> rm log_3.272.1054940925
ASMCMD> rm log_4.269.1054940935

Issue Solved after removing Orphaned logs, able to open database without any issues

No comments:

Post a Comment