Restore backup database no control file(database issue)

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.