Oracle 11G OCP 1Z0-053 628

LuiseDalian發表於2014-11-12
(628)The database is running in the ARCHIVELOG mode.It has three redo log groups with one member each.

One of the redo log groups has become corrupted.

You have issued the following command during the recovery of a damaged redo log file: ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

Which action should you perform immediately after using this command?

A. You should perform a log switch

B. You should make a backup of the database

C. You should switch the database to the NONARCHIVELOG mode

D. You should shut down the database instance and perform a complete database recovery

答案:(B)

解析:

執行的命令是重新建立日誌組3,而且沒有產生歸檔,那麼就出現了歸檔不連續的情況,如果這個時候資料庫損壞,是無法做完全恢復的。

因此要做一次備份,但是備份的型別沒有具體的要求,如果前面有增量備份,此時做一個增量備份就可以了,無需一定要做一個完全的資料庫備份

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17013648/viewspace-1329185/,如需轉載,請註明出處,否則將追究法律責任。

相關文章