Explanation:
Name of the service is resolved using the tnsnames.ora file. Destination is an Oracle Net alias specified by using the SERVICE keyword in the init.ora initialisation file. Specify the archive destination by adding the following entry to the primary database init.ora file: log_archive_dest2=”SERVICE=standby_db1 MANDATORY REOPEN=600” Incorrect Answer:
1: The control file is not used to resolve service name.
3: The service name standby_db1 is not resolved using data dictionary information.
4: The initialization parameter file is used to specify the service name with SERVICE keyword but not resolve it.
Reference:
OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 61
Chapter 3: Basic Net Server-Side Configuration

---