hpunix+rman备份

在asm下创建备份目录

alter diskgroup DATA add directory '+DATA/fullback';

alter diskgroup DATA add directory '+DATA/addback';

切换到grid用户下才可查看目录

1、su - grid

2、asmcmd

3、ls
4、cd DATA
5、ls
oracle用户下没有权限执行crontab
解决办法
1、修改/var/adm/cron/cron.allow将oracle用户加入文件

2、在root用户下创建任务

备份语句

完整备份

export ORACLE_SID=实例名;
export ORACLE_HOME=家目录;
export PATH=$ORACLE_HOME/bin:$PATH;
LOGDATE=`date '+%Y%m%d'`
ip="IP地址"
rman target  / nocatalog <<EOF >> /home/oracle/log/logfull_${LOGDATE}.log

run{

 allocate channel dev01 type disk MAXPIECESIZE 30G;
 allocate channel dev02 type disk MAXPIECESIZE 30G;
 allocate channel dev03 type disk MAXPIECESIZE 30G;
 allocate channel dev04 type disk MAXPIECESIZE 30G;
backup AS COMPRESSED BACKUPSET  INCREMENTAL LEVEL=0 database format '+DATA/fullback/DB0_%u_%s_%p.data' include current controlfile;
sql 'alter system archive log current';
backup archivelog all format '+DATA/fullback/arch_%u_%t.rac' delete input;
backup current controlfile format '+DATA/fullback/arch_%u_%t.ctl';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
delete noprompt obsolete device type disk;

release channel dev01;

release channel dev02;

release channel dev03;

release channel dev04;

}

EOF

增量备份

export ORACLE_SID=实例名;
export ORACLE_HOME=家目录;
export PATH=$ORACLE_HOME/bin:$PATH;
LOGDATE=`date '+%Y%m%d'`
ip="IP地址"
rman target  / nocatalog <<EOF >> /home/oracle/log/logadd_${LOGDATE}.log

run{
 backup AS COMPRESSED BACKUPSET  INCREMENTAL LEVEL=1 database format '+DATA/addback/DB1_%u_%s_%p.data' include current controlfile;
 sql 'alter system archive log current';
 backup archivelog all format '+DATA/addback/arch_%u_%t.rac' delete input;
 backup current controlfile format '+DATA/addback/arch_%u_%t.ctl';
 CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
 delete noprompt obsolete device type disk;}

 EOF