补充说明：==oracle官方配置===lvlisong==

（2006年 发布的，应该是9版本的===）

1.       tnsname.ora配置

CHICAGO1_SERV = (DESCRIPTION =  (ADDRESS =

   (PROTOCOL = TCP)

   (HOST =chicago_host1vip)

   (PORT = 1521))

  (CONNECT_DATA =

    (SERVER =DEDICATED)

    (SERVICE_NAME = CHICAGO)

    (INSTANCE_NAME =CHICAGO1)

  )

)

CHICAGO2_SERV =

(DESCRIPTION =

  (ADDRESS =

   (PROTOCOL = TCP)

   (HOST = chicago_host2vip)

   (PORT = 1521))

  (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = CHICAGO)

    (INSTANCE_NAME = CHICAGO2)

  )

BOSTON =

(DESCRIPTION =

  (ADDRESS =

   (PROTOCOL = TCP)

   (HOST =boston_host1)

   (PORT = 1521))

  (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = BOSTON)

  )

)   

 Primary Database======配置==

*.db_unique_name=CHICAGO
*.service_names=CHICAGO

*.log_archive_config='dg_config=(CHICAGO,BOSTON)'
*.log_archive_dest_2='service=BOSTON valid_for=(online_logfiles,primary_role)   db_unique_name=BOSTON'

*.db_file_name_convert='+DATA/BOSTON/',’+DATA/CHICAGO/', ’+RECOVERY/BOSTON’,’+RECOVERY/CHICAGO’
*.log_file_name_convert='+DATA/BOSTON/',’+DATA/CHICAGO/', ’+RECOVERY/BOSTON’,’+RECOVERY/CHICAGO’

=说明=下面参数是switch over用的,切换成standy时，fal_server='bosten'=
*.standby_file_management=auto
*.fal_server='BOSTON'    
CHICAGO1.fal_client='CHICAGO1_SERV'
CHICAGO2.fal_client='CHICAGO2_SERV'

Standby database==================配置============

*.service_names='BOSTON'

   *.db_unique_name='BOSTON'

*.log_archive_config='dg_config= (CHICAGO,BOSTON)'
*.log_archive_dest_2='service=CHICAGO1_SERV valid_for=(online_logfiles,primary_role)
  db_unique_name=CHICAGO'
*.db_file_name_convert='+DATA/CHICAGO/', '+DATA/BOSTON/','+RECOVERY/CHICAGO',
   '+RECOVERY/BOSTON'
*.log_file_name_convert='+DATA/CHICAGO/','+DATA/BOSTON/','+RECOVERY/CHICAGO',
   '+RECOVERY/BOSTON'

*.standby_file_management=auto
*.fal_server='CHICAGO1_SERV','CHICAGO2_SERV'
*.fal_client='BOSTON'

primary database create standby redo log========

2.             Create standby redo logs on the primary database to support the standby role. The standby redo logs are the same size as the primary database online logs. The recommended number of standby redo logs is one more than the number of online redo logs for each thread. Because this example has two online redo logs for each thread, three standby redo logs are required for each thread.

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 5 SIZE 10M,
GROUP 6 SIZE 10M,
GROUP 7 SIZE 10M;

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 2
GROUP 8 SIZE 10M,
GROUP 9 SIZE 10M,
GROUP 10 SIZE 10M;

physical standby database-------------------------------

   (maximum # of logfiles +1) * maximum # of threads 

This example uses two online log files for each thread. Thus, the number of standby redo logs should be (2 + 1) * 2 = 6. That is, one more standby redo log file for each thread.

Thread 1, group 1 2

Thread 2,group 3, 4

SQL> ALTER DATABASE ADD STANDBY LOGFILE THREAD 1
GROUP 5 SIZE 10M,
GROUP 6 SIZE 10M,
GROUP 7 SIZE 10M;

SQL> ALTER DATABASE ADD STANDBY LOGFILETHREAD 2
GROUP 8 SIZE 10M,
GROUP 9 SIZE 10M,
GROUP 10 SIZE 10M;

查询：

SQL> SELECT * FROM V$LOG;

SQL> SELECT * FROM V$STANDBY_LOG;

SQL> SELECT * FROM V$LOGFILE;