dg 实验的问题

两台机子  os  windows 2003   oracle version   oracle 10g 10.2.0primary database  spfilemoon.ora  (只显示与dg 相关的参数设置)
----------------------------------
*.control_files='g:\oracle\product\10.2.0\oradata\moon\control01.ctl','g:\oracle\product\10.2.0\oradata\moon\control02.ctl','g:\oracle\product\10.2.0\oradata\moon\control03.ctl'
*.db_domain=''
*.db_name='moon'
*.db_unique_name='moon'
*.log_archive_config='dg_config=(moon,standby)'
*.log_archive_dest_1='location=h:\archivelog_location valid_for=(all_logfiles,all_roles) db_unique_name=moon'
*.log_archive_dest_2='service=standby valid_for=(online_logfile,primary_role) db_unique_name=standby'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.remote_login_passwordfile='EXCLUSIVE'standby database spfile.ora (只显示dg相关参数设置)
-----------------------------------------------------
*.control_files='e:\oracle\product\10.2.0\oradata\standby\control01.ctl','e:\oracle\product\10.2.0\oradata\standby\control02.ctl','e:\oracle\product\10.2.0\oradata\standby\control03.ctl'
*.db_domain=''
*.db_file_name_convert='g:\oracle\product\10.2.0\oradata\moon\','e:\oracle\product\10.2.0\oradata\standby\','h:\system\','e:\oracle\product\10.2.0\oradata\standby\','h:\moon_tablespace\moon\datafile\','e:\oracle\product\10.2.0\oradata\standby\'
*.db_name='moon'
*.fal_client='moon'
*.fal_server='standby'
*.job_queue_processes=10
*.log_archive_config='dg_config=(moon,standby)'
*.log_archive_dest_1='location=e:\disk1 valid_for=(all_logfiles,all_roles) db_unique_name=standby'
*.log_archive_dest_2='service=moon valid_for=(online_logfile,primary_role) db_unique_name=moon)'
*.log_archive_dest_state_1='enable'
*.log_archive_dest_state_2='enable'
*.log_file_name_convert='h:\moon_logfile\disk\disk1\','e:\disk\disk1\','h:\moon_logfile\disk\disk2\','e:\disk\disk2\','h:\moon_logfile\disk\disk3\','e:\disk\disk3\','h:\moon_logfile\disk\disk4\','e:\disk\disk4\'
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=612368384
*.standby_file_management='auto'
问题只要是pramary database 不能像standby database 传送日志.
查看了一下显示:
SQL> column dest_name format a20
SQL> column destination format a20
SQL> column error format a20
SQL> set linesize 120
SQL> select dest_name ,destination , status , error
  2  from v$archive_dest_status;DEST_NAME            DESTINATION          STATUS    ERROR
-------------------- -------------------- --------- --------------------
LOG_ARCHIVE_DEST_1   h:\archivelog_locati VALID
                     onLOG_ARCHIVE_DEST_2   standby              ERROR     ORA-12514: TNS:
                                                    监听程序当前无法识别
                                                    连接描述符中请求的服
                                                    务LOG_ARCHIVE_DEST_3                        INACTIVE
LOG_ARCHIVE_DEST_4                        INACTIVE
LOG_ARCHIVE_DEST_5                        INACTIVEDEST_NAME            DESTINATION          STATUS    ERROR
-------------------- -------------------- --------- --------------------
LOG_ARCHIVE_DEST_6                        INACTIVE
LOG_ARCHIVE_DEST_7                        INACTIVE
LOG_ARCHIVE_DEST_8                        INACTIVE
LOG_ARCHIVE_DEST_9                        INACTIVE
LOG_ARCHIVE_DEST_10                       INACTIVE已选择10行。

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

可能是listener.ora 或者tnsnames.ora 配置出错了
priamry database    主数据库错在机子ip  192.168.1.100   备用数据库所在机子ip  192.168.1.101
listener.ora
-------------
# listener.ora Network Configuration File: g:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER_MOON =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = moon)
      (SID_NAME = moon)
    )
  )SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = g:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
  )LISTENER_MOON =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1522))
  )
tnsnames.ora
---------------
# tnsnames.ora Network Configuration File: g:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.STANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = standby)
    )
  )ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )MOON =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = moon)
    )
  )
standby database listener.ora
--------------
# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = standby)
      (ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
      (SID_NAME = standby)
    )
  )LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )
tsnnames.ora
-------------------------
# tnsnames.ora Network Configuration File: g:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.STANDBY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = standby)
    )
  )ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )MOON =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.100)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = moon)
    )
  )
帮我找找错误
已经google 过了. 没找到答案.或许是看不懂答案.
谢谢  在线等！！！！
1. *.log_archive_dest_2='service=moon valid_for=(online_logfile,primary_role) db_unique_name=moon)'这里service 写的是备库的实例2. 先启动备库，在启动主库。可能和启动顺序有关系。