Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Copies of control file in dbs directory
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;
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 12 2005 - 14:00:28 CDT
![]() |
![]() |