Friday, March 3, 2017

oerr ora 19809

To got a hit with oerr ora 19809 so I checked 
oerr ora 19809
19809, 00000, "limit exceeded for recovery files"
//*Cause: The limit for recovery files specified by the
//        DB_RECOVERY_FILE_DEST_SIZE was exceeded.
// *Action: There are five possible solutions:
//          1) Take frequent backup of recovery area using RMAN.
//          2) Consider changing RMAN retention policy.
//          3) Consider changing RMAN archived log deletion policy.
//          4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
//          5) Delete files from recovery area using RMAN.


I checked my v$recovery_file_dest;

select space_limit/1024/1024/1024 GB,space_used/1024/1024/1024 GB from v$recovery_file_dest;

Then added more GB to it.


ALTER SYSTEM DB_RECOVERY_FILE_DEST_SIZE = 300G scope=both;


No comments: