受生产环境空间限制,计划使用以下备份策略。在实验环境我在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小时的归档日志