RE: rman log
- From: "John Hallas" <john.hallas@xxxxxxxxxx>
- To: <Randy.Steiner@xxxxxxxx>, "oracle_l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Mar 2008 14:44:50 -0000
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@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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
- Follow-Ups:
- RE: rman log
- From: John Hallas
- References:
- rman log
- From: Steiner, Randy
Other related posts:
- » rman log
- » RE: rman log
- » RE: rman log
- RE: rman log
- From: John Hallas
- rman log
- From: Steiner, Randy