Big talk RAC Media recovery---online log corruption

Corruption of online logs to be analyzed based on log status, online logs typically have three states of current, active, and inactive. Inactive status does not cause data loss. The log of active and current states generally results in loss of data. Judge the state of the corrupted log according to V$log.status.

A. If the log in the inactive state is corrupted, drop the group log to be able. Because each thread must have at least two sets of logs, you should add a group before deleting it.

B. In the case of a active/current state, proceed as follows:

1. Close all instances 2. On the damaged instance, boot to mount State; 3. Use recover database until Cancel to simulate an incomplete recovery 4. Execute ALTER DATABASE open Resetlogs Command 5. When the instance starts successfully, start another instance 6. Make a full backup of the database

Organized from "Big talk RAC" Zhang Xiaoming p306-p312

Big talk RAC Media recovery---online log corruption