主从,我按照人家的方法搞的,也没提示错误。
但是 主机的  
idle> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/oracle/arclog_orcl
Oldest online log sequence     36
Next log sequence to archive   38
Current log sequence           38从机器的 
idle> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/oracle/arclog_orcl
Oldest online log sequence     0
Next log sequence to archive   0
Current log sequence           0在从机查询 idle> Select   sequence#,applied from v$archived_log
  2  ;no rows selected
啥也没有的。  这是怎么回事儿呢。

解决方案 »

  1.   

     主机的 参数文件后边添加的:
    *.db_unique_name='orcl'
    *.log_archive_config='dg_config=(orcl,orcl129)'
    *.log_archive_dest_1='LOCATION=/home/oracle/oracle/arclog_orcl VALID_FOR=(ALL_LOGFILES,ALL_ROLES) 
    DB_UNIQUE_NAME=orcl'
    *.log_archive_dest_2='SERVICE=orcl129  LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) 
    DB_UNIQUE_NAME=orcl129'
    *.log_archive_dest_state_1='ENABLE'
    *.log_archive_dest_state_2='ENABLE'
    fal_server=orcl129
    fal_client=orcl
    db_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/orcl
    ','/home/oracle/oracle/product/10.2.0/oradata/orcl'
    log_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/orcl','/home/oracle/oracle/product/10.2.0/
    oradata/orcl'
    STANDBY_FILE_MANAGEMENT=AUTO从机参数文件。 *.db_unique_name='orcl129'
    *.log_archive_config='dg_config=(orcl129,orcl)'
    *.log_archive_dest_1='LOCATION=/home/oracle/oracle/arclog_orcl VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
    DB_UNIQUE_NAME=orcl129'
    *.log_archive_dest_2='SERVICE=orcl  LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl'
    *.log_archive_dest_state_1='ENABLE'
    *.log_archive_dest_state_2='ENABLE'
    fal_server=orcl
    fal_client=orcl129
    db_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/orcl','/home/oracle/oracle/product/10.2.0/oradata/orcl'
    log_file_name_convert='/home/oracle/oracle/product/10.2.0/oradata/orcl','/home/oracle/oracle/product/10.2.0/oradata/orcl'
      

  2.   

    后来发现问题了 是因为 主从量个机器没能互相连接通。
     我从主机用sqlplus登录从机 就不行。后来修改了 tns (不是监听)那个文件 后可以了。、