暂无图片
Oracle如下rman备份保留策略能否恢复数据库,有什么风险?
我来答
分享
FM.Heart
2022-03-27
Oracle如下rman备份保留策略能否恢复数据库,有什么风险?

受生产环境空间限制,计划使用以下备份策略。在实验环境我在L0和L1级别备份时都创建了有数据的表并对redo做了归档操作和切换日志操作,备份结束后我删除了上述归档日志,rman仍可正常recover。有哪些情况可能导致我无法完成完全恢复?(除备份集损坏、备份后归档日志损坏外)

#RMAN配置备份保留窗口————0天,打开了控制文件自动备份
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 0 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 03/27/2022 21:55:06
RMAN-20021: database not set
RMAN-06031: could not translate database keyword

#每周日执行Level0级别备份,不做plus archive log备份
run{
crosscheck backup;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup incremental level 0 database format '/u01/app/oracle/rmanbk/db_L0_%U.bak';
backup current controlfile format '/u01/app/oracle/rmanbk/ctl_%U.bak';
report obsolete device type disk;
delete noprompt obsolete device type disk;
delete noprompt expired backup device type disk;
release channel c1;
release channel c2;
}

#每周日执行Level1级别备份,不做plus archive log备份
run{
crosscheck backup;
allocate channel c1 device type disk;
allocate channel c2 device type disk;
backup incremental level 1 database format '/u01/app/oracle/rmanbk/db_L1_%U.bak';
backup current controlfile format '/u01/app/oracle/rmanbk/ctl_%U.bak';
report obsolete device type disk;
delete noprompt obsolete device type disk;
delete noprompt expired backup device type disk;
release channel c1;
release channel c2;
}
#每小时定时删除的归档日志,保留最后48小时的归档日志

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
Uncopyrightable

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 0 DAYS;大于7天?

暂无图片 评论
暂无图片 有用 0
吾喾

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 0 DAYS;大于14?

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏