provere -  database role:

 

SELECT OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE FROM V$DATABASE;

 

 

 Prebacivanje - switchover na standby db:

 

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;

 

SQL> ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;

 

SQL> ALTER DATABASE OPEN;

 

 

  provera:

 

SQL> SELECT OPEN_MODE,PROTECTION_MODE,DATABASE_ROLE FROM V$DATABASE;

 

OPEN_MODE  PROTECTION_MODE      DATABASE_ROLE

---------- -------------------- ---------------- 

READ WRITE MAXIMUM PERFORMANCE  PRIMARY

 

 

 

 shutdown "old primary" & disable-ovati sve  skripte za "apply" i "sync"..