Asked By
shad javier
10 points
N/A
Posted on - 03/08/2012
I have to restore the database from backup, but the problem is that i do not have any control files.
How can i bring up this database.
Thank you
Restore backup database no control file(database issue)
There are some steps you need to follow in order to restore the database.
1. Startup without mount
SQL > startup nomount
2. Check the path of Control File
SQL> show parameter control
3. Create the Control File
SQL > CREATE CONTROLFILE REUSE DATABASE "ORCLE10G" RESETLOGS NOARCHIVELOG
MAXLOGFILES 14
MAXLOGMEMBERS 2
MAXDATAFILES 104
MAXINSTANCES 44
MAXLOGHISTORY 224
LOGFILE
GROUP 1 'K:ORCLE10GLOGREDO02.LOG' SIZE 50M,
GROUP 2 'K:ORCLE10GLOGREDO07.LOG' SIZE 90M,
GROUP 3 'K:ORCLE10GLOGREDO09.LOG' SIZE 50M
DATAFILE
'K:ORCLE10GDATASYST1.DBF',
'K:ORCLE10GDATAUNDS01.DBF',
'K:ORCLE10GDATASYSAX01.DBF',
'K:ORCLE10GDATAUS01.DBF',
'K:ORCLE10GDATAEXLE01.DBF',
'K:ORCLE10GDATAUND2.DBF'
CHARACTER SET WE8MSWIN1252;
4. Mount the Database
SQL> alter database mount;
5. If the database mounted successfully. Open the database with resetlogs option.
SQL> alter database open resetlogs;
If you get a message “Database Altered”, you are successful.
Please let us know your experience.