Restore backup database no control file(database issue)

Asked By 10 points N/A Posted on -
qa-featured

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

SHARE
Answered By 0 points N/A #101371

Restore backup database no control file(database issue)

qa-featured

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.

Login/Register to Answer

Related Questions