Add new redo group and change size of redo

Add new redo group and change size of redo https://docs.oracle.com/database/121/OSTMG/GUID-42519F90-AB27-46A8-9E59-18393C56C375.htm#OSTMG13960 1. query SQL> Select GROUP#,THREAD#,SEQUENCE#,bytes/1024/1024,MEMBERS,STATUS from v$log; GROUP# THREAD# SEQUENCE# BYTES/1024/1024 MEMBERS STATUS ———- ———- ———- ————— ———- —————- 1 1 13937 100 2 ACTIVE 2 1 13938 100 2 ACTIVE 3 1 13939 100 2 CURRENT 4 1 13936 100 2 INACTIVE SQL> select […]

Enabling supplemental log data

Enabling supplemental log data The following steps check whether supplemental log data is enabled and, if not, enable it. Enter the following command: select supplemental_log_data_min, supplemental_log_data_pk from v$database; If the command returns YES or IMPLICIT, supplemental log data is already enabled. For example, SUPPLEME SUP ——– — YES NO indicates that supplemental log data is […]

Different sizes of ASM disks in ASM diskgroup

Reference:  https://community.oracle.com/tech/apps-infra/discussion/4198843/different-sizes-of-asm-disks-in-asm-diskgroup https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG94124 https://oracle-base.com/articles/10g/automatic-storage-management-10g With Oracle 11.2.0.4, asmca allows me to create a diskgroup with differently sized disks, whereas asmca 12.2.0.1 does not:       With 12.2.0.1, it is also not possible to add a disk with a different size to an already existing disk group.   What works though is to replace an […]

Remote Clone PDB with error ORA-17628

Remote Clone PDB with error ORA-17628 Syptoms: SQL> CREATE PLUGGABLE DATABASE PTRG FROM PSRC@clone_link file_name_convert=(‘+DATA_TRG’,’+DATA_SRC’); CREATE PLUGGABLE DATABASE PTRG FROM PSRC@clone_link file_name_convert=(‘+DATA_TRG’,’+DATA_SRC’) * ERROR at line 1: ORA-17628: Oracle error 17630 returned by remote Oracle server ORA-17630: Mismatch in the remote file protocol version client server Cause: TRG: 12.2.0.1.190115 SRC: 12.1.0.2.180116 This appears to be […]