oracle rman 备份数据库脚本

fullbk.bat:

del f:\DBBR\FULLBR\*.* /q
del f:\DBBR\LOGBR\*.* /q
set oracle_sid=dmsasc
rman nocatalog target / cmdfile=fullbk.rman >>fullbk.log

fullbk.rman:

run {
allocate channel c1 type disk;
backup
incremental level 0
skip inaccessible
tag hot_db_bk_level0
filesperset 3
format 'F:\DBBR\FULLBR\bk_%s_%p_%t.bk'
(database);
sql 'alter system archive log current';
change archivelog all crosscheck;
backup
filesperset 10
format 'F:\DBBR\FULLBR\a1_%s_%p_%t.ac'
(archivelog all delete input);
CONFIGURE CONTROLFILE AUTOBACKUP ON;
copy current controlfile to 'F:\DBBR\FULLBR\control.ctl';
release channel c1;
}

logbk.bat:

set oracle_sid=dmsasc
rman nocatalog target / cmdfile=logbk.rman >>logbk.log

logbk.rman:

run {
allocate channel c1 type disk;
sql 'alter system archive log current';
change archivelog all crosscheck;
backup
filesperset 10
format 'F:\DBBR\LOGBR\a1_%s_%p_%t.ac'
(archivelog all delete input);
copy current controlfile to 'F:\DBBR\FULLBR\control.ctl';
release channel c1;
}