备份到磁盘:(如果是磁带,将DISK改成'SBT_TAPE')
0级备份脚本:
RUN {
ALLOCATE CHANNEL ch00 TYPE
DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
BACKUP
INCREMENTAL
LEVEL=0
SKIP INACCESSIBLE
TAG hot_db_bk_level0
FILESPERSET 5
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql
'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE
CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE DISK;
ALLOCATE CHANNEL
ch01 TYPE DISK;
BACKUP
filesperset 20
FORMAT
'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE CHANNEL
ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE DISK;
BACKUP
FORMAT 'cntrl_%s_%p_%t'
CURRENT CONTROLFILE;
RELEASE CHANNEL
ch00;
}
1级差异增量备份:
RUN {
ALLOCATE
CHANNEL ch00 TYPE DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
BACKUP
INCREMENTAL LEVEL=1
SKIP INACCESSIBLE
TAG
hot_db_bk_level0
FILESPERSET 5
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE
CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE
DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE
CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE
DISK;
BACKUP
FORMAT 'cntrl_%s_%p_%t'
CURRENT
CONTROLFILE;
RELEASE CHANNEL ch00;
}
1级累积增量备份脚本:
RUN {
ALLOCATE CHANNEL ch00
TYPE DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
BACKUP
INCREMENTAL LEVEL=1 CUMULATIVE
SKIP INACCESSIBLE
TAG
hot_db_bk_level0
FILESPERSET 5
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE
CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE
DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL DELETE INPUT;
RELEASE
CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE
DISK;
BACKUP
FORMAT 'cntrl_%s_%p_%t'
CURRENT
CONTROLFILE;
RELEASE CHANNEL ch00;
}
恢复脚本:
RUN {
ALLOCATE CHANNEL ch00 TYPE
DISK;
ALLOCATE CHANNEL ch01 TYPE DISK;
RESTORE DATABASE;
RECOVER
DATABASE;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/16313359/viewspace-682331/ ,如需转载,请注明出处,否则将追究法律责任。