Category Archives: Oracle Database

Install Oracle patch set 4 and bundle 10 on RAC environment

Install Oracle 10g R2 Patch Set 4 (10.2.0.5) and Patch bundle 10. Oracle database throw ORA-4031 errors and restarting the database resolve the issue. I analyzed oracle database alert log. I found the error caused by a bug in oracle … Continue reading

Posted in Oracle Database | Tagged , , , | Leave a comment

Recover Oracle database

Recover Oracle database: This posting describes the steps to recover Oracle database at disaster recovery site in case of major disaster in the data center.  The disaster recovery plan assumes a regular backup of oracle database and it is control … Continue reading

Posted in Oracle Database | Tagged , , , | Leave a comment

Backup/restore Oracle database 10g

Purpose: The first time I have tried to restore Oracle database to a certain point it wasn’t easy like Microsoft SQL server, I wanted to patch the database with ERP system patch then restore to point before I applied the … Continue reading

Posted in Oracle Database | Tagged , , | Leave a comment