Oracle OCP 1Z0 053 Q64(RESETLOGS&LOG_ARCHIVE_FORMAT)

abstractcyj發表於2016-04-04
64.You performed an incomplete recovery and opened the database with the RESETLOGS option. The
LOG_ARCHIVE_FORMAT parameter is set to 'ora_%t_%s_%r.log'. Which statement regarding the
archived redo log files, created in an earlier incarnation of the database, is true?
A. The archived redo log files will be overwritten.
B. The archived redo log files are deleted automatically.
C. The archived redo log files should be moved to some other location.
D. The archived redo log files are still maintained because the file names are unique.
Answer: D

RESETLOGS之後,LOG SEQUENCE NUMBER被重置,

歸檔日誌檔案格式中各個符號的意思是:

%t thread number
%s log sequence number
%r resetlogs ID that ensures unique names are constructed for the archived log files across multiple incarnations of the database

歸檔日誌檔案按照這個規則產生的時候,檔名是唯一的。所以,不可能被覆蓋。
也不會被自動刪除或者移動到另外的位置。


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

相關文章