RE: Copies of control file in dbs directory

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 12 Aug 2005 14:55:08 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF35FAF5@EXCNYSM0A1AJ.nysemail.nyenet>

Larry,  

Control file auto backups are registered via Rman.  

Start Rman on your database server. Connect to your database and rman repository (if you are using it).  

Type SHOW ALL;  

You should see an entry for "CONFIGURE CONTROLFILE AUTOBACKUP ON;". This automatically performs a controlfile backup when you run any Rman backup, and also when you change the database structure (like add a tablespace).  

Also look at the CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '{file name}' entry.

This probably says '/oracle/9.2/dbs/%F' or something like that. These two params are generating the controlfile backups for you.  

You can change either of these by simply entering them again; Like :

CONFIGURE CONTROLFILE AUTOBACKUP OFF; CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'new disk directory';  

I would leave the autoback "ON". You probably want to change the disk directory and place this backup someplace where you can manage it. I put all of these in a directory and have them backed up to tape with my Rman disk backups.  

Tom  

---

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 - 13:59:17 CDT