Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

12c Database : ASM Enhancements : OCR backup to disk group

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 […]

12c Database : ASM Enhancements : Logical corruption checks on disk, disk scrubbing

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 […]

12c Database : ASM Enhancements : New Replace Disk command

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 […]

12c Database : ASM Enhancements : Estimate the work for adding/deleting disks

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 […]

12c Database : ASM Enhancements : FlexASM – Overview

Flex ASM is a new architecture in Oracle Cluster/Grid Infrastructure where you can reduce the foot print of ASM instances in the cluster. I.e you really do not need 4 ASM instances for 4 Nodes.

In addition to above, Flex ASM also alleviate the problem of RDBMS instance dependency on ASM instance. For instance, if […]

12c Database : Index clustering factor – Do your own math

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 […]

12c Database : SQL Translation Framework – Developer thing

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 […]

12c Database : Limiting rows using fetch clause

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 […]

12c Database : View database patches from the sql prompt

From 12c onwards, you can view the database home patch list from sql prompt itself . A new package dbms_qopatch has been introduced to accomplish this.

Few cool sub routines in this package are get_opatch_install, lsinventory, opatch_bugs etc.

SQL> set longchunksize 1000 SQL> select DBMS_QOPATCH.get_opatch_install_info() from dual DBMS_QOPATCH.GET_OPATCH_INSTALL_INFO() ———————————————————————– OracleHome-5958ed72-136c-4adc-a078-e3ec7081a6e8 oracle_home oneoff /u01/app/oracle/product/12.1.0.1/db_1 oracle_home /u01/app/oraInventory […]