oracle rman备份脚本.doc

oracle rman备份脚本 2，常用备份脚本：备份到磁盘：(如果是磁带，将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