How to Create an Oracle Database Using an Existing Control File & Data Files

A control file is a backup of your database, so you can use it to create a new database from the Oracle backup. You use the Oracle command line utility to restore the database. You can give the database the same name as the backed up database, or you can give it a new name such as a reporting server name for end-user reports on the live server's data.

Instructions

1. Open the command line utility on your Oracle server. Log in to the server using an administrator username and password.

2. Type the following command into the command prompt:

   restore controlfile 'name' file

   Replace "name" with the name of the database you want to restore. Replace "file" with the file name.

3. Press "Enter" to execute the statement. After the statement completes, a "Success" message returns.

References

• Oracle: Restore