|
||||
|
Just to make a note here, (From Jafar notes) The ASM storage hard limits on maximum ASM disk groups and disk size has been drastically increased. In 12cR1, ASM support 511 ASM disk groups against 63 ASM disk groups in 11gR2. Also, an ASM disk can be now 32PB size against 20PB in 11gR2. […] Oracle Cluster Registry (OCR) backup in ASM disk group Before to 12c the ocr backup is located in the master node local disk at GRID_HOME/cdata/backup, but if OCR is corrupted and you have to restore you will need to find the master node and initiate the restore option. Storing the OCR backup in an […] ASM version 11.2 allowed ASM spfile to be placed in a disk group. In 12c we can also put ASM password file in an ASM disk group. Unlike ASM spfile, the access to the ASM password file is possible only after ASM startup and once the disk group containing the password is mounted. […] ASM 12c provides proactive scrubbing capabilities on disks that check for logical corruptions and automatically repair them where possible. SQL> alter diskgroup DG1 scrub repair; Diskgroup altered. SQL> alter diskgroup DG1 scrub file ‘+DATA_DISK/Geek DBA12C/DATAFILE/system.254.939393617’ repair wait; Diskgroup altered. SQL> alter diskgroup DG1 scrub disk DATA_DISK1 repair power max force; Diskgroup altered […] If an ASM disk becomes offline and cannot be repaired, administrators require the ability to replace the disk. In prior versions of ASM, there was no replace command. Rather, administrators had to drop the faulty disk and then add a new one back into the disk group. So,ASM level rebalance will takes place […] Before 12C,we can only come know about estimate time of disk add/drop like expensive operation at diskgroup level. So,We could not predict how much time this will take in before hand . In 12c ASM, a more detailed and more accurate work plan is created at the beginning of each rebalance operation. In […] From 12c, one can influence the clustering factor i.e set at custom level. For those who does not know about clustering factor and how does it influence the optimizer to use index or not. Suggesting to read the following, if you already know skip the following and proceed to test case. The clustering factor is […] SQL Translation framework is a new feature in 12c to give ability to the developers to migrate code without changing the underlying code. In addition , this feature also provides the translation of code from non-oracle to oracle coding. Further more, this feature can be a enhancement to sql profiles baselines etc. which can be […] Do you want to restrict row results not to display/retrieve fully? Until 11g, Oracle uses Top -n query method to retrieve top or bottom set of data using rownum, dense, rank etc. But this has limitation when order is required for that data and also an inline view is required and complex to write. For […] |
||||
Oracle 23c New Features for DBA's
Follow Me!!!