Hi All,
I would to seek help on the following FRA issue.
I am using oracle 10g on Linux Redhat 4.2 machine. This 3 days I have encounter the following issue db_recovery_file_dest_size of 12884901888 bytes is 100.00% used and has 0 remaining bytes available.
What I do is, I move the .dbf file to my local disk (with total size almost 11-12g), run crosscheck and delete expired copy.
Then the space will be clear. But in the next day, when running schedule backup at 2 AM, it will give this following warning again.
-> db_recovery_file_dest_size of 12884901888 bytes is 100.00% used and has 0 remaining bytes available.
Can anyone help me to guide step by step on how to manage and how to check in the related issue.
How should I remove the file?If not delete the physical, when I doing crosscheck copy and delete the expired copy, it will show 'specification does not match any archive log in the recovery catalog' and nothing happen.