還原與復原資料 › 還原 › 還原管理員
還原管理員
使用「還原管理員」可執行多種還原工作。如需關於「還原管理員」的詳細資訊,請參閱《管理指南》。
還原管理員上的 [Oracle 還原選項] 索引標籤提供下列還原與復原選項:
- Oracle DB 使用者資訊
- 使用 RMAN 目錄 [建議使用]
- 通道數 (資料流數)
- 由前次備份還原
- 由下列日期的備份還原
- 由備份標記還原
附註:These restore options are detailed in the Restore Options section of this chapter.
- 復原類型:
重要!使用這些復原方式時,所有日誌都會重設為控制檔案中最新登錄的日期,使在此日期後復原的任何資料都會遺失而無法擷取。
- 至 SCN (僅針對整個資料庫)
- 至日誌順序編號 (僅針對整個資料庫)
- 直到時間 (僅止於整個資料庫)
附註: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.
附註:系統會自動核取此選項。
- 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.
附註:此選項不會還原選取的物件。若要還原選取的物件,您必須提交其他還原工作。
- Validate Backup Set Number - This option asks RMAN to validate the integrity of a backup without actually restoring it.
- 載入 RMAN 指令碼 - 使用此選項,可輸入 RMAN 指令碼的路徑。
重要!使用此選項,會覆寫您在還原管理員中選取的所有選項。
Copyright © 2017 .
All rights reserved.
|
|