Transient files in the FRA
Date: Thu, 4 Dec 2014 13:51:40 +0000
Message-ID: <EC65ECF8123FEE4D8FC5B212637C304001673232AF67_at_EXCH1.morrisonsplc.co.uk>
We have had several instances where space appears to be reclaimable in the FRA and yet the database has hung because it has run out of space. I am looking to try and write a standard operating procedure that covers what we do when FRA is alerted as running out of space and how we ensure that the reclaimable space in the FRA is actually really going to be used.
The following rules govern when files become eligible for deletion from the recovery area:
- Permanent files (files used by the database instance. Control file , Online Redo log files) are never eligible for deletion.
- Files that are obsolete under the retention policy are eligible for deletion.
- Transient files (All files that are not permanent are transient. Archived redo log, Foreign archived redo log, Image copies of datafiles , Backup pieces, Flashback logs) that have been copied to tape are eligible for deletion.
- Archived redo logs are not eligible for deletion until all the consumers of the logs have satisfied their requirements.
I am interested in what consumers of the log files might be in point 4. Situations I can think of is if GoldenGate has a long-running transaction which it think might still need an old log file (the system where the situation occurred does have GG extracting and forwarding on transactions but we have bnot integrated it with RMAN) or if a LogMiner session is running. I am not sure I can think of any other situations. Obviously the RMAN retention policy manages when files become obsolete but they will not show
Can anybody assist?
Thanks
John
www.jhdba.wordpress.com
Wm Morrison Supermarkets Plc is registered in England with number 358949. The registered office of the company is situated at Gain Lane, Bradford, West Yorkshire BD3 7DL. This email and any attachments are intended for the addressee(s) only and may be confidential.
If you are not the intended recipient, please inform the sender by replying to the email that you have received in error and then destroy the email. If you are not the intended recipient, you must not use, disclose, copy or rely on the email or its attachments in any way.
This email does not constitute a contract in writing for the purposes of the Law of Property (Miscellaneous Provisions) Act 1989.
Our Standard Terms and Conditions of Purchase, as may be amended from time to time, apply to any contract that we enter into. The current version of our Standard Terms and Conditions of Purchase is available at: http://www.morrisons.co.uk/gscop
Although we have taken steps to ensure the email and its attachments are virus-free, we cannot guarantee this or accept any responsibility, and it is the responsibility of recipients to carry out their own virus checks.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 04 2014 - 14:51:40 CET