Given below is a list of scenarios:
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3. A schema is accidentally dropped.
4. The tablespace is accidentally dropped from the database.
5. The hard disk gets corrupted and the data files in the disk are lost.
6. The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
A.
1, 3, and 6
B.
4, 5, and 6
C.
3, 4, and 5
D.
1, 2, and 6
I am puzzled. Why is the answer not B? My concept is that for Point 6, it will need DBA to perform recovery on control files?
Nope, in case of 6 it will be an auto recovery (crash recovery).
The key of why not 6 is that DBA intervention is not required because of instance failure. SMON will take care of the recovery.
C
Instance Recovery
If the database was last closed abnormally, either because the database administrator terminated its instance or because of a power failure, then Oracle automatically performs recovery when the database is reopened