Oracle 12c RMAN备份文档

创建备份目录,查看剩余空间

[cistest@cistest ~]$ df -h
df: ‘/home/oratest/.gvfs’: Permission denied
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos-root 450G 27G 423G 6% /
devtmpfs 5.8G 0 5.8G 0% /dev
tmpfs 5.8G 2.9G 3.0G 50% /dev/shm
tmpfs 5.8G 34M 5.8G 1% /run
tmpfs 5.8G 0 5.8G 0% /sys/fs/cgroup
/dev/sda1 497M 128M 370M 26% /boot

创建目录,并且更改权限为数据库用户

sudo mkdir -p /rman_backup/bak_data  /rman_backup/scripts

[sa@cis ~]$ sudo chgrp -R dba /rman_backup/
[sa@cis ~]$ sudo chown -R oracle /rman_backup/

rman参数配置

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS ;

全备脚本 BackupFull.sh

# script .:BackupFull.sh

# creater:wangshengzhuang

# date:2016/01/05

# desc: backup full database datafile in archive with rman

# connect database

export ORACLE_BASE=/home/oratest/app/oratest

export ORACLE_HOME=/home/oratest/app/oratest/product/12.1.0/dbhome_1

export ORACLE_SID=CISTEST

export PATH=$ORACLE_HOME/bin:$PATH

rman target/ << EOF

Run{
Allocate channel c1 type disk; Backup incremental level 0 tag 'db0' format '/rman_backup/bak_data/db0_%d_%T_%s' database
include current controlfile
plus archivelog filesperset 20 format '/rman_backup/bak_data/arc0_%d_%T_%s' ; Delete noprompt obsolete;
Release channel c1;
} EOF
#

增量备份BackupIncr1.sh

# script .:BackupFull.sh

# creater:wangshengzhuang

# date:2016/01/05

# desc: backup incremental database datafile in archive with rman

# connect database

export ORACLE_BASE=/home/oratest/app/oratest

export ORACLE_HOME=/home/oratest/app/oratest/product/12.1.0/dbhome_1

export ORACLE_SID=CISTEST

export PATH=$ORACLE_HOME/bin:$PATH

rman target/ << EOF

Run{
Allocate channel c1 type disk; Backup incremental level 1 tag 'db1' format '/rman_backup/bak_data/db1_%d_%T_%s' database
include current controlfile
plus archivelog filesperset 20 format '/rman_backup/bak_data/arc1_%d_%T_%s' ; Delete noprompt obsolete;
Release channel c1;
} EOF
#

配置定时调度

周日和周三凌晨1:00执行0级全库备份,周一、二、四、五六凌晨1:00执行1级增量备份

[oratest@cistest scripts]$ crontab -e
0 1 * * 0 /rman_backup/scripts/BackupFull.sh >>/rman_backup/BackupFull.log
0 1 * * 3 /rman_backup/scripts/BackupFull.sh >>/rman_backup/BackupFull.log
0 1 * * 1-2 /rman_backup/scripts/BackupIncr1.sh >>/rman_backup/BackupIncr.log
0 1 * * 4-6 /rman_backup/scripts/BackupIncr1.sh >>/rman_backup/BackupIncr.log

reload调度

[sa@cistest cistest]$ sudo /sbin/service crond reload
Redirecting to /bin/systemctl reload crond.service
上一篇:Cocoapods 创建自己的公开库、私有库


下一篇:webgl学习笔记四-动画