还原和恢复数据 › 还原管理器

还原管理器

您可以使用还原管理器执行各种还原作业。有关还原管理器的详细信息，请参阅《管理指南》。

还原管理器中的“Oracle 还原选项”选项卡提供了以下还原和恢复选项：

• Oracle 数据库用户信息
• 使用 RMAN 编录 (推荐)
• 通道数（数据流）
• 从最新备份还原
• 从以下时间的备份还原
• 从备份标记还原

Note:These restore options are detailed in the Restore Options section of this chapter.

• 恢复类型：

  重要信息！使用其中一种恢复方法时，所有日志都会重置为控制文件中的上次注册日期，因此在该日期之后恢复的所有数据都会丢失且无法检索。

  • 到 SCN (仅整个数据库)
  • 到日志序列号 (仅整个数据库)
  • 到时间(仅整个数据库)

  Note:Because the logs have been reset, you must perform a full offline backup to ensure that you have a record of the database at that precise moment in time.

  • No Recovery - Selecting this option restores the data but does not perform any recovery.您必须自己恢复数据库，然后将其恢复联机。当您已经知道某个还原无法恢复时（如开始恢复过程之前需要附加还原作业，或者需要设置附加还原作业时），通常使用该选项。
  • Until the End of Logs - RMAN recovers the database, tablespaces, and data files up to the current time.
  • Until SCN (Whole DB Only) - RMAN recovers the database up to the specified System Change Number (that is, a checkpoint number).该恢复仅对于整个数据库有效。数据库以 resetlogs 选项打开。
  • Until Log Sequence Number (Whole DB Only) - RMAN recovers the database up to the specified Archived Log Sequence.该恢复仅对于整个数据库有效。数据库以 resetlogs 选项打开。
  • Until Time (Whole DB Only) - RMAN recovers the database up to the specified point in time.该恢复仅对于整个数据库有效。数据库以 resetlogs 选项打开。
  • Put Restore Object(s) Online after Recovery - When selected, this option puts the tablespaces and data files online and opens the database after the recovery has been performed.

另外，“高级 Oracle 还原选项”选项卡包括以下选项：

• 已存档日志选择：
  • Do Not Restore - Selecting this option does not restore any of the archived logs.

    Note:会自动选择此选项。

  • Time Based - This option restores the archived logs based on the time they were created, and not on the time they were backed up.如果您使用该选项，则还必须在“从时间”字段或“到时间”字段中输入值。
  • Thread - This option lets you specify the thread number used to identify the Oracle instance.对于独占模式下的 Oracle 实例，线程的默认值为“1”。
  • SCN Based - This option restores the range of archived logs by SCN (System Change Number).
  • Log Sequence Based - This option restores the archived logs by the archived log sequence number.
• Include Control File - Select this option if you want to restore the control files.请记住，只有在控制文件损坏或丢失的情况下，才应该还原控制文件。

  重要信息！还原控制文件会重置所有日志，从而导致您丢失数据库启动后的最新数据。这些数据无法恢复。

• Block Size (Oracle 9i) - If you use this option, the size of the data blocks must match the block size used during backup; otherwise, the restore will fail.
• List Backup Sets for Selected Objects - When selected, it sends a request to list all backup sets that include the objects you selected.

  Note:该选项不会还原所选对象。要还原所选对象，必须提交其他的还原作业。

• Validate Backup Set Number - This option asks RMAN to validate the integrity of a backup without actually restoring it.
• 装入 RMAN 脚本 - 使用该选项可输入 RMAN 脚本的路径。

  重要信息！使用该选项会覆盖您可能已经在还原管理器中选择的所有选项。