RE: Getting started with RMAN

Here's a shell script that I have used and have had to recover tablespace a few 
times because of crashed drives.

I elected to receive email on successful backup because at one time, the mail 
daemon was dead and no mail was coming through.

This serves as a test that email is still working.

This validates a restore can be performed from backup - restore database 
validate;

You may have to modify script a little to source the environment - oraenv


#!/bin/sh -x

DN=`dirname $0`
BN=`basename $0`
SID=${1:?"---> USAGE: $DN/$BN <ORACLE_SID>"}

ORATAB=/var/opt/oracle/oratab
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
NLS_LANG="AMERICAN_AMERICA.UTF8"
export ORATAB NLS_DATE_FORMAT NLS_LANG

ORACLE_SID=$1
ORACLE_HOME=`grep ${ORACLE_SID} $ORATAB|awk -F: '{print $2}'`
export ORACLE_SID ORACLE_HOME

day=`date '+%a'`
OUTF=/backup/log/$day.$ORACLE_SID.$BN.log
RMAN=$ORACLE_HOME/bin/rman
$RMAN msglog $OUTF > /dev/null << END
  connect target;
  configure controlfile autobackup format for device type disk to 
'/oracle_backup/${ORACLE_SID}/${ORACLE_SID}_%F.bck';
  configure channel device type disk maxopenfiles=8;
  backup as compressed backupset
  check logical database
  tag="dbf"
  filesperset 8
  format '/oracle_backup/${ORACLE_SID}/dbf_%d_%T_%U'
  plus archivelog delete input
  filesperset 16
  tag="arc"
  format '/oracle_backup/${ORACLE_SID}/arc_%d_%T_%U';
  crosscheck archivelog all;
  crosscheck backup;
  delete noprompt obsolete;
  delete noprompt expired archivelog all;
  delete noprompt expired backup;
  list backup;
  restore database validate;
  exit
END
if [ `egrep -ic 'RMAN-|error|fail' $OUTF` != 0 ]; then
  mailx -s "FAILED: $BN $ORACLE_SID" dba@xxxxxxxxx < $OUTF
else
  mailx -s "COMPLETED: $BN $ORACLE_SID" dba@xxxxxxxxx < /dev/null
fi
exit 


Michael Dinh : XIFIN
 
NOTICE OF CONFIDENTIALITY - This material is intended for the use of the 
individual or entity to which it is addressed, and may contain information that 
is privileged, confidential and exempt from disclosure under applicable laws.  
BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION 
(PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS 
FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN, 
EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR 
OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE.  If the reader of this 
email (and attachments) is not the intended recipient, you are hereby notified 
that any dissemination, distribution or copying of this communication is 
strictly prohibited. Please notify the sender of the error and delete the 
e-mail you received. Thank you.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Janine Sisk
Sent: Tuesday, May 04, 2010 2:41 PM
To: oracle-l L
Subject: Getting started with RMAN

Most of the feedback on my archive log deletion question (thank you for all the 
answers!) focused on making sure that your last backup is good before deleting 
any log files.  This makes perfect sense, but I would rather not write that 
script if I don't have to (define "backup is good" for all cases :).  The 
second most common piece of advice was to let RMAN do it as part of the process 
of backing up.

I just took a quick look at Oracle's Backup and Recovery doc to see what I 
would be getting myself into in using RMAN.  Since this is an Amazon EC2 
instance, there's no tape drive and my only choice is to back up to "disk" 
(really an EBS volume created for this purpose).

From a quick scan, this doc looks like most technical docs, which is to say it 
tells you all about what you can do, but not what you should do.  I don't want 
to read this entire thing from end to end and then figure out the best 
strategy;  I'm sure someone else (or quite a few someone elses) have already 
done that.

So... what's your favorite book/website/other resource on configuring RMAN for 
the first time?

Thanks in advance,

janine

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: