Unpublished and Unofficially switch the logfile of all the threads by one command
A. Switch the logfile of current instance only.
SQL> alter system switch logfile; System altered.
B. Archive the logfile of all the threads in RAC environment.
SQL> alter system archive log current; System altered.
C. Switch the logfile of all the threads in RAC environment (Unpublished , Unofficially ).
SQL>alter system switch all logfile; System altered.
D. Make Checkpoint for all Instances in a RAC environment with single command.
SQL> ALTER SYSTEM CHECKPOINT GLOBAL; (LOCAL is default)
When tried to create diskgroup FRA, and got the following errors:
SQL> CREATE DISKGROUP FRA EXTERNAL REDUNDANCY
DISK '/dev/oracleasm/disks/ASM_FRA01' NAME ASM_FRA01;
CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/ASM_FRA01' NAME ASM_FRA01
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification '/dev/oracleasm/disks/ASM_FRA01' matches no disks
ORA-15014: path '/dev/oracleasm/disks/ASM_FRA01' is not in the discovery set
Checked ASM disk already existed:
# oracleasm listdisks ... ... ASM_FRA01 OCR_VOTE01 ... ... SQL> ! ls -ltr /dev/oracleasm/disks/ASM_FRA01 brw-rw---- 1 grid dba 253, 2 Sep 26 15:32 /dev/oracleasm/disks/ASM_FRA01
Read more of this content when you subscribe today.
In Oracle Enterprise Manager( OEM ) 12c and 13c, there are a couple of newly added cluster databases targets and database system targets are in “PENDING” status, though all the cluster database instances are showing up.
Read more of this content when you subscribe today.
It is a good practice to temporarily disable CRS auto start up when OS upgrading or patching.
Read more of this content when you subscribe today.
It is recommended to relink GI and RAC Home binaries after OS upgrading or patching.
This post demonstrates how to relink Oracle Grid Infrastructure ( GI ) and RAC Home binaries after OS upgrading or patching.
Read more of this content when you subscribe today.
Make DBA Life Easy 