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;
========================================================================
SIZE 29360128 REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M;
========================================================================
No comments:
Post a Comment