RE: RMAN question on the copy of the controlfile under $ORACLE_HOME/dbs directory
- From: "Chitale, Hemant Krishnarao" <Hemant.Chitale@xxxxxx>
- To: <ashoke.k.mandal@xxxxxxxxxxxxx>
- 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
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mandal, Ashoke
Sent: Wednesday, October 19, 2011 6:27 AM
To: oracle-l-bounce@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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,
Ashoke
[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
--
//www.freelists.org/webpage/oracle-l
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
