Monthly Archives: September 2012

ASM file numbering

ASM instance does not have any physical storage component associated with it. All the metadata is stored as disk header. The data is stored in files, which are numbered < 256, with an exception of (asmparameterfile & ocrfile) So first … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | 1 Comment

ACFS & external tables on RAC

Oracle external tables are a great way to read text file and use them as tables. But if we are using this feature in a RAC database, any instance can access this external table. It will also expect underlying data … Continue reading

Posted in ACFS, Oracle 11.2.0.x, Oracle 11g Enhancements, Oracle Automatic Storage Management, Oracle External Tables, Oracle Real Application Cluster | Tagged | 1 Comment

RAC Install – How to check if the disks are shared across nodes

Before installing RAC, we need to make sure that the disks are actually shared across the nodes. Normally sysadmins will present and share disks. I normally check the ‘shared’ aspect using following process. NOTE: Cluvfy script will check this for … Continue reading

Posted in Oracle Real Application Cluster | Tagged , | Leave a comment

ASM incorrectly recognize 1TB+ disks on AIX

Recently we decided to consolidate the LUN’s presented to ASM on AIX box. Prior to consolidation ASM was using 16 x 100G LUN’s. Post consolidation we would only have 2 LUN’s 1 x 1 TB 1 x 600 GB SYSADMINS … Continue reading

Posted in Oracle Automatic Storage Management, Oracle Bugs | Tagged , , , | 1 Comment

Using ALTERNATE archive destination to handle archive overflow

Scenario – Define a secondary archive location, which will be used when primary destination is full Solution – We can define an archive destination with value ‘ALTERNATE’, which will take over if primary destination is full. As per Oracle documentation … Continue reading

Posted in Oracle Availability | Tagged | 3 Comments

Online Index Rebuild fails with ORA-08106: cannot create journal table

One of my daily index rebuild job abnormally failed with error “ORA-08106: cannot create journal table”. Following was the investigation & solution to fix the problem Before investigation few things to remember about online index rebuild 1. It will do … Continue reading

Posted in Oracle Index | Tagged | Leave a comment

Alter table move lob results in unusable indexes

Alter table move lob creates unusable indexes Recently came across this problem after moving a LOB column. After LOB moved the indexes on the table become unusable, even if the LOB and its index do not have any relation to … Continue reading

Posted in Oracle Bugs, Oracle Index | Tagged | Leave a comment