DATAGUARD,switchover and failover
Swithover important
Primary –> standby
select open_mode,database_role,switchover_status from v$database;
alter database commit to switchover to physical standby with session shutdown;
shutdown immediate;
startup mount;
alter database recover managed standby database using current logfile disconnect from session;
select process,status from v$managed_standby;
standby –> primary
select open_mode,database_role,switchover_status from v$database;
alter database commit to switchover to primary with session shutdown;
alter database open;
select open_mode,database_role,switchover_status from v$database;
failover important
primary down
…………………..
Standby –> primary
alter database recover managed standby database cancel;
alter database recover managed standby database finish force;
select open_mode,log_mode,database_role ,switchover_status from v$database;
alter database commit to switchover to primary;
shutdown immediate;
startup;
select open_mode,log_mode,database_role ,switchover_status from v$database;
select to_char(standby_became_primary_scn) from v$database;
primary up , flashback –> standby
select open_mode,log_mode,database_role ,switchover_status from v$database;
shutdown immediate;
startup mount;
flashback database to scn xxxx;
alter database convert to physical standby;
shutdown immediate;
startup;
select open_mode,log_mode,database_role ,switchover_status from v$database;
alter database recover managed standby database using current logfile disconnect from session;
select process,status from v$managed_standby;
select open_mode,log_mode,database_role ,switchover_status from v$database;