Complete, Incomplete and Point-In-Time Recovery【每日一译】--2012-11-09

最新推荐文章于 2022-06-27 17:26:43 发布

翻译最新推荐文章于 2022-06-27 17:26:43 发布 · 747 阅读

本文探讨了数据库还原的两种主要方式：完全还原与不完全还原（时间点还原）。完全还原能够确保数据库恢复到最新状态，而不会丢失任何提交的事务。不完全还原，也称为时间点还原，主要用于撤销特定时间点之前的更改，适用于处理用户错误或数据损坏的情况。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Complete recovery is recovering a database to the most recent point in time, without
the loss of any committed transactions. Generally, the term "recovery" refers to

complete recovery.

完全还原是还原数据库到最近的时间点，没有丢失任何提交的事务。简而言之，词语“还原”

也就是完全还原。

Occasionally, however, you need to return a database to its state at a past point in time.
For example, to undo the effect of a user error, such as dropping or deleting the
contents of a table, you may want to return the database to its contents before the
delete occurred. In incomplete recovery, also known as point-in-time recovery, the

goal is to restore the database to its state at some previous target SCN or time.

有时，你需要将数据库返回到过去的一个时间点。比如，回滚一个用户错误的影响，

比如DELETE或者DROP表的内容，你想返回到数据库被DELETE之前的内容。在不完全

还原中，众所周知的时间点还原，目标是修复数据库到它之前目标SCN或者时间的状态。

Point-in-time recovery is one possible response to a data loss caused by, for instance, a

user error or logical corruption that goes unnoticed for some time.

时间点的还原可能是一个数据丢失所造成的反应，对于实例，一个用户的错误或者是逻辑

损坏在一段时间内容是被忽视的。

Point-in-time recovery is also your only option if you have to perform a recovery and
discover that you are missing an archived log covering time between the backup you
are restoring from and the target SCN for the recovery. Without the missing log, you
have no record of the updates to your datafiles during that period. Your only choice is
to recover the database from the point in time of the restored backup, as far as the
unbroken series of archived logs permits, then perform an OPEN RESETLOGS and
abandon all changes in or after the missing log. (If you discover that you have lost

archived logs and your database is still up, you should do a full backup immediately.)

时间点的还原也可能是你唯一的选项如果你执行一个还原并且发现你丢失了在介于你使用

来修复的备份和对于还原的目标SCN之间。没有了丢失的日志，你没有在那个阶段更新数据库

的记录，你唯一的选择是还原数据库从用于修复的备份中，当一系列归档日志许可时候，那么

执行OPEN RESETLOGS并且放弃所有改变在丢失日志或者丢失之后。（如果你发现你已经丢失了

归档日志并且你的数据库仍然在运行，你应当马上执行一个全备份）

Note: If only one tablespace is affected by the data loss, you have
the option of performing point-in-time recovery on that tablespace
instead of the entire database. Tablespace point-in-time recovery
(often abbreviated TSPITR) is an advanced technique documented
in Oracle Database Backup and Recovery Advanced User's Guide.

备注：如果仅一个表空间受影响针对数据丢失，你可以选择执行基于时间点的还原表空间去代替整个

整个数据库的还原。表空间基于时间点的还原（通称简写为TSPITR）是一个高级的技术，可见于文件档

Oracle Database Backup and Recovery Advanced User's Guide.