rman备份与脚本
来源:互联网 发布:精功科技 盘古数据 编辑:程序博客网 时间:2024/06/04 18:26
1. 建立rman表空间
SQL> create tablespace rman
logging datafile '/u01/app/oracle/oradata/TBDB/rman.dbf' size 1024M
extent management local segment space management auto;
2.创建rman备份账号
create user rman identified by rman default tablespace rman;
grant connect,resource to rman;
grant recovery_catalog_owner to rman;
grant unlimited tablespace to rman;
grant sysdba to rman;
3.建立catalog数据库及注册数据库
rman catalog rman/rman
RMAN> create catalog tablespace "RMAN";
RMAN> exit
注: 需启动连接器,node222 为客户端连接服务器的标识符
rman target sys/oracle@node222 catalog rman/rman@node222
connected to target database: NODE222 (DBID=3694045568)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
full resync complete
4.rman环境设置
1) 设置保留30天的备份信息
2)启用控制文件自动备份及备份存放位置配置
RMAN> configure retention policy to recovery window of 30 days;
RMAN> configure controlfile autobackup on;
5.查看配置信息
RMAN>show all;
6.备份策略
每日00:00进行一次全库备份 系统自动清除30天以前的备份信息
7. 创建备份必要目录(以oracle身份创建)
mkdir /u01/app/oracle/backup
cd /u01/app/oracle/backup
mkdir controlfileback 存放备份的控制文件
mkdir dbback 存放备份的数据文件
mkdir log 存放备份生成的日志,坚持该日志查看备份是否成功
mkdir logback 存放归档日志文件
8. 备份脚本 cat /u01/app/oracle/backup/script/dbback.sh
#!/bin/bash
#this is rman auto full backup script
# Copyright by terrytsang
ORACLE_HOME=/u01/app/oracle/product/11.2.0/db1
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
LD_LIBRARY_PATH=$ORACLE_HOME/lib
ORACLE_BASE=/u01/app/oracle
ORACLE_SID=TBDB
export ORACLE_HOME LD_LIBRARY_PATH NLS_LANG ORACLE_BASE ORACLE_SID
backtime=`date +"20%y%m%d%H%M%S"`
cd $ORACLE_HOME/bin
rman target / catalog rman/rman log=/u01/app/oracle/backup/log/backupall_$backtime.log <<EOF
run{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
crosscheck backup;
sql 'alter system archive log current';
backup database format '/u01/app/oracle/backup/dbback/db_%d_%T_%U';
sql 'alter system archive log current';
backup archivelog all format '/u01/app/oracle/backup/logback/arc_%t_%s' delete all input;
backup current controlfile format '/u01/app/oracle/backup/controlfileback/cntrl_%s_%p_%s';
crosscheck archivelog all;
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt backup of database completed before 'sysdate - 30';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}
EOF
echo "backup complete!"
9. 定义备份时间间隔
crontab 0 0 * * * /u01/app/oracle/backup/script/dbback.sh 2>&1 >/dev/null
- rman备份与脚本
- Oracle的RMAN备份与恢复脚本
- rman 备份与删除归档脚本
- Oracle的RMAN备份与恢复脚本
- Oracle的RMAN备份与恢复脚本
- rman catalog方式备份配制与脚本
- Oracle的RMAN备份与恢复脚本
- RMAN备份脚本
- Oracle RMAN备份脚本
- linux rman备份脚本
- oracle11g Rman 备份脚本
- rman 备份脚本
- rman备份脚本
- RMAN备份脚本
- RMAN备份脚本
- windows rman备份脚本
- rman备份脚本
- oracle rman备份脚本
- AWR
- 【Oracle】-【索引】先查数据再建索引,还是先建索引再插数据?
- Win7中CHM打不开的解决方法
- 协议森林02 小喇叭开始广播 (以太网与WiFi协议)
- Window8平板键盘中英文字符的问题
- rman备份与脚本
- Google地图的经纬度
- QT槽传递参数的方法
- php回调函数的概念及实例
- FLV视频发布的两种方式(HTTP协议和RTMP协议)(转)
- javascript数据操作
- vb中获取(int,long数据类型)的高位值与低位值的相关计算方法
- OSGI : 使用OSGi构建面向服务的联络管理应用程序
- 兴趣是最好的精准营销