Restore backup database no control file(database issue)

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

• Status: Open
• Question Views: 923
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Kanhai Else 0 points N/A #101371

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.

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/14/2012
• Question Category: Oracle Database