Yesterday, There was an issue with the Flashback Recovery Area. The FRA disk is full and when we try to connect as "sys as sysdba" or "rman target", the database hangs.
If you are looking for a solution to similar scenario then read on...
Check the disk space for total, available and used space using df command in linux.
move to the archivelog folder in the flash recovery area for the database and check for the old logs.
If you have set the retention window to 7 days for example or have a backup taken 2-3 days before then you can remove the old logs to reclaim the disk space.
Now try to connect using the RMAN
rman target nocatalog
execute the crosscheck command to verify the backups and delete expired backups and logs.
Note, By removing the logs at OS level will not update the data dictionary hence the crosscheck command needs to be executed to cross verify the logs and files.
No comments:
Post a Comment