RE: RMAN question on the copy of the controlfile under $ORACLE_HOME/dbs directory
Date: Wed, 19 Oct 2011 10:51:43 +0800
I suppose that you have multiple files from 22-May to 19-Oct (you've listed two files of 22-May). These are likely controlfile autobackups being created frequently if you have either of these running very frequently :
a. RMAN Backups running frequently b. CREATE / ALTER TABLESPACE commands that add datafiles c. DROP TABLESPACE commands that drop datafiles
Hemant K Chitale
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mandal, Ashoke Sent: Wednesday, October 19, 2011 6:27 AM To: oracle-l-bounce_at_freelists.org; oracle-l_at_freelists.org Subject: RMAN question on the copy of the controlfile under $ORACLE_HOME/dbs directory
We are having c- files under the ORACLE_HOME/dbs directory on regular basis and these are pretty big to fill up the filesystem.
-rw-rw---- 1 oracle oinstall 15564800 May 22 18:08 c-3963933903-20110522-03
-rw-rw---- 1 oracle oinstall 15564800 May 22 23:09 c-3963933903-20110522-04
Q1. Are these created by RMAN? Q2. How to stop these files being written to ORACLE_HOME/dbs directory? Q3. What will be the impact if we delete these files from ORACLE_HOME/dbs directory? Q4. Why these c-* files are not generated under ORACLE_HOME/dbs directory for other ORACLE_HOME?
Appreciate your help in advance,
[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.
To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com
This email and any attachments are confidential and may also be privileged. If you are not the addressee, do not disclose, copy, circulate or in any other way use or rely on the information contained in this email or any attachments. If received in error, notify the sender immediately and delete this email and any attachments from your system. Emails cannot be guaranteed to be secure or error free as the message and any attachments could be intercepted, corrupted, lost, delayed, incomplete or amended. Standard Chartered PLC and its subsidiaries do not accept liability for damage caused by this email or any attachments and may monitor email traffic.
Standard Chartered PLC is incorporated in England with limited liability under company number 966425 and has its registered office at 1 Aldermanbury Square, London, EC2V 7SB.
Standard Chartered Bank ("SCB") is incorporated in England with limited liability by Royal Charter 1853, under reference ZC18. The Principal Office of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In the United Kingdom, SCB is authorised and regulated by the Financial Services Authority under FSA register number 114276.
If you are receiving this email from SCB outside the UK, please click http://www.standardchartered.com/global/email_disclaimer.html to refer to the information on other jurisdictions.
http://www.freelists.org/webpage/oracle-l Received on Tue Oct 18 2011 - 21:51:43 CDT