I agree, and would add the init.ora, tnsnames.ora, sqlnet.ora and listener.ora files to backups as well. These don 't take much backup space, but can save time in a recovery.
Chris Stephens <ChrisStephens@(protected) > wrote:I agree. I 'll definitely be changing that.
The archive destination is backed up on a nightly basis as well via straight
omniback. I guess that the thought was in the event of a restore, we would
place the last several days worth of archive logs in the location. We also
have a process that picks up new archive logs every hour and places them on
a remote server.
Thanks you VERY much for the suggestions though.
chris
-- --Original Message-- --
From: Mercadante, Thomas F [mailto:thomas.mercadante@(protected)]
Sent: Wednesday, February 25, 2004 9:07 AM
To: 'oracle-l@(protected) '
Subject: RE: General Question about RMAN verification procedures...
Chris,
I agree with Ron.
I use Rman to backup and delete the archive log files. My backup runs in
three steps;
This way if an archivelog file is needed during recovery, Rman knows about
it and asks for it. Right now, if you ever need an archivelog file, you are
screwed. And lets face it, who knows what Rman will ask for when it comes
to recovery. I think you are taking a slight risk in your current approach.
Tom Mercadante
Oracle Certified Professional
-- --Original Message-- --
From: Ron Rogers [mailto:RROGERS@(protected)]
Sent: Wednesday, February 25, 2004 9:57 AM
To: oracle-l@(protected)
Subject: Re: General Question about RMAN verification procedures...
Chris,
What would happen if the RMAN backup failed and the next step is executed?
The archlogs over 2 days old would be deleted?
You can have rman perform the archiveing of the archivelogs and delete them
after they are archived with a day reference like you have. I don 't have my
manual handy right now but it is in the books as how to do it in 8i.
Ron
> > > ChrisStephens@(protected) 02/25/2004 9:40:14 AM > > >
After realizing that I 'm the only dba left standing at this company, I 've
decided that our backup and recovery procedures need revisiting.
Specifically the way in which we verify our backups ran successfully each
night.
We currently have five 8.1.7.2 oltp 's in archivelog mode that are backed up
via RMAN using a recovery catalog, and four 9.2.0.4 warehouse/ods databases
in noarchivelog mode that are backed up via RMAN using the individual
control files.
I am confident in the recoverability of our backups*they 've been tested
several times*as long as they successfully complete. Currently I am emailed
the full output of each backup script for each database. We use 2 separate
scripts. 1 for oltp 's and 1 for warehouse.
This is all fine and dandy but to really keep up with it all, that means
scanning 9 backup logs each morning.
my question is this*for those of you using RMAN as your backup utility, how
do you ensure your backups complete successfully and are valid? Do you
query the catalog directly? Do you have a script that validates the
backups? Do you have a single email with nice discreet output for each
database? *.are you willing to share you scripts? *
*and while I 'm at it. *can anyone poke any holes in the following scripts?
*I know they aren 't as elegant as some*but they work and have been tested.
rm /oracle_backup/$ORACLE_SID/*
$ORACLE_HOME/bin/rman <set dbid={db id*so no one can mess with the tnsnames and screw with out
backups*it is well know that the dba group will have to change this in the
event of some event that would change the dbid}
connect target
connect catalog username/password@{recovery catalog db}
run{
allocate channel d1 type disk;
backup database format '/oracle_backup/$ORACLE_SID/%U ' include 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/$ORACLE_SID/prd1_ctl ' ' ";
exit;
EOF
#
find ${ARCH_DEST}*.arc -type f -mtime +2 | while read ARCH_LOG; do
echo "removing "$ARCH_LOG
rm $ARCH_LOG
done
rm /$ORACLE_SID/_backup/*
$ORACLE_HOME/bin/rman <connect target /
shutdown immediate
startup mount
backup database;
alter database open;
sql 'alter database backup controlfile to trace ';
exit; <
*.thanks for any help!!!
chris
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- -----
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want. <DIV >I agree, and would add the init.ora, tnsnames.ora, sqlnet.ora and listener.ora files to backups as well. These don 't take much backup space, but can save time in a recovery. <BR > <BR > <B > <I >Chris Stephens <ChrisStephens@(protected)> </I > </B > wrote:
<BLOCKQUOTE class=replbq style= "PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid " >I agree. I 'll definitely be changing that. <BR > <BR >The archive destination is backed up on a nightly basis as well via straight <BR >omniback. I guess that the thought was in the event of a restore, we would <BR >place the last several days worth of archive logs in the location. We also <BR >have a process that picks up new archive logs every hour and places them on <BR >a remote server. <BR > <BR >Thanks you VERY much for the suggestions though. <BR > <BR >chris <BR > <BR >-- --Original Message-- -- <BR >From: Mercadante, Thomas F [mailto:thomas.mercadante@(protected)] <BR >Sent: Wednesday, February 25, 2004 9:07 AM <BR >To: 'oracle-l@(protected) ' <BR >Subject: RE: General Question about RMAN verification procedures... <BR > <BR >Chris, <BR > <BR >I agree with Ron. <BR >I use Rman to backup and delete the archive log files. My backup runs in <BR >three steps; <BR > <BR >Database Backup <BR >Archive log Switch <BR >
Archive
Log backups <BR >Control file backups <BR > <BR >This way if an archivelog file is needed during recovery, Rman knows about <BR >it and asks for it. Right now, if you ever need an archivelog file, you are <BR >screwed. And lets face it, who knows what Rman will ask for when it comes <BR >to recovery. I think you are taking a slight risk in your current approach. <BR > <BR >Tom Mercadante <BR >Oracle Certified Professional <BR > <BR > <BR >-- --Original Message-- -- <BR >From: Ron Rogers [mailto:RROGERS@(protected)] <BR >Sent: Wednesday, February 25, 2004 9:57 AM <BR >To: oracle-l@(protected) <BR >Subject: Re: General Question about RMAN verification procedures... <BR > <BR > <BR >Chris, <BR >What would happen if the RMAN backup failed and the next step is executed? <BR >The archlogs over 2 days old would be deleted? <BR >You can have rman perform the archiveing of the archivelogs and delete them <BR >after they are archived with a day reference like you have. I don 't have my <BR >manual handy right now but it is in th
e books
as how to do it in 8i. <BR >Ron <BR > <BR > <BR >>>> ChrisStephens@(protected) 02/25/2004 9:40:14 AM >>> <BR >After realizing that I 'm the only dba left standing at this company, I 've <BR >decided that our backup and recovery procedures need revisiting. <BR >Specifically the way in which we verify our backups ran successfully each <BR >night. <BR > <BR >We currently have five 8.1.7.2 oltp 's in archivelog mode that are backed up <BR >via RMAN using a recovery catalog, and four 9.2.0.4 warehouse/ods databases <BR >in noarchivelog mode that are backed up via RMAN using the individual <BR >control files. <BR > <BR >I am confident in the recoverability of our backups*they 've been tested <BR >several times*as long as they successfully complete. Currently I am emailed <BR >the full output of each backup script for each database. We use 2 separate <BR >scripts. 1 for oltp 's and 1 for warehouse. <BR > <BR >This is all fine and dandy but to really keep up with it all, that means <BR >scanning 9 backup logs e
ach
morning. <BR > <BR > <WHEW! > <BR > <BR >my question is this*for those of you using RMAN as your backup utility, how <BR >do you ensure your backups complete successfully and are valid? Do you <BR >query the catalog directly? Do you have a script that validates the <BR >backups? Do you have a single email with nice discreet output for each <BR >database? *.are you willing to share you scripts? * <BR > <BR >*and while I 'm at it. *can anyone poke any holes in the following scripts? <BR >*I know they aren 't as elegant as some*but they work and have been tested. <BR > <BR > <BR > <BR >OLTP: <BR > <BR >#!/bin/sh <BR >export ORACLE_HOME=/u01/app/oracle/product/8.1.7 <BR >export ORACLE_SID={DB SID} <BR >export ARCH_DEST=/u01/app/oracle/admin/$ORACLE_SID/arch/ <BR > <BR >rm /oracle_backup/$ORACLE_SID/* <BR >$ORACLE_HOME/bin/rman < <EOF <BR >set dbid={db id*so no one can mess with the tnsnames and screw with out <BR >backups*it is well know that the dba group will have to change this in the <BR >event of some event that would change
the
dbid} <BR >connect target <BR >connect catalog username/password@{recovery catalog db} <BR >run{ <BR >allocate channel d1 type disk; <BR >backup database format '/oracle_backup/$ORACLE_SID/%U ' include current <BR >controlfile; <BR >} <BR >sql "alter system switch logfile "; <BR >sql "alter system archive log all "; <BR >sql "alter database backup controlfile to trace "; <BR >sql "alter database backup controlfile to <BR > ' '/oracle_backup/$ORACLE_SID/prd1_ctl ' ' "; <BR >exit; <BR >EOF <BR ># <BR > <BR >find ${ARCH_DEST}*.arc -type f -mtime +2 | while read ARCH_LOG; do <BR >echo "removing "$ARCH_LOG <BR >rm $ARCH_LOG <BR >done <BR > <BR >Warehouse: <BR > <BR >#!/bin/sh <BR >export ORACLE_HOME=/u01/app/oracle/product/9.2.0 <BR >export ORACLE_SID=PWH1 <BR > <BR >rm /$ORACLE_SID/_backup/* <BR >$ORACLE_HOME/bin/rman < <EOF <BR >connect target / <BR >shutdown immediate <BR >startup mount <BR >backup database; <BR >alter database open; <BR >sql 'alter database backup controlfile to trace '; <BR >exit; < <EOF <BR > <BR > <BR >*.thanks for any
help!!! <BR > <BR >chris <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please see the official ORACLE-L FAQ: http://www.orafaq.com <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To unsubscribe send email to: oracle-l-request@(protected) <BR >put 'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at http://www.freelists.org/archives/oracle-l/ <BR >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <BR > <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please see the official ORACLE-L FAQ: http://www.orafaq.com <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To unsubscribe send email to: oracle-l-request@(protected) <BR >put 'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at http://www.freelists.org/archives/oracle-l/ <BR >FAQ is at
http://www.freelists.org/help/fom-serve/cache/1.html <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please see the official ORACLE-L FAQ: http://www.orafaq.com <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To unsubscribe send email to: oracle-l-request@(protected) <BR >put 'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at http://www.freelists.org/archives/oracle-l/ <BR >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >Please see the official ORACLE-L FAQ: http://www.orafaq.com <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ <BR >To unsubscribe send email to: oracle-l-request@(protected) <BR >put 'unsubscribe ' in the subject line. <BR >-- <BR >Archives are at
http://www.freelists.org/archives/oracle-l/ <BR >FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html <BR >-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- -- </BLOCKQUOTE > </DIV > <p > <hr SIZE=1 >
Do you Yahoo!? <br >
<a href= "http://us.rd.yahoo.com/mailtag_us/*http://antispam.yahoo.com/tools?tool=1 " >Yahoo! Mail SpamGuard </a > - Read only the mail you want. </a >
