...
| No Format |
|---|
oracle@kiwi91[/usr/dbvisit/standby]: ./dbv_oraStartStop switchover DEV1 1 ... ... |
From Standby node 2 (kiwi81)
| No Format |
|---|
oracle@kiwi81[/usr/dbvisit/standby]: ./dbv_oraStartStop switchover DEV1 1
...
... |
Once the Graceful Switchover (GS) is complete, you will have a standby database instance running on kiwi91 (there will be no instance running on kiwi92 - it will be shutdown. Example:
| No Format |
|---|
oracle@kiwi91[/usr/dbvisit/standby]: srvctl status database -d DEV
Instance DEV1 is running on node kiwi91
Instance DEV2 is not running on node kiwi92
oracle@kiwi91[/usr/dbvisit/standby]: |
The instance running on kiwi81 is now the primary database database instance. The database instance can be updated to run again as a RAC instance as follow:
| No Format |
|---|
alter system set cluster_database_instances=2 scope=spfile;
alter system set cluster_database=true scope=spfile; |
On the new primary kiwi81
| No Format |
|---|
oracle@kiwi81[/usr/dbvisit/standby]: . oraenv
ORACLE_SID = [DEV1] ? DEV1
The Oracle base remains unchanged with value /u01/app/oracle
oracle@kiwi81[/usr/dbvisit/standby]: sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 7 18:47:24 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1
cluster_interconnects string
SQL> select controlfile_type from v$database;
CONTROL
-------
CURRENT
SQL> alter system set cluster_database_instances=2 scope=spfile;
System altered.
SQL> alter system set cluster_database=true scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
oracle@kiwi81[/usr/dbvisit/standby]: srvctl start database -d DEV
oracle@kiwi81[/usr/dbvisit/standby]: srvctl status database -d DEV -v
Instance DEV1 is running on node kiwi81. Instance status: Open.
Instance DEV2 is running on node kiwi82. Instance status: Open.
|