Which three statements are true about the database instance startup after an instance
failure?
A.
The RECO process recovers the uncommitted transactions at the next instance startup.
B.
Online redo log files and archived redo log files are required to complete the rollback stage
of instance recovery.
C.
Uncommitted changes are rolled back to ensure transactional consistency.
D.
The SMON process automatically performs the database recovery.
E.
Media recovery is required to complete the database recovery.
F.
Changes committed before the failure, which were not written to the data files, are reapplied.
C, D and F should be answers.
Everybody agree on C D and F?
Thanks vijay
CDF
CDF
CDF
CDF
ACD is the correct answer.
F is not required as the transaction recovery will be performed by SMON which is already covered in D step.
agree ?
No, not at all. The RECO process has nothing to do with instance recovery. CDF is perfect!
CDF
A is wrong
Recoverer Process (RECO)
In a distributed database, the recoverer process (RECO) automatically resolves failures in distributed transactions.
The RECO process of a node automatically connects to other databases involved in an in-doubt distributed transaction. When RECO reestablishes a connection between the databases, it automatically resolves all in-doubt transactions, removing from each database’s pending transaction table any rows that correspond to the resolved transactions.
CDF