RMAN备份常用例子 - 数据库编程

ce script backup_db_full {
#
# Backs up the whole database into backup-sets. This backup is not part
execute script alloc_all_tapes;
execute script set_maxcorrupt;
backup
full
# skip offline
# skip readonly
skip inaccessible
tag b_db_full
filesperset 6
format 'df_t%t_s%s_p%p'
database;
execute script rel_all_tapes;
execute script archive_log_current;
execute script backup_al_all;
}
replace script backup_db_level_0 {
#
# Backs up the whole database. This backup is part of the incremental
# strategy.
# It performs exactly the same backup as the script backup above, except
# the datafile backup is part of the incremental strategy (this means it
# can have incremental backups of levels > 0 applied to it - full backups
# cannot).
#
# Typically, a level 0 backup would be done at least once a week.
#
# Modified By Reason
# 961219 cd created
#
execute script alloc_all_tapes;
execute script set_maxcorrupt;
backup
incremental level 0
# skip offline
# skip readonly
skip inaccessible
tag backup_db_level_0
filesperset 6
format 'df_t%t_s%s_p%p'
database;
execute script rel_all_tapes;
execute script archive_log_current;
execute script backup_al_all;
}
replace script backup_db_level_1 {
#
# This backup will only backup blocks which have been modified since the
# last level 0 backup was performed. Otherwise it is exactly the same

# backup as the level 0 above (note, the controlfile is always backed up in
# it's entirety i.e. control file backups are never compressed).
#
# Typically, a level 1 backup would be done at least once in between level
# 0 backups.
#
# Modified By Reason
# 961219 cd created
#
execute script alloc_all_tapes;
execute script set_maxcorrupt;
backup
incremental level 1
# skip offline
# skip readonly
skip inaccessible
tag backup_db_level_1
filesperset 6
format 'df_t%t_s%s_p%p'
database;
execute script rel_all_tapes;
execute script archive_log_current;
execute script backup_al_all;
}
replace script backup_db_level_2 {
#
# This backup will only backup blocks which have been modified since the
# last level 0 or 1 backup was performed. Otherwise it is exactly the same
# backup as the level 0 or 1 backups above.
#
# Typically, a level 2 backup would be done at least once in between level
# 0 and 1 backups.
#
# Modified By Reason
# 961219 cd created
#
execute script alloc_all_tapes;
execute script set_maxcorrupt;
backup
incremental level 2
# skip offline
# skip readonly
skip inaccessible
tag backup_db_level_2
filesperset 6
format 'df_t%t_s%s_p%p'
database;
execute script rel_all_tapes;
execute script archive_log_current;
execute script backup_al_all;

RMAN备份常用例子(二)