|
||||
|
From 18c Onwards, we can enable Lost write protection for data blocks which occurs when an I/O subsystem acknowledges the completion of the block write even though the write did not occur or when a former image of the block overwrites the current image. We can enable the Shadow Lost Write protection at Database, Tablespace, […] In the event of gap or lot of archive pending we generally do a rollfoward recovery of standby using backup incremental from that SCN. This is simplified in 18c and we can use service with RMAN command. With 18c, you can now refresh the Standby using Service which is introduced in 12cR1. In previous versions […] Some important enhancements to Oracle Sharding. Now Supports CDB with a single PDB attached to it GSDCTL has new commands “add cdb” Supports CDB which has only one CDB User Defined Sharding methods In previous releases the tablespaces are related to a tablespace set In user defined sharding , we can specify our own tablespaces […] In 18c, the sequences can be scalable. Means the sequences will have an append of extra numbers with following formula. scalable sequence number = 6 digit scalable sequence offset number || normal sequence number 6 digit scalable sequence offset number = 3 digit instance offset number || 3 digit session offset number. The 3 digit […] In 18c, we can use RMAN command DUPLICATE to copy the PDB into an existing CDB. In previous releases we need to clone that to a new CDB and unplug and plug into a current CDB. Only active database based duplication is allowed and only one PDB is supported. Log file name convert and spfile […] In previous releases of Oracle, the database links and scheduler links password are stored in password column in sys.link$ and sys.scheduler$_link table, however the passwords are obfuscated not encrypted. We can encrypt the obfuscated password in 18c using “alter database dictionary” command. Create a keystore and define encryption method ADMINISTER KEY MANAGEMENT CREATE KEYSTORE ‘/etc/ORACLE/WALLETS/orcl’ […] Starting 18c, you can integrate the oracle database with Microsoft active directory services which will be a great feature and long awaiting one, Until now many of us using open ldap or third party ldap services to configure the same which is a overhead to the sys admins to manage two different directory services for […] From 18c, we can have Shared Scan Listeners between clusters instead of having different scan listener for each cluster. This will save a lot of IP’s and configuration aspect. For example, instead of 10 clusters deploying 3 SCAN VIPs per cluster using a total of 30 IP addresses, with shared SCAN deployments, you only deploy […] In this post, we will see few important ASM Disk group Level Enhancements in 18c. DISK_REPAIR_TIME : Increased from 3.5 hrs to 12 Hrs When a disk is taken offline from a disk group , the diskgroup will not immediately dropped as it waits for 3.5 Hrs as DISK_REPAIR_TIME , but now that […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!