[Network Lesson excerpt]8.1 simulation control file after the loss of the database recovery (Full recovery)

1. Environment Readiness 1.1 Confirm database version

1.2 Confirming database archiving

1.3 Backing Up Database files

2 The database recovery after the analog control file is lost (Full recovery).

2.1 Viewing Control file Locations

2.2 Deleting a control file after performing an action

2.3 Starting the database

Start the database when the database error occurred, prompted unable to confirm the control file, check the alarm file, we now check the information in the alarm file:

2.4 Rebuilding the control file

If the log and data files are complete, if only the control file is lost, then rebuilding the control file is the best solution, the general reconstruction control file can solve 99% of the problem, and now we rebuild the control file.

2.5 Trying to open a database

From here you can see that the database is open and the current state of the data is read WRITE, so that when the control file is lost, the database is fully recovered.

[Network Lesson excerpt]8.1 simulation control file after the loss of the database recovery (Full recovery)