CLUSTERAWARE DATABASE UITWIJKEN

  • Srvctl status database –d DB
    Instance DB1 is running on node srv1
    Instance DB2 is running on node srv2

Op de srv33  kijken in de tnsnames.ora of beide instances vermeld staan Tnsping dcsp geeft als resultaat alle instances

  • Srvctl enable instance –d DB –i DB3
  • Srvctl status database –d DB
    Instance DB1 is running on node srv1
    Instance DB2 is running on node srv2
    Instance DB3 is not running on node srv3
  • Srvctl start instance –d DB –I DB3
  • Srvctl status database –d DB
    Instance DB1 is running on node srv1
    Instance DB2 is running on node srv2
    Instance DB3 is running on node srv3
  • Srvctl stop instance –d DB –i DB1,DB2
  • Srvctl status database –d DB
    Instance DB1 is not running on node srv1
    Instance DB2 is not running on node srv2
    Instance DB3 is running on node srv3

Tnsping DB geeft als resultaat alle instances

Sqlplus sys@DBpassword as sysdba

  • Select * from v$instance;
  • Srv3.intranet.lan DB3
  • Srvctl status database –d DB
  • Srvctl start instantce –d DB –i DB1,DB2
  • Srvctl stop instance –d DB –i DB3
  • Srvctl disable instance –d DB –i DB3
  • Srvctl status database –d DB
    Instance DB1 is running on node srv1
    Instance DB2 is running on node srv2
    Instance DB3 is not running on node srv3
  • Srvctl status database –d DB
    Instance DB1 is running on node srv1
    Instance DB2 is running on node srv2
  • Srvctl status database –d DB1
    Instance DB12 is running on node srv2
    Instance DB13 is running on node srv3
  • Srvctl stop instance –d DB1 –I DB13
  • Srvctl disable instance –d DB1 –i DB13
  • Srvctl status database –d DB
    Instance DB12 is running on node srv2