RE: Copies of control file in dbs directory
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <ineyman@xxxxxxxxxxxxxx>, <lawrence.wolfson@xxxxxxxxxx>, "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- Date: Fri, 12 Aug 2005 14:54:43 -0400
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@xxxxxxxxxxxxx on behalf of Igor Neyman
Sent: Fri 8/12/2005 2:48 PM
To: lawrence.wolfson@xxxxxxxxxx; Dennis Williams
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Copies of control file in dbs directory
In RMAN execute :
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
Igor Neyman
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfson Larry -
lwolfs
Sent: Friday, August 12, 2005 2:40 PM
To: Dennis Williams
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Friday, August 12, 2005 1:15 PM
To: Wolfson Larry - lwolfs
Cc: oracle-l@xxxxxxxxxxxxx
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.
Other related posts: