天天看點

ora 19804 與ora 19809 錯誤及解決

ora 19804 與ora 19809 錯誤及解決
ora 19804 與ora 19809 錯誤及解決

[oracle@solbbk:~]$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:The error is accompanied by 19804. See message 19804 for further

//        details.

[oracle@solbbk:~]$oerr ora 19804

19804, 00000, "cannot reclaim %s bytes disk space from %s limit"

// *Cause: Oracle cannot reclaim disk space of specified bytes from the

//         DB_RECOVERY_FILE_DEST_SIZE limit.

// *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 archivelog deletion policy.

//          4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.

//          5) Delete files from recovery area using RMAN.

ora 19804 與ora 19809 錯誤及解決
ora 19804 與ora 19809 錯誤及解決