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 may be local or remote for a Standby Database.
B.
All the destinations are determined by the server automatically.
C.
A maximum of ten different destinations can be assigned.
D.
The destination must be global only.
E.
The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization
parameter.
F.
A maximum of five destinations can be assigned.
Archive destinations are specified by setting the inits
LOG_ARCHIVE_DEST_n
where….
n is an integer from 1 to 31. Archive destinations
– 1 to 10 are available for local or remote locations (e.g. from a primary database to a standby database)
– 11 to 31 are available for remote locations only
See V$ARCHIVE_DEST
e.g.
ALTER SYSTEM SET LOG_ARCHIVE_DEST_1=’SERVICE=standby2′ SCOPE=SPFILE; –specifies a standby instance, files are transmited via Oracle Net IPC or TCP and corresponds to a service name in a tnsnames.ora.
ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=’LOCATION=/oracle/archive2/’ SCOPE=SPFILE; — Note the last “/” at the end of the local dir
Anyway C is not correct for release 11gR2. Maybe the question was written for 10g????
If you want to multiplex the archived logs, you can choose whether to archive to up to ten locations (using the LOG_ARCHIVE_DEST_n parameters)