Monday, May 30, 2011

AO_backupevery hour

##00 * * * * /backup/oracle/PMCRCS20/rman/rman_AO_bkp_EveryHr.sh /tmp/rman_AO_bkp_EveryHr.log 2>&1

pbpmccracora1:/home/oracle>>cat /backup/oracle/PMCRCS20/rman/rman_AO_bkp_EveryHr.sh
export ORACLE_SID=PMCRCS21; export ORACLE_HOME=/home/oracle/PMCRCS20/product/dbms/10G; export PATH=$ORACLE_HOME/bin:$PATH
NOW=$(date +"%m-%d-%T")
rman target / cmdfile /backup/oracle/PMCRCS20/rman/rman_AO_bkp_EveryHr.rcv log /backup/oracle/PMCRCS20/rman/log/rman_AO_bkp_$NOW.log
pbpmccracora1:/home/oracle>>cat /backup/oracle/PMCRCS20/rman/rman_AO_bkp_EveryHr.rcv
run
{
CONFIGURE RETENTION POLICY TO REDUNDANCY 1 ;
CONFIGURE BACKUP OPTIMIZATION ON ;
CONFIGURE CONTROLFILE AUTOBACKUP OFF ;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 ;
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 8G ;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
SHOW ALL;
crosscheck archivelog from time 'sysdate - 4' ;
BACKUP ARCHIVELOG ALL DELETE INPUT
format '/backup/oracle/PMCRCS20/rman/%d_%s_%T_%c_ARCH' tag "ARCH_ONLY" ;
}

No comments:

Post a Comment