RE: Copies of control file in dbs directory

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Fri, 12 Aug 2005 14:54:43 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD5F04@ecogenemld50.Org.Collegeboard.local>

I agree with Dennis

"Copies of the CF are being generated into the dbs directory." "client is complaining about performance."

Sounds to me like a backup is running.

>>So how do I turn off “Control autobackup” ?

Well that might not be the issue...the issue is running a backup at all, right?

I think your issue is not "CONTROLFILE AUTOBACKUP" but the "Snapshot Control File" automatically created for and by Oracle during RMAN backups.

This might help;

---

CONTROLFILE AUTOBACKUP

---

CONFIGURE CONTROLFILE AUTOBACKUP ON | OFF | CLEAR;

---

Snapshot Control File:

---

A copy of a database's control file taken by Recovery Manager. RMAN uses the snapshot control file to read a consistent version of a control file when either resynchronizing the recovery catalog or backing up the control file. A snapshot control file is created by Recovery Manager using the same Oracle code that creates backup control files: ALTER DATABASE BACKUP CONTROL FILE TO 'location'. Determining the Snapshot Control File Location: When RMAN needs to resynchronize from a read-consistent version of the control file, it creates a temporary snapshot control file. The default name for the snapshot control file is port-specific. Use the set snapshot controlfile name command to change the name of the snapshot control file; subsequent snapshot control files that RMAN creates use the name specified in the command.

        For example, start RMAN and then enter: set snapshot controlfile name to '/oracle/dba/prod/snap_prod.ctl';

hth

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Igor Neyman Sent: Fri 8/12/2005 2:48 PM
To: lawrence.wolfson_at_acxiom.com; Dennis Williams Cc: oracle-l_at_freelists.org
Subject: RE: Copies of control file in dbs directory  

In RMAN execute :  

CONFIGURE CONTROLFILE AUTOBACKUP OFF; Igor Neyman

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson Larry - lwolfs
Sent: Friday, August 12, 2005 2:40 PM
To: Dennis Williams
Cc: oracle-l_at_freelists.org
Subject: RE: Copies of control file in dbs directory

Thanks Dennis.  

I looked in cron again and didn't see any RMAN jobs, but I remembered I'd seen the following in the alert log  

drop tablespace M11_DATA including contents and datafiles

  Deleted file /u03/oradata/m11_data01.dbf

 Starting control autobackup

 Control autobackup written to DISK device

 > handle '/oracle/9.2/dbs/c-2180204055-20050807-0f'

 Completed: drop tablespace M11_DATA including conten    

      So how do I turn off "Control autobackup" ?  

      Thanks  

      Larry

---

From: Dennis Williams [mailto:oracledba.williams_at_gmail.com] Sent: Friday, August 12, 2005 1:15 PM
To: Wolfson Larry - lwolfs
Cc: oracle-l_at_freelists.org
Subject: Re: Copies of control file in dbs directory  

Larry,  

>Copies of the CF are being generated into the dbs directory.
>Unfortunately, some at times when client is complaining about
>performance.
 

I have seen RMAN do this. There is a setting to autobackup the control file. I would keep searching for an RMAN job running somewhere, either through a cron job or an OEM job.  

Dennis Williams  

---

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 12 2005 - 14:00:28 CDT