FSFO start obser一个疑问~以前没遇到，最近二周总这样

saup007

以前没遇到，最近二周总这样，可能是我忽略了什么地方，困惑中。。。

在Primary standby上都可以，在第三个机器上就是不行。命令如下：
$ nohup dgmgrl sys/oracle@db_pri10g "start observer file='/u01/app/oracle/admin/fsfo_PRI10G.dat'"  > /u01/app/oracle/admin/observer_PRI10G.log &

在第三个机器上执行后，dg 的配置

1. DGMGRL> show configuration verbose
   
2. 
   
3. Configuration
   
4.   Name:                FSFO
   
5.   Enabled:             YES
   
6.   Protection Mode:     MaxAvailability
   
7.   Fast-Start Failover: ENABLED
   
8.   Databases:
   
9.     pri10g - Primary database
   
10.     sta10g - Physical standby database
    
11.            - Fast-Start Failover target
    
12. 
    
13. Fast-Start Failover
    
14.   Threshold:           30 seconds
    
15.   Observer:            dbserver1
    
16.   Shutdown Primary:    TRUE
    
17. 
    
18. Current status for "FSFO":
    
19. Warning: ORA-16607: one or more databases have failed

复制代码

1. DGMGRL> show database pri10g
   
2. 
   
3. Database
   
4.   Name:            pri10g
   
5.   Role:            PRIMARY
   
6.   Enabled:         YES
   
7.   Intended State:  ONLINE
   
8.   Instance(s):
   
9.     PRI10G
   
10. 
    
11. Current status for "pri10g":
    
12. Error: ORA-16820: Fast-Start Failover observer is no longer observing this database
    
13. 
    
14. 
    
15. DGMGRL>
    
16. DGMGRL> show database sta10g
    
17. 
    
18. Database
    
19.   Name:            sta10g
    
20.   Role:            PHYSICAL STANDBY
    
21.   Enabled:         YES
    
22.   Intended State:  ONLINE
    
23.   Instance(s):
    
24.     STA10G
    
25. 
    
26. Current status for "sta10g":
    
27. Error: ORA-16820: Fast-Start Failover observer is no longer observing this database

复制代码

在第三台机器上
$ dgmgrl sys/oracle@db_pri10g
DGMGRL for Linux: Version 10.2.0.4.0 - 64bit Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected.

DGMGRL> start observer
也是可以的

第三台机器上可以通过sqlplus能连接到primary、standby
$ sqlplus sys/oracle@dg_pri10g as sysdba
$ sqlplus sys/oracle@dg_sta10g as sysdba$ sqlplus sys/oracle@db_pri10g as sysdba


TNSNAMES.ORA

1. DG_PRI10G =
   
2.   (DESCRIPTION =
   
3.     (ADDRESS_LIST =
   
4.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.41.145)(PORT = 1522))
   
5.     )
   
6.     (CONNECT_DATA =
   
7.       (SERVICE_NAME = PRI10G.LK)
   
8.       (server=dedicated)
   
9.     )
   
10.   )
    
11. 
    
12. DG_PRI10G_S =
    
13.   (DESCRIPTION =
    
14.     (ADDRESS_LIST =
    
15.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.41.145)(PORT = 1522))
    
16.     )
    
17.     (CONNECT_DATA =
    
18.       (SERVICE_NAME = PRI10G_DGMGRL.LK)
    
19.       (server=dedicated)
    
20.     )
    
21.   )
    
22. 
    
23. 
    
24. DG_STA10G =
    
25.   (DESCRIPTION =
    
26.     (ADDRESS_LIST =
    
27.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.41.76)(PORT = 1522))
    
28.     )
    
29.     (CONNECT_DATA =
    
30.       (SERVICE_NAME = STA10G.LK)
    
31.       (server=dedicated)
    
32.     )
    
33.   )
    
34. 
    
35. DG_STA10G_S =
    
36.   (DESCRIPTION =
    
37.     (ADDRESS_LIST =
    
38.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.41.76)(PORT = 1522))
    
39.     )
    
40.     (CONNECT_DATA =
    
41.       (SERVICE_NAME = STA10G_DGMGRL.LK)
    
42.       (server=dedicated)
    
43.     )
    
44.   )
    
45. 
    
46. DB_PRI10G=
    
47.    (DESCRIPTION =
    
48.       (ADDRESS_LIST =
    
49.       (ADDRESS=(PROTOCOL =TCP)(HOST = 192.168.41.145)(PORT = 1522))
    
50.       (ADDRESS = (PROTOCOL=TCP)(HOST=192.168.41.76)(PORT=1522))
    
51.        )
    
52.      (CONNECT_DATA =
    
53.          (SERVER=DEDICATED)
    
54.          (SERVICE_NAME= PRI10G_TAF.LK)
    
55.      )
    
56. )

复制代码

[ 本帖最后由 saup007 于 2012-5-25 09:56 编辑 ]