Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN question....

RE: RMAN question....

From: Chris Stephens <>
Date: Tue, 01 Apr 2003 05:23:38 -0800
Message-ID: <>

I wasn't actually restoring the control file. Only 'validating' that RMAN could do it. I also backup the control file several other ways and would likely never ask RMAN to perform that function. The only reason I issued 'restore controlfile validate' was because it would help me figure out what those mystery files are for. I just checked the directory and there are 3 more files with similar names corresponding to the 3 databases we back up on that machine. I need to talk to the other DBA and find out if he has been manually deleting them because I haven't noticed this and we have been using RMAN for over a month now.

In addition, I don't believe these are the snapshot control files as there are 3 other files in $ORACLE_HOME/dbs named:

-rw-r----- 1 oracle dba 41213952 Apr 1 00:35 snapcf_ASTU.f
-rw-r----- 1 oracle dba 14376960 Apr 1 00:08 snapcf_PRD1.f
-rw-r----- 1 oracle dba 16281600 Apr 1 00:36 snapcf_PRD2.f

The files in question are:

-rw-r----- 1 oracle dba 16290816 Apr 1 00:36 26eje5g8_1_1
-rw-r----- 1 oracle dba 14394368 Apr 1 00:08 28eje3r5_1_1
-rw-r----- 1 oracle dba 41231360 Apr 1 00:35 2seje5e5_1_1

They seem to have corresponding file sizes. I just don't see what statement in my simple little scripts would cause the files to be written there.

Again here is the backup script I use:

export ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_SID=ASTU
export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/

rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman <<EOF
set dbid=1337318309
connect target
connect catalog rman_cat/ run{
allocate channel d1 type disk;
backup database format '/oracle_backup/ASTU/%U' (current controlfile);
sql "alter system switch logfile";
sql "alter system archive log all";
sql "alter database backup controlfile to trace"; sql "alter database backup controlfile to ''/oracle_backup/ASTU/astu_ctl''";

Thanks for the input Dennis!!

Ps. I read your review of "The Art and Science of Oracle Performance Tuning" on amazon and decided to give it a try myself. I'm about 60 pages into it. It is easily the best read of any Oracle text I have come across. I definitely agree it belongs on everyone's bookshelf!!!

[Chris Stephens]


Please see the official ORACLE-L FAQ:

Author: Chris Stephens

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 01 2003 - 07:23:38 CST

Original text of this message