Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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

share|improve this question
    
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 Dec 19 '12 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 Dec 26 '12 at 21:40
add comment

1 Answer

Here is Oracle's answer.

Basically your options are these:

share|improve this answer
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 Dec 26 '12 at 21:28
    
@miracle173 Good tip. –  Leigh Riffel Dec 26 '12 at 21:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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