image

Instance recovery required cannot set archivelog

ERROR Description SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode   Reason : During the last shutdown , the database was not properly shutdown . I used the command shutdown abort. Solution: Start database Normally . SQL> Startup Open; Then Shutdown normally SQl> … continue reading

image

Recover Oracle database from a corrupt or missing control file

This article will detail about the recovery of oracle database due to loss or corrupt of control file under two senario 1. Corrupt or Missing of Control File 2.  All control files are corrupt or missing If you don’t know the location of the control file as well as multiplexing of the control file click … continue reading

image

Multiplexing Control File

This article will focus on multiplexing the  control file. There are possibilities where control file can go corrupt , loss or damage by accident or some accidental deletion. Having multiple copies of control files will reduce risk of  result of loss of control files.If we have the copy of the control files we can simply … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube