Thursday, July 14, 2011

Recover Database after all control files are lost


Shutdown the database if it’s not shutdown yet.

>Shutdown abort

You Must know the all datafile location or you have TRACE of Controlfile.


Note: how to create trace of control file
> alter database backup control file to trace

A text trace file will be create to udump directory

Or

> alter database backup controlfile to 'e:\tmp\ctrl.ctl';


> Startup nomount;



> RECOVER DATABASE
======================================================================
> ALTER DATABASE OPEN;
=======================================================================

> ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oracle\product\10.2.0\orcl\TEMP01.DBF'
     SIZE 29360128  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
=========================================================================
> ALTER TABLESPACE TEMP ADD TEMPFILE 'D:\oracle\product\10.2.0\orcl\TEMP01.DBF'
     SIZE 29360128  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;
========================================================================


No comments:

Post a Comment