| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN question....
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/disco_at_rep1.ruppman.com
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: Chris Stephens
INET: ChrisStephens_at_affina.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: ListGuru_at_fatcity.com (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
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |