Rman 备份脚本，DG Script

[sky@smsdb scripts]$ more full.rcv
run {
     configure device type disk parallelism 3 ;
     backup  ( database 
                     include current controlfile
                     filesperset=2
                     format '/rman/msg_rman_back/full_bak/full_data_%s_%p'
                     tag="fullbackup_data");
    backup  ( archivelog all 
                     filesperset=4
                     format '/rman/msg_rman_back/arch_%s_%p'
                     tag="fullbackup_arch");
    }
[sky@smsdb scripts]$ more day.rcv
run
   {
   configure device type disk parallelism 3 ;
   backup  incremental level = 1
                     ( database 
                     include current controlfile
                     filesperset=1
                     format '/data/Arch/phy_bak/days/Inc_data_%s_%p'
                     tag=" incrementalbackup_data");
    backup  ( archivelog all 
                     filesperset=4
                     format '/data/Arch/phy_bak/days/Inc_arch_%s_%p'
                     tag="fullbackup_arch");
        }

 

[oracle@smsgw ~]$ crontab -l
# NOT EDIT THIS FILE - edit the master and reinstall.
# (/tmp/crontab.32451 installed on Fri Apr 28 09:51:02 2006)
# (Cron version -- $Id: crontab.c,v 2.13 1994/01/17 03:20:37 vixie Exp $)
#00 08 * * * /app/shell/readonly.sh
#32 02 * * * /app/shell/dataguard_recover.sh
#10 00 * * * find /backup/ora_archlog/ -name "ARC*" -mtime +2 -exec rm -f {} \;

#20 00 * * * /home/oracle/status_to_partition.sh
#20 01 * * * /home/oracle/mo_to_patition.sh
#20 02 * * * /home/oracle/mt_to_partition.sh

30 08 * * * /home/oracle/readonly.sh
30 02 * * * /home/oracle/recover.sh

 

 

#10 05 * * * find /backup/ora_archlog/ -name "ARC*" -mtime +2 -exec rm -f {} \;
[oracle@smsgw ~]$ more /home/oracle/recover.sh

export ORACLE_BASE=/data/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=smsnew
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.4.19
export NLS_LANG=AMERICAN
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin/:$PATH

sqlplus /nolog <conn  xxx as sysdba

shutdown abort
startup nomount
alter database mount standby database;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
exit
EOF

[oracle@smsgw ~]$ more /home/oracle/readonly.sh

export ORACLE_BASE=/data/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=smsnew
export ORACLE_TERM=xterm
export LD_ASSUME_KERNEL=2.4.19
export NLS_LANG=AMERICAN
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
export PATH=$ORACLE_HOME/bin/:$PATH

sqlplus /nolog <conn  xxx as sysdba

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
alter database open read only;
exit
EOF

[oracle@smsgw ~]$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24032200/viewspace-672817/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24032200/viewspace-672817/