052-199(新增70题2018)

Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode.

Which two statements regarding archive log destinations are true? (Choose two.)

A. The destination must be global only.

B. A maximum of five destinations can be assigned.

C. A maximum of ten different destinations can be assigned.

D. All the destinations are determined by the server automatically.

E. The destination may be local or remote for a Standby Database.

F. The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

Answer: CE

redo log 可以最多放10个地方本地最少1个,远程的数量最多为31-本地的数量。这里多选的话只能假设没有remote地址所以最多10个。
LOG_ARCHIVE_DEST_n中n取值范围1到31.(跟redo日志最多几个destination无关)
LOG_ARCHIVE_DEST参数用来设置destination

Specifying Archive Destinations
You can choose to archive redo logs to a single destination or to multiple destinations. Destinations can be local—within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group—or remote (on a standby database).

To archive to only a single destination, specify that destination using the LOG_ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can choose to archive to two or more locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DESTinitialization parameters.

原文地址:https://www.cnblogs.com/Babylon/p/8583821.html