how to recover control file(no archivelog)

oracle query — Wed, 14 Jan 2009 07:09:01 GMT

while taking close backup the control files got deleted accidentally. Now how can i recover it back

i dont have any control file backup

Re: how to recover control file(no archivelog)

Shoghi Martinez G. — Wed, 14 Jan 2009 16:38:25 GMT

As you do not have control file backup, you must recreating this way, especify all your data files control file, database name and parameters to suit your configuration.

create a sql script and add (ORCL is a example instance name):
CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS ARCHIVELOG
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 14
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'E:\ORACLE\ORADATA\ORCL\REDO01.LOG' SIZE 100M,
GROUP 2 'E:\ORACLE\ORADATA\ORCL\REDO02.LOG' SIZE 100M,
GROUP 3 'E:\ORACLE\ORADATA\ORCL\REDO03.LOG' SIZE 100M
DATAFILE
'E:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF',
'E:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF',
'E:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF',
.... <- More datafiles here
CHARACTER SET WE8MSWIN1252 <- change
;

ALTER DATABASE OPEN RESETLOGS;

and rename it to ctl.sql

Then startup the database in nomount mode and run the ctl.sql file as sys as sysdba user

topic how to recover control file(no archivelog) in Operating System - Microsoft

how to recover control file(no archivelog)

Re: how to recover control file(no archivelog)