Ask the Expert

Starting database without control file

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

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: