status ru
Displays runtime information about replication units for Oracle Globally Distributed AI Database native Raft replication.
Syntax
(STATUS REPLICATION | STATUS RU| RU)
[-show_offline]
[-savename]
[-sort]
[-gsm gsmname]
[-catpwd pwd]
[-wpwd wpwd]
[-show_chunks]
[-ru ru]
[-leaders]
[-database shard_name]
[-show_errors [-all]]
[-show_stats]
Options
Table 2-109 GDSCTL status ru Options
| Option | Description |
|---|---|
-all |
If not specified, only errors since last recovery are shown. |
-catpwd |
GSMCATUSER password. Both
|
-database |
Shard name |
-gsm |
GSM (shard director) name |
-leaders |
Only leader information is displayed. |
-ru |
Replication unit ID |
-show_chunks |
Show chunk distribution across all replication units. |
-show_errors |
Show replication unit errors. |
-show_offline |
Show the list of offline (down) shards that have that RU. |
-show_stats |
Show usage statistics |
-sort |
Sort the outputby replication unilt ID. |
-wpwd |
Wallet password |
Examples
GDSCTL> status ru
Replication units
------------------------
Database RU# Role Term Log Index Apply SCN LWM SCN On-disk SCN
-------- --- ---- ---- --------- --------- ------- -----------
cdbsh1_sh1 1 Leader 2 315471 1 0 304531
cdbsh1_sh1 2 Follower 1 456282 451835 452939 456611
cdbsh1_sh1 3 Follower 2 262706 260479 261605 262709
cdbsh2_sh2 2 Leader 1 456282 0 0 446475
cdbsh2_sh2 1 Follower 2 315471 313342 14393 315479
cdbsh2_sh2 3 Follower 2 262706 260479 261605 262709
cdbsh3_sh3 3 Leader 2 262706 1 0 252741
cdbsh3_sh3 1 Follower 2 315471 314395 314393 315477
cdbsh3_sh3 2 Follower 1 456282 452941 452939 456583
GDSCTL> status ru -ru 2
Replication units
------------------------
Database RU# Role Term Log Index Apply LogIdx LWM LogIdx On-disk LogIdx Status
-------- --- ---- ---- --------- ------------ ---------- -------------- ------
den1b_cdb2_pdb1 2 Leader 1 1 0 0 2 Ok
den1d_cdb4_pdb1 2 Follower 1 1 0 0 1 Ok
den1c_cdb3_pdb1 2 Follower 1 1 0 0 1 Ok
GDSCTL> status ru -ru 2 -show_chunks
Chunks
------------------------
RU# From To
--- ---- --
2 8 8
Replication units
------------------------
Database RU# Role Term Log Index Apply LogIdx LWM LogIdx On-disk LogIdx Status
-------- --- ---- ---- --------- ------------ ---------- -------------- ------
den1b_cdb2_pdb1 2 Leader 1 1 0 0 2 Ok
den1d_cdb4_pdb1 2 Follower 1 1 0 0 1 Ok
den1c_cdb3_pdb1 2 Follower 1 1 0 0 1 OkGDSCTL> ru -sort -show_chunks
Chunks
------------------------
RU# From To
--- ---- --
1 1 7
2 8 8
Replication units
------------------------
Database RU# Role Term Log Index Status
-------- --- ---- ---- --------- ------
den1b_cdb2_pdb1 1 Leader 1 3658 Ok
den1c_cdb3_pdb1 1 Follower 1 3658 Ok
den1d_cdb4_pdb1 1 Follower 1 3658 Ok
den1b_cdb2_pdb1 2 Leader 1 1 Ok
den1c_cdb3_pdb1 2 Follower 1 1 Ok
den1d_cdb4_pdb1 2 Follower 1 1 Ok GDSCTL> ru -sort -show_errors
Replication units
------------------------
Database RU# Role Term Log Index Status
-------- --- ---- ---- --------- ------
den1b_cdb2_pdb1 1 Leader 1 3658 Ok
den1c_cdb3_pdb1 1 Follower 1 3658 Ok
den1d_cdb4_pdb1 1 Follower 1 3658 Ok
den1b_cdb2_pdb1 2 Leader 1 1 Ok
den1c_cdb3_pdb1 2 Follower 1 1 Ok
den1d_cdb4_pdb1 2 Follower 1 1 Ok
ERRORS
------------------------GDSCTL> ru -sort -database den1b_cdb2_pdb1
Replication units
------------------------
Database RU# Role Term Log Index Status
-------- --- ---- ---- --------- ------
den1b_cdb2_pdb1 1 Leader 1 3658 Ok
den1b_cdb2_pdb1 2 Leader 1 1 Ok