Q

Starting database without control file

If someone lost the database control file, how can he start the original database?

If someone lost the database control file, how can he start the original database?

Hopefully, you've multiplexed your control files so you have at least one more copy of the control file. Let's

assume that you have three control files:

control01.ora
control02.ora
control03.ora

You lost control02.ora. Simply copy any one of the other two files and rename it to replace the missing control file.

Another option is to remove the missing control file from the CONTROL_FILES initialization parameter and start the database. This option only works if you have at least one good control file.

If you only have one control file, then you'll have to start the database in NOMOUNT mode and use the CREATE CONTROLFILE command to be able to create a control file.

One should always multiplex the control file so that recovery from a missing or corrupt control file is as easy as copying from a good control file.

This was first published in March 2006

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close