fsfo

admin

在主库上开启fsfo,提示flashback没开，检查发现主库开了，备库没开，备库开闪回后，再看下fsfo

1. [oracle@vm1 ~]$ dgmgrl
   
2. DGMGRL for Linux: Release 19.0.0.0.0 - Production on Tue Aug 10 21:52:20 2021
   
3. Version 19.12.0.0.0
   
4. 
   
5. Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
   
6. 
   
7. Welcome to DGMGRL, type "help" for information.
   
8. DGMGRL> connect sys@ora19
   
9. Password:
   
10. Connected to "ora19"
    
11. Connected as SYSDBA.
    
12. DGMGRL> show configuration
    
13. 
    
14. Configuration - dgcfg
    
15. 
    
16.   Protection Mode: MaxPerformance
    
17.   Members:
    
18.   ora19  - Primary database
    
19.     ora19b - Physical standby database
    
20. 
    
21. Fast-Start Failover:  Disabled
    
22. 
    
23. Configuration Status:
    
24. SUCCESS   (status updated 25 seconds ago)
    
25. 
    
26. DGMGRL> enable fast_start failover
    
27. Warning: ORA-16827: Flashback Database is disabled
    
28. 
    
29. Enabled in Potential Data Loss Mode.

复制代码

提示observer没开启，用命令开启一下，发现连个库都连接才能都取消掉警告信息

1. DGMGRL> connect sys@ora19  
   
2. Password:
   
3. Connected to "ora19"
   
4. Connected as SYSDBA.
   
5. DGMGRL> show configuration
   
6. 
   
7. Configuration - dgcfg
   
8. 
   
9.   Protection Mode: MaxPerformance
   
10.   Members:
    
11.   ora19  - Primary database
    
12.     Warning: ORA-16819: fast-start failover observer not started
    
13. 
    
14.     ora19b - (*) Physical standby database
    
15.       Warning: ORA-16819: fast-start failover observer not started
    
16. 
    
17. Fast-Start Failover: Enabled in Potential Data Loss Mode
    
18. 
    
19. Configuration Status:
    
20. WARNING   (status updated 43 seconds ago)
    

复制代码

1. [oracle@vm2 ~]$ pwd
   
2. /home/oracle
   
3. [oracle@vm2 ~]$ nohup dgmgrl sys/oracle@ora19 "start observer file=FSFO.dat">>fsfo.log 2>&1 &
   
4. [1] 3123
   
5. [oracle@vm2 ~]$ nohup dgmgrl sys/oracle@ora19b "start observer file=FSFO.dat">>fsfo.log 2>&1 &
   
6. [2] 3177
   

复制代码

启动了两个分别到主备的observer后，再看fsfo,状态正常了

1. DGMGRL> show configuration
   
2. 
   
3. Configuration - dgcfg
   
4. 
   
5.   Protection Mode: MaxPerformance
   
6.   Members:
   
7.   ora19  - Primary database
   
8.     ora19b - (*) Physical standby database
   
9. 
   
10. Fast-Start Failover: Enabled in Potential Data Loss Mode
    
11. 
    
12. Configuration Status:
    
13. SUCCESS   (status updated 45 seconds ago)
    

复制代码

1. DGMGRL> edit configuration set protection mode as maxavailability;
   
2. Error: ORA-16654: fast-start failover is enabled
   
3. 
   
4. Failed.
   
5. DGMGRL> disable fast_start failover;
   
6. Disabled.
   
7. DGMGRL> edit database ora19b set property 'LogXptMode'='SYNC';
   
8. Property "LogXptMode" updated
   
9. DGMGRL> edit configuration set protection mode as maxavailability;
   
10. Succeeded.
    
11. DGMGRL> enable fast_start failover
    
12. Enabled in Zero Data Loss Mode.
    
13. DGMGRL>
    

复制代码

1. DGMGRL> SHOW FAST_START FAILOVER;
   
2. 
   
3. Fast-Start Failover: Enabled in Zero Data Loss Mode
   
4. 
   
5.   Protection Mode:    MaxAvailability
   
6.   Lag Limit:          0 seconds
   
7. 
   
8.   Threshold:          30 seconds
   
9.   Active Target:      ora19b
   
10.   Potential Targets:  "ora19b"
    
11.     ora19b     valid
    
12.   Observer:           vm2
    
13.   Shutdown Primary:   TRUE
    
14.   Auto-reinstate:     TRUE
    
15.   Observer Reconnect: (none)
    
16.   Observer Override:  FALSE
    
17. 
    
18. Configurable Failover Conditions
    
19.   Health Conditions:
    
20.     Corrupted Controlfile          YES
    
21.     Corrupted Dictionary           YES
    
22.     Inaccessible Logfile            NO
    
23.     Stuck Archiver                  NO
    
24.     Datafile Write Errors          YES
    
25. 
    
26.   Oracle Error Conditions:
    
27.     (none)
    

复制代码