Special welcome gift. Get 50% off your first courses with code “AS50”. Find out more!

HomeInterview How will you recover a lost control file?
course 10

 How will you recover a lost control file?

The steps to recover a lost control file:

  1. Start the database in NOMOUNT mode.
  2. Create the control file from the control file backup with the CREATE CONTROLFILE statement and place it in the correct location.
  3. Mount the database.
  4. Recover the database.
  5. Open the database.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

Categories

ads sidebar 1

You May Also Like

Oracle has several modes for shutting down the database: In normal mode, the database is shut down by default. It...
Materialized views are items that contain condensed sets of data from base tables that have been summarized, clustered, or aggregated. They...
Every database in Oracle has a tablespace called SYSTEM, which is generated automatically when the database is created. It also...