Oracle-L: RE: RMAN question.... (figured out if anywone is interested)....w

From: Chris Stephens <ChrisStephens_at_affina.com>
Date: Wed, 02 Apr 2003 08:08:57 -0800
Message-ID: <F001.00578161.20030402080857@fatcity.com>

Apparently the command:

backup database format '/oracle_backup/ASTU/%U' (current controlfile);

..........places the controlfile in $ORACLE_HOME/dbs, but:

backup database format '/oracle_backup/ASTU/%U' include current controlfile;

..........places the contrlofile in the specified directory along with all other backup pieces.

Thanks for all input.

Chris

And now for the next step...

.....anyone have a script handy to query the catalog directly and validate all backups ran successfully and send the info of success/failure in an email?

.....Thanks!

-----Original Message-----

Sent: Tuesday, April 01, 2003 8:29 AM
To: Multiple recipients of list ORACLE-L

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.
dwilliams_at_lifetouch.com

-----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/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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

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: 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).

--

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 services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message