全备脚本

#!/bin/bash

export ORACLE_SID=SID1

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=$ORACLE_BASE/products/11.2.0

export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/oracm/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/jdbc

rman target / nocatalog log /home/oracle/rmanlog/rmanlog.log  << EOF

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 filesperset 3 database format '/rmanbak/full_%d_%T_%s_%p';

sql 'alter system archive log current';

sql 'alter system archive log current';

sql 'alter system archive log current';

backup as compressed backupset archivelog all format '/rmanbak/arch_%d_%T_%s_%p';

backup current controlfile format '/rmanbak/ctl_%d_%T_%s_%p';

}

EOF

rman target / log /home/oracle/rmanlog/rmanlog_del.log  << EOF

allocate channel for maintenance type disk;

crosscheck backup;

crosscheck archivelog all;

delete noprompt archivelog until time'sysdate-3';

delete noprompt obsolete device type disk;

EOF