0

RMAN gives me this error how should i resolve this issue:


    ORA-19815: WARNING: db_recovery_file_dest_size of 7516192768 bytes is 100.00 used, and has 0 remaining bytes available.

Thanks in advance

2
  • As the warning says, the recovery area is full. You don't say if this is located on a file system or perhaps in ASM, but a typical solution would be to delete some old archive logs or backup sets.
    – Roy
    Commented Dec 19, 2012 at 13:09
  • can you show us the output of SELECT * FROM V$RECOVERY_FILE_DEST; and SELECT * FROM V$RECOVERY_AREA_USAGE? SELECT NAME FROM V$RECOVERY_FILE_DEST; returns the name of the directory of the recovery file area. Can you show us the size of the disk/filesystem of the fast recovery area (e.g. by df -k fast_recovery_area_directory if it is a unix system)? It also would be useful to show the output of the command SHOW RETENTION POLICY; in rman.
    – miracle173
    Commented Dec 26, 2012 at 21:40

1 Answer 1

2

Here is Oracle's answer.

Basically your options are these:

2
  • 1
    +1 but it makes sense to check first which files allocate how much space in the fast recovery area by checking the output of SELECT * FROM V$RECOVERY_AREA_USAGE
    – miracle173
    Commented Dec 26, 2012 at 21:28
  • @miracle173 Good tip. Commented Dec 26, 2012 at 21:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.