Operating System - Microsoft
1752701 Members
6376 Online
108789 Solutions
New Discussion

how to recover control file(no archivelog)

 
oracle query
Occasional Contributor

how to recover control file(no archivelog)

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

i dont have any control file backup
1 REPLY 1
Shoghi Martinez G.
Honored Contributor

Re: how to recover control file(no archivelog)

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