Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
Operating System - Microsoft
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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