RE: rman log

I didn't realise it did produce a log file unless you have a msglog command set up  

I have a shell script to run the backup commands and it looks like this :- (ps this script has been used to try out various options which is why there are so many commented out lines)  

#!/bin/ksh
 

export ORACLE_HOME=/u00/app/oracle/product/11.1.0/db_2

export ORACLE_SID=TEST1

export PATH=$PATH:$ORACLE_HOME/bin

export NLS_DATE_FORMAT='DD-MON-YY HH24:MI:SS'  

export DATE=$(date +%Y-%m-%d)  

rman target backup_admin/xxxxxxx catalog rman/xxxxxxx_at_server msglog /export/backups/rman/11g/logs/rman_full_backup_db_online_TEST1_${DATE}.l og <<EOF  

#backup AS COMPRESSED BACKUPSET database ;

#backup AS COMPRESSED BACKUPSET archivelog all delete input ;

backup AS COMPRESSED BACKUPSET database plus archivelog delete input;

#backup AS COMPRESSED BACKUPSET database;

#backup database;

#backup archivelog all delete input;

#BACKUP INCREMENTAL LEVEL 0 TAG = WEEKLY DATABASE;

#delete noprompt force obsolete;
 

#Change archivelog all validate
 

exit;

EOF   exit      

www.jhdba.wordpress.com

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steiner, Randy Sent: 20 March 2008 14:18
To: oracle_l
Subject: rman log  

I run rman from dbconsole and thus get no email alerts when backup is done or if there is an error.  

Does someone know where the log is stored so I can write a script against it?  

I am guessing it's in a table under sysman, but have not found anything so far.  

Thanks

Randy  

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