Which two effects would you see in your database?

In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database? (Choose two.)

In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database? (Choose two.)

A.
The database instance aborts.

B.
The database operation temporarily halts till the member becomes available.

C.
The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.

D.
The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

E.
Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.



Leave a Reply 0

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