一个rman备份的例子

最新推荐文章于 2022-08-02 10:35:41 发布

lucklover

最新推荐文章于 2022-08-02 10:35:41 发布

阅读量580

点赞数

分类专栏： ORACLE database

ORACLE database 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

ORACLE_BASE=/opt/11g/oracle; export ORACLE_BASE 
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;  export ORACLE_HOME 
ORACLE_SID=nek; export ORACLE_SID 
ORACLE_TERM=xterm; export ORACLE_TERM 
PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH 
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; 
export CLASSPATH 
 DAY_TAG=`date +"%Y-%m-%d"`
rman target / nocatalog msglog  /home/oracle/nek__$DAY_TAG.log << !
run
 {
   allocate channel c1 type disk;
   backup as compressed backupset database format '/oradata/nek/bakup/nek_%T_%U' tag='level0';
    backup current controlfile format '/oradata/nek/bakup/nek_%T_CTL_%U';
   sql 'alter system archive log current';
   backup archivelog all format '/oradata/nek/bakup/nek_arch_%T_%U' delete input;
   release channel c1;
   crosscheck backupset;
    delete noprompt expired backup;
    delete noprompt obsolete;
    crosscheck archivelog all;
     delete noprompt expired archivelog all;
}
!