To got a hit with oerr ora 19809 so I checked
$ oerr ora 19809
$ 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:
Post a Comment