Chris - Thanks. Sorry for the tirade, bad day, reading too fast, thinking
too slow. I checked my systems and I see the snapcf_SID.f files, one for
each database being backed up. I do not see the other files you mention. I
notice the mystery file names have a format quite close to your backup
format. I also notice the dates on the mystery files are today's date, so
something must have written to them. Did the size change as well? Is there
any possibility that another backup script is running? Maybe a cron job from
another userid. Have you verified that your RMAN backup files are getting
created in the expected location? You could also check the catalog for
additional backups. And just to be sure, you might connect to the target
database alone and check for backups. A record of recent backups are stored
in the controlfile even if you are using a catalog.
 
Glad you are enjoying Lawson's book.



Dennis Williams 
DBA, 40%OCP, 100% DBA 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-----Original Message-----
Sent: Tuesday, April 01, 2003 7:24 AM
To: Multiple recipients of list ORACLE-L



Dennis, 
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: 


#!/bin/sh 
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/[EMAIL PROTECTED] 
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''"; 
exit; 
EOF 
# 


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: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Reply via email to