發表者討論內容

冷日
(冷日) 發表時間：2017/10/12 3:30

Webmaster

註冊日: 2008/2/19
來自:
發表數: 15773

[轉貼]RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE

RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE

August 22, 2013 by Imran / Oracle 11g

Ensuring that the system has been backed up and is fully “recoverable”, is a very important aspect of the DBA’s responsibility.An RMAN command which is usually used to test the availability of the all these required backup files, is the RESTORE DATABASE VALIDATE command.

This command looks at the backup set files in the destination and compares them to the list of required files from the repository or control file required for a restore. It does not perform an actual restore. Contrary to popular belief, it does NOT look and verify the archive logs, but only the database backup sets required for the restore. DBA’s usually are not aware that the RESTORE ARCHIVELOG ALL VALIDATE should be run to ensure that archive logs are also available to ensure a complete recovery.

These two commands should be part of a periodic script to ensure that a complete backup set is available at all times, in case required.

RESTORE DATABASE VALIDATE;
RESTORE ARCHIVELOG ALL VALIDATE;

If no error is returned from the above commands then the files required for BOTH restore and recovery are available.

原文出處：RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE - VitalSoftTech

回覆

平面展開

前一個主題 | 下一個主題 | |

| |

討論串

[轉貼]Oracle 11g 啟用 Archive Log Mode (冷日
(冷日), 2016/2/1 4:37)
[轉貼]Archive Log Mode (冷日
(冷日), 2016/2/1 4:40)
[轉貼]ORACLE ARCHIVE LOG Mode 筆記 (冷日
(冷日), 2016/2/1 4:42)
[轉貼]關於 Archive Log (冷日
(冷日), 2016/2/1 4:44)
[轉貼]Archive Log 路徑設錯解法 (冷日
(冷日), 2016/2/1 9:38)
[轉貼]Managing Archived Redo Logs (冷日
(冷日), 2017/10/12 3:22)
[轉貼]How To Delete Specific Archivelogs and Backups Using RMAN (冷日
(冷日), 2017/10/12 3:26)
» [轉貼]RESTORE DATABASE VALIDATE vs RESTORE ARCHIVE VALIDATE (冷日
(冷日), 2017/10/12 3:30)
[轉貼]Archivelog deletion policy for Standby Database in Oracle Data Guard (冷日
(冷日), 2017/10/12 3:35)
[轉貼]2 ways to move archivelogs – both need RMAN (冷日
(冷日), 2017/10/12 3:41)

發表新主題

DB研討會 : [轉貼]Oracle 11g 啟用 Archive Log Mode

討論串