备库lO满 oracle,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; }