aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

RMAN-06061: WARNING: skipping archived log compromises recoverability

RMAN-06061: WARNING: skipping archived log compromises recoverability
Cause: SKIP INACCESSIBLE option resulted in skipping archived logs during BACKUP. If the archived log has in fact been lost and there is no backup, then the database is no longer recoverable across the point-in-time covered by the archived log. This may occur because archived log was removed by an outside utility without updating the recovery catalog or target database control file.
Action: If the archived log has been removed with an outside utility and the archived log has already been backed up, then you can synchronize the recovery catalog or target database control file by running CROSSCHECK ARCHIVELOG ALL. If the archived log has not been previously backed up, then you should take a full backup of the database and archived logs to preserve recoverability. Previous backups are not fully recoverable.

请先 登录 后评论

1 个回答

小智
RMAN-06061:警告:跳过归档日志会损害可恢复性,
.原因: SKIP INACCESSIBLE选项导致在BACKUP期间跳过归档日志。如果归档日志实际上已丢失,并且没有备份,则数据库不能在归档日志覆盖的时间点内恢复。这可能是因为存档日志被外部实用程序删除,而不更新恢复目录或目标数据库控制文件。,
.操作:如果已使用外部实用程序删除归档日志,并且归档日志已备份,则可以通过运行CROSSCHECK ARCHIVELOG ALL来同步恢复目录或目标数据库控制文件。如果先前未备份归档日志,则应对数据库和归档日志进行完全备份,以保持可恢复性。以前的备份不能完全恢复。,
.
请先 登录 后评论