Re: RMAN question on the copy of the controlfile under $ORACLE_HOME/dbs directory
- From: Wayne Smith <wts@xxxxxxxxx>
- To: ashoke.k.mandal@xxxxxxxxxxxxx
- Date: Fri, 21 Oct 2011 09:30:06 -0400
If you do the following from an "oracle" user session, you'll see what is
set to cause these to be placed there:
- . oraenv
- (enter name of your database)
- rman
- connect target
- show all;
- quit
The "show all" will display your rman configuration. rman is really
excellent in that these settings are displayed in a form that is the correct
syntax to change the setting!
As others have said, these are control file auto backups. You may also have
another form of control file backup in file names that might start with
"snapcf". If the path to "dbs" is specified, simply issue the rman command
"configure" command as you see from the "show all", but with the path you
wish to use. If something like "%F" is all that is used, look up the syntax
in the rman documentation.
By the way, these are backup files. If you don't want any of them, and
don't need them by policy, just erase the ones you don't want. Also, I
don't know if these (control file auto backup) files are automatically
erased by your rman retention policies ... if not, you may have old files
you can erase to regain free space.
Hope this helps!
Cheers, Wayne
Wayne T Smith - wts@xxxxxxxxx - UMS-ITS-S&O -
- LISTSERV®, the software that pioneered opt-in email list communication,
is now 25 years old.
On Tue, Oct 18, 2011 at 6:26 PM, Mandal, Ashoke <
ashoke.k.mandal@xxxxxxxxxxxxx> wrote:
> 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
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
