Monthly Archives: June 2012

WARNING archived log not deleted, needed for standby or upstream capture process

I was having a situation, where my FRA was full & database was hung. After investigating found that archivelogs were not getting deleted, so occupying the space in FRA. When I tried deleting them manually I got following warning RMAN> … Continue reading

Posted in Oracle Golden Gate, Oracle Recovery Manager | Tagged , | Leave a comment

Datapump export to ASM diskgroup

We can create export dumps to the ASM diskgroups. But we can’t write expdp log to ASM (as it is a text file). We can store following file types in ASM – Control files – Datafiles, temporary datafiles, and datafile … Continue reading

Posted in Oracle Data Pump | Tagged | Leave a comment

Oracle instance terminate with ORA-27061: waiting for async I/Os failed

After migrating DB to new server (SuSE 11, Kernel 2.6.32.12-0.7), database was not able to create archive logs & crashing. — Alter log entries when the problem was seen Deleted Oracle managed file /u02/TESTDB/archivelog/2011_12_09/o1_mf_1_9367_7g3o3l7j_.arc Errors in file /u01/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_arc1_22457.trc: ORA-19502: write … Continue reading

Posted in Oracle Bugs | Tagged , , | 1 Comment

Checking table corruption using export

Export utility can be used, to determine if there is a table level corruption. exp system/manager TABLES='<table_name>’ log=tbl_chk.log file=test.dmp But we may have space constraint, when table is very large & we don’t have enough space to export that table. … Continue reading

Posted in Oracle Database Corrpution | Tagged | Leave a comment

CRS-4563: Insufficient user privileges

On a 11gR2 server, I was unable to start HAS serv1.com:+ASM:/home/oracle>crsctl start has CRS-4563: Insufficient user privileges. CRS-4000: Command Start failed, or completed with errors. After some investigation, found that OLR was missing. Current OLR location is pointing to /u01/app/oracle/product/11.2.0/grid/cdata/localhost/serv1.olr … Continue reading

Posted in Oracle Cluster Ready Services, Oracle Real Application Cluster | Tagged , , , , | 2 Comments