rman备份脚本
来源:互联网 发布:vb简单程序代码 编辑:程序博客网 时间:2024/05/18 11:36
Full备份
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=Oracle11gR2
export PATH=$ORACLE_HOME/bin:$PATH
timst=`date +'%Y%m%d' | awk '{print $1$2}'`
mkdir /backup/$timst
$ORACLE_HOME/bin/rman <<EOF
connect target sys/******@Oracle11gR2;
RUN {
ALLOCATE CHANNEL CH1 device TYPE disk;
ALLOCATE CHANNEL CH2 device TYPE disk;
ALLOCATE CHANNEL CH3 device TYPE disk;
ALLOCATE CHANNEL CH4 device TYPE disk;
BACKUP
FULL
FORMAT '/backup/$timst/%d_%U'
DATABASE(或者想换成相应的表空间)
INCLUDE CURRENT CONTROLFILE
PLUS ARCHIVELOG;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
RELEASE CHANNEL CH4;
}
exit;
EOF
cd /backup
tar jcvf $timst.tar.bz2 $timst
rm -rf $timst
0级备份
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=Oracle11gR2
export PATH=$ORACLE_HOME/bin:$PATH
timst=`date +'%Y%m%d' | awk '{print $1$2}'`
mkdir /backup/$timst
$ORACLE_HOME/bin/rman <<EOF
connect target sys/******@Oracle11gR2;
RUN {
SQL 'alter system archive log current';
ALLOCATE CHANNEL CH1 device TYPE disk;
ALLOCATE CHANNEL CH3 device TYPE disk;
ALLOCATE CHANNEL CH2 device TYPE disk;
ALLOCATE CHANNEL CH4 device TYPE disk;
BACKUP
INCREMENTAL LEVEL 0
FORMAT '/backup/%d_%U'
DATABASE
INCLUDE CURRENT CONTROLFILE
PLUS ARCHIVELOG
;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
RELEASE CHANNEL CH4;
}
exit;
EOF
cd /backup
tar jcvf $timst.tar.bz2 $timst
rm -rf $timst
一级备份
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=Oracle11gR2
export PATH=$ORACLE_HOME/bin:$PATH
timst=`date +'%Y%m%d' | awk '{print $1$2}'`
mkdir /backup/$timst
$ORACLE_HOME/bin/rman <<EOF
connect target sys/******@Oracle11gR2;
RUN {
SQL 'alter system archive log current';
ALLOCATE CHANNEL CH1 device TYPE disk;
ALLOCATE CHANNEL CH3 device TYPE disk;
ALLOCATE CHANNEL CH2 device TYPE disk;
ALLOCATE CHANNEL CH4 device TYPE disk;
BACKUP
INCREMENTAL LEVEL 1
FORMAT '%d_%U'
DATABASE
INCLUDE CURRENT CONTROLFILE
PLUS ARCHIVELOG;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
RELEASE CHANNEL CH4;
}
exit;
EOF
cd /backup
tar jcvf $timst.tar.bz2 $timst
rm -rf $timst
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=Oracle11gR2
export PATH=$ORACLE_HOME/bin:$PATH
timst=`date +'%Y%m%d' | awk '{print $1$2}'`
mkdir /backup/$timst
$ORACLE_HOME/bin/rman <<EOF
connect target sys/******@Oracle11gR2;
RUN {
ALLOCATE CHANNEL CH1 device TYPE disk;
ALLOCATE CHANNEL CH2 device TYPE disk;
ALLOCATE CHANNEL CH3 device TYPE disk;
ALLOCATE CHANNEL CH4 device TYPE disk;
BACKUP
FULL
FORMAT '/backup/$timst/%d_%U'
DATABASE(或者想换成相应的表空间)
INCLUDE CURRENT CONTROLFILE
PLUS ARCHIVELOG;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
RELEASE CHANNEL CH4;
}
exit;
EOF
cd /backup
tar jcvf $timst.tar.bz2 $timst
rm -rf $timst
0级备份
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=Oracle11gR2
export PATH=$ORACLE_HOME/bin:$PATH
timst=`date +'%Y%m%d' | awk '{print $1$2}'`
mkdir /backup/$timst
$ORACLE_HOME/bin/rman <<EOF
connect target sys/******@Oracle11gR2;
RUN {
SQL 'alter system archive log current';
ALLOCATE CHANNEL CH1 device TYPE disk;
ALLOCATE CHANNEL CH3 device TYPE disk;
ALLOCATE CHANNEL CH2 device TYPE disk;
ALLOCATE CHANNEL CH4 device TYPE disk;
BACKUP
INCREMENTAL LEVEL 0
FORMAT '/backup/%d_%U'
DATABASE
INCLUDE CURRENT CONTROLFILE
PLUS ARCHIVELOG
;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
RELEASE CHANNEL CH4;
}
exit;
EOF
cd /backup
tar jcvf $timst.tar.bz2 $timst
rm -rf $timst
一级备份
#!/bin/bash
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=Oracle11gR2
export PATH=$ORACLE_HOME/bin:$PATH
timst=`date +'%Y%m%d' | awk '{print $1$2}'`
mkdir /backup/$timst
$ORACLE_HOME/bin/rman <<EOF
connect target sys/******@Oracle11gR2;
RUN {
SQL 'alter system archive log current';
ALLOCATE CHANNEL CH1 device TYPE disk;
ALLOCATE CHANNEL CH3 device TYPE disk;
ALLOCATE CHANNEL CH2 device TYPE disk;
ALLOCATE CHANNEL CH4 device TYPE disk;
BACKUP
INCREMENTAL LEVEL 1
FORMAT '%d_%U'
DATABASE
INCLUDE CURRENT CONTROLFILE
PLUS ARCHIVELOG;
RELEASE CHANNEL CH1;
RELEASE CHANNEL CH2;
RELEASE CHANNEL CH3;
RELEASE CHANNEL CH4;
}
exit;
EOF
cd /backup
tar jcvf $timst.tar.bz2 $timst
rm -rf $timst
0 0
- RMAN备份脚本
- Oracle RMAN备份脚本
- linux rman备份脚本
- oracle11g Rman 备份脚本
- rman 备份脚本
- rman备份脚本
- RMAN备份脚本
- RMAN备份脚本
- windows rman备份脚本
- rman备份脚本
- rman备份与脚本
- oracle rman备份脚本
- RMAN 备份脚本
- RMAN自动备份脚本
- rman 自动备份脚本
- RMAN 备份脚本
- rman自动备份脚本
- RMAN 备份脚本
- android studio高级设置
- Android多元的设计模式
- Python 练习实例24
- ARC下OC对象和CF对象之间的桥接(bridge)
- Java中关于异常的一些问题(三)
- rman备份脚本
- 设计模式中的单例模式&c++
- linux基础学习之 automake
- HDFS写文件过程分析
- 在category和protocol中如何实现@property
- iOS全局定义NavigationController样式
- 《iOS Human Interface Guidelines》——Launch Files
- CSS完美兼容IE6/IE7/IE8/IE9/IE10的通用方法
- c++11特性里的多线程thread的用法