SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=boston)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME=boston)
)
(SID_DESC=
(GLOBAL_DBNAME=chicago)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME=chicago)
)
)?

[oracle@chicago admin]$ vi tnsnames.ora

BOSTON =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = boston.oracle.com)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = boston)
(SERVER = dedicated)
)
)

CHICAGO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = chicago)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

lsnrctl start
lsnrctl status

/* The following is Configured on standby database for the listener.ora and the tnsname.ora */
[oracle@boston admin]$ vi listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.200)(PORT = 1521))
)
)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=boston)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME=boston)
)
(SID_DESC=
(GLOBAL_DBNAME=chicago)
(ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)
(SID_NAME=chicago)
)
)

?

[oracle@boston admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

chicago =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.100)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = chicago)
)
)

boston =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.92.200)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = boston)
)
)

lsnrctl start
lsnrctl status

/* switch logfile on primary database */
alter system switch logfile;

/*
Start Redo Apply.On the standby database, issue the following command to start Redo Apply:
execute the following sql stament on standby database
*/
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

alter database recover managed standby database cancel;
alter database open;

/* on standby database
SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME
---------- --------- ---------
2 19-DEC-12 19-DEC-12
3 19-DEC-12 19-DEC-12
4 19-DEC-12 19-DEC-12
5 19-DEC-12 19-DEC-12
6 19-DEC-12 19-DEC-12
7 19-DEC-12 19-DEC-12
8 19-DEC-12 19-DEC-12
9 19-DEC-12 19-DEC-12
10 19-DEC-12 19-DEC-12
11 19-DEC-12 19-DEC-12
12 19-DEC-12 19-DEC-12

SEQUENCE# FIRST_TIM NEXT_TIME
---------- --------- ---------
13 19-DEC-12 20-DEC-12
14 20-DEC-12 20-DEC-12
15 20-DEC-12 20-DEC-12

14 rows selected.

SQL> SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# APP
---------- ---
2 YES
3 YES
4 YES
5 YES
6 YES
7 YES
8 YES
9 YES
10 YES
11 YES
12 YES

SEQUENCE# APP
---------- ---
13 YES
14 YES
15 YES

14 rows selected.
*/

SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;