Stop the cluster mode
root@rock8-19c-2:~>% pcs property set maintenance-mode=true
root@rock8-19c-2:~>% pcs property set maintenance-mode=true
root@rock8-19c-2:~>% pcs status
Cluster name: igt055_cluster
Status of pacemakerd: 'Pacemaker is running' (last updated 2024-04-11 11:03:14Z)
Cluster Summary:
* Stack: corosync
* Current DC: rock8-19c-1 (version 2.1.5-8.1.el8_8-a3f44794f94) - partition with quorum
* Last updated: Thu Apr 11 11:03:14 2024
* Last change: Thu Apr 11 11:03:09 2024 by root via cibadmin on rock8-19c-2
* 2 nodes configured
* 6 resource instances configured
*** Resource management is DISABLED ***
The cluster will not attempt to start, stop or recover services
Node List:
* Online: [ rock8-19c-1 rock8-19c-2 ]
Full List of Resources:
* Resource Group: ora_igt_rg (unmanaged):
* db1_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2 (unmanaged)
* online_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2 (unmanaged)
* exp_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2 (unmanaged)
* db2_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2 (unmanaged)
* ora_igt_vip (ocf::heartbeat:IPaddr2): Started rock8-19c-2 (unmanaged)
* ora_igt_ap (lsb:dbora_ctl): Started rock8-19c-2 (unmanaged)
Daemon Status:
corosync: active/enabled
pacemaker: active/enabled
pcsd: active/enabled
Can change oracle archive mode now
For example:
oracle@rock8-19c-2:~>% sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 11 11:15:45 2024
Version 19.22.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8589932704 bytes
Fixed Size 8960160 bytes
Variable Size 4328521728 bytes
Database Buffers 4244635648 bytes
Redo Buffers 7815168 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> ARCHIVE LOG LIST;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle_db/db1/db_igt/arch
Oldest online log sequence 496
Next log sequence to archive 498
Current log sequence 498
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Now start cluster mode
root@rock8-19c-2:~>% pcs property set maintenance-mode=false
root@rock8-19c-2:~>% pcs resource show
Warning: This command is deprecated and will be removed. Please use 'pcs resource status' instead.
* Resource Group: ora_igt_rg:
* db1_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2
* online_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2
* exp_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2
* db2_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2
* ora_igt_vip (ocf::heartbeat:IPaddr2): Started rock8-19c-2
* ora_igt_ap (lsb:dbora_ctl): Started rock8-19c-2
root@rock8-19c-2:~>% pcs resource disable ora_igt_rg
root@rock8-19c-2:~>% pcs resource enable ora_igt_rg
root@rock8-19c-2:~>% pcs status
Cluster name: igt055_cluster
Status of pacemakerd: 'Pacemaker is running' (last updated 2024-04-11 12:34:54Z)
Cluster Summary:
* Stack: corosync
* Current DC: rock8-19c-1 (version 2.1.5-8.1.el8_8-a3f44794f94) - partition with quorum
* Last updated: Thu Apr 11 12:34:54 2024
* Last change: Thu Apr 11 11:35:59 2024 by root via cibadmin on rock8-19c-2
* 2 nodes configured
* 6 resource instances configured
Node List:
* Online: [ rock8-19c-1 rock8-19c-2 ]
Full List of Resources:
* Resource Group: ora_igt_rg:
* db1_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2
* online_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2
* exp_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2
* db2_igt_fs (ocf::heartbeat:Filesystem): Started rock8-19c-2
* ora_igt_vip (ocf::heartbeat:IPaddr2): Started rock8-19c-2
* ora_igt_ap (lsb:dbora_ctl): Started rock8-19c-2
Daemon Status:
corosync: active/enabled
pacemaker: active/enabled
pcsd: active/enabled
No comments:
Post a Comment