Data Guard启动故障转

select name,open_mode,database_role from v$database;

select flashback_on from v$database; 

select flashback_on from v$database;

alter database flashback on;

select PROCESS,CLIENT_PROCESS,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby where process = 'MRP0' or client_process='LGWR';
alter database recover managed standby database cancel;

alter database flashback on;

alter database recover managed standby database disconnect from session;

 

select name,open_mode,database_role from v$database;

alter database recover managed standby database cancel;

ALTER DATABASE OPEN READ ONLY;

alter database recover managed standby database using current logfile disconnect from session;

select name,open_mode,database_role from v$database;

show database verbose cdb1_stby LogXptMode;

edit database cdb1_stby set  property LogXptMode='SYNC';

edit database cdb1 set property LogXptMode='SYNC';

show configuration;

EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;

edit database cdb1_stby set  property FastStartFailoverTarget=cdb1;

edit database cdb1 set  property FastStartFailoverTarget=cdb1_stby;

show database verbose cdb1_stby FastStartFailoverTarget;

show database verbose cdb1 FastStartFailoverTarget;

show configuration verbose ObserverReconnect

edit configuration  set  property ObserverReconnect=120;

show fast_start failover

show observer

enable fast_start failover

show configuration;

start observer

disable fast_start failover

show observer 

ENABLE FAST_START FAILOVER OBSERVE ONLY

show fast_start failover