笔记：Oracle数据库全备脚本

数据库全备脚本

#!/bin/bash
export NLS_DATE_FORMAT=‘YYYY-MM-DD HH24:MI:SS’
PATH= P A T H : PATH: PATH:HOME/bin
export PATH
export ORACLE_SID=qhsde
ORACLE_BASE=/u01
ORACLE_HOME=/u01/product/12.1.0.2/dbhome_1
export PATH= O R A C L E H O M E / b i n : ORACLE_HOME/bin: ORACLEH​OME/bin:PATH:/usr/expect/bin
rman target / nocatalog log /data/backup/rman_qhsde_full.log append<<EOF
crosscheck archivelog all;
delete noprompt expired archivelog all;
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup as compressed backupset database format ‘/data/backup/full_%d_%T_%s_%p’;
backup current controlfile format ‘/data/backup/ctl_%d_%T_%s_%p’;
backup as compressed backupset archivelog all format ‘/data/backup/arch_%d_%T_%s_%p’;
}
report obsolete;
delete noprompt obsolete;
crosscheck backupset;
delete noprompt expired backupset;
delete noprompt archivelog all completed before ‘sysdate-2’;
EOF

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 31 DAYS;
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

01 00 * * * /home/oracle/backup/rman_full_qhsde.sh >> /home/oracle/backup/rman_full_qhsde.sh.log 2>&1