Oracle RMAN备份相关脚本 oracle-rman

CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

vim /home/oracle/backup.sh



source ~/.bash_profile

rman target / <<EOF

RUN {

crosscheck archivelog all;

delete noprompt expired archivelog all;

crosscheck backup;

delete noprompt expired backup;

report obsolete;

delete noprompt obsolete;

allocate channel c1 type disk;

allocate channel c2 type disk;

BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG;

backup current controlfile;

release channel c1;

release channel c2;

}

EOF

exit

RUN {

crosscheck archivelog all;

delete noprompt expired archivelog all; 

crosscheck backup; 

delete noprompt expired backup;

report obsolete;

delete noprompt obsolete;

allocate channel c1 type disk;

backup format 'E:\BAK\LEDFULLBAK\LEDMES_dbf_%U' filesperset 5 database;

backup format 'E:\BAK\LEDFULLBAK\LEDMES_arc_%U' filesperset 10 archivelog all;

backup format 'E:\BAK\LEDFULLBAK\LEDMES_ctl_%U' current controlfile;

release channel c1;

}

 RMAN> backup archivelog all delete input format '/u01/app/oracle/rmanbak/lf_%d_%U';

BACKUP INCREMENTAL LEVEL 0  DATABASE;

BACKUP INCREMENTAL LEVEL 1 DATABASE;

BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

rman target sys/system nocatalog CMDFILE 'E:\BAK\LEDFULLBAK\rman_full.txt' log='E:\BAK\log\full_backup_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%".log'

run {

allocate channel 'dev_0' type 'sbt_tape'

parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ased3,OB2BARLIST=Daily_ased3)';

allocate channel 'dev_1' type 'sbt_tape'

parms 'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=ased3,OB2BARLIST=Daily_ased3)';

}