Oracle OCP 1Z0 053 Q511(LOG_ARCHIVE_MIN-SUCCEED_DEST)
511.You have configured flash recovery area in your database and you set the following Initialization
parameters for your database instance:
LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY'
LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch'
LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/arch
LOG_ARCH1VK_DEST_4 = ' LOCATION=/disk4/arch'
LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the
LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo
log groups have been used. What happens in an event of log switch?
A. The online redo log file Is not allowed to be overwritten.
B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is
made available.
C. The database instance will crash because the archived redo log file cannot be created in a destination
set as MANDATORY.
D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log
files are created in the next two available locations to guarantee archive log success.
Answer: D
參考:http://blog.csdn.net/rlhua/article/details/13998311
LOG_ARCHIVE_MIN_SUCCEED_DEST=2 這裡的意思是至少要2個archive destination成功,日誌歸檔才會成功。
如果LOG_ARCHIVE_DEST_1不能訪問,會被忽略
parameters for your database instance:
LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY'
LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch'
LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/arch
LOG_ARCH1VK_DEST_4 = ' LOCATION=/disk4/arch'
LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the
LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo
log groups have been used. What happens in an event of log switch?
A. The online redo log file Is not allowed to be overwritten.
B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is
made available.
C. The database instance will crash because the archived redo log file cannot be created in a destination
set as MANDATORY.
D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log
files are created in the next two available locations to guarantee archive log success.
Answer: D
參考:http://blog.csdn.net/rlhua/article/details/13998311
LOG_ARCHIVE_MIN_SUCCEED_DEST=2 這裡的意思是至少要2個archive destination成功,日誌歸檔才會成功。
如果LOG_ARCHIVE_DEST_1不能訪問,會被忽略
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2075030/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q520Oracle
- Oracle OCP 1Z0 053 Q607Oracle
- Oracle OCP 1Z0 053 Q500(Rman)Oracle
- Oracle OCP 1Z0 053 Q707Oracle
- Oracle OCP 1Z0 053 Q28(INCREMENTAL)OracleREM
- Oracle OCP 1Z0 053 Q332Oracle
- Oracle OCP 1Z0 053 Q269Oracle
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase
- Oracle OCP 1Z0 053 Q344(V$SESSION)OracleSession
- Oracle OCP 1Z0 053 Q558(V$BACKUP)Oracle
- Oracle OCP 1Z0 053 Q427(Transportable Tablespace)Oracle
- Oracle OCP 1Z0 053 Q182(RMAN)Oracle
- Oracle OCP 1Z0 053 Q428(transport database)OracleDatabase
- Oracle OCP 1Z0 053 Q458(Globalization NLSRTL)Oracle
- Oracle OCP 1Z0 053 Q465(NLS Parameters)Oracle
- Oracle OCP 1Z0 053 Q21(RMAN Duplicate)Oracle
- Oracle OCP 1Z0 053 Q600(RMAN BACKUP)Oracle
- Oracle OCP 1Z0 053 Q114Oracle
- Oracle OCP 1Z0 053 Q700(RMAN Duplicate)Oracle
- Oracle OCP 1Z0 053 Q223Oracle
- Oracle OCP 1Z0 053 Q703(Rman Backup)Oracle