|
||||
|
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 […] Hi AIOUG Hyderabad chapter conducting free half day seminar on 18c Database and I am speaking on 18c New Features. Please register for free either click on image or below link and seats are limited. https://www.meraevents.com/event/aioug-hyderabad-oracle-autonomous-database-18c I am speaking too Time Topic Speaker Info 08 30 AM – 9 00 AM – Registrations 9 […] Starting 18c, the software zip file from Oracle contains the Oracle Home itself, means its already extracted and you can unzip it in the required folder where the intended folder to be a oracle home. The installation process just Relinks it. This facilitates the faster Oracle Home provisioning and rapid deployments. Two Important changes in […] 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!!!