Questions
& Answers

For
mid-term exam
Implement
Database Backup
1.
Among the failure
events, which is the most serious?
A.
The
loss of an entire redo log file group but no loss in any other group
B.
The loss of one member
of each redo log file group
C.
The failure of the
ARC0 background process
D.
The failure of the
LGWR background process
A. Losing an entire redo log
file group can result in losing committed transactions that may not
yet have been written to the database files. Losing all members of a
redo log file group except for one does not affect database operation
and does not result in lost data. A message is placed in the alert
log file. The failure of LGWR or ARC0 causes an instance failure, but
you do not lose any committed transaction data.