Database Reference
In-Depth Information
3.
If there is still one functioning member of a multiplexed group, then see the section of this
chapter on “Restoring After Losing One Member of Multiplexed Group” for details on how
to fix a failed member(s).
4.
Depending on the status of the log group, use Table
7-1
to determine what action to take.
Table 7-1.
Determining the Action to Take
Type of Failure
Status Column
of V$LOG
Action
Section
One member failed in
multiplexed group
N/A
Drop/re-create member.
Restoring after Losing One
Member of a Multiplexed Group
All members of group
INACTIVE
Clear logfile or
drop/re-create log group.
Recovering After Loss of All
Members Inactive Group
All members of group
ACTIVE
Attempt checkpoint, and
if successful, clear logfile.
If checkpoint is unsuccessful,
perform incomplete recovery.
Recovering After Loss of All
Members Active Group
All members of group
CURRENT
Attempt to clear log, and if
unsuccessful, perform incomplete
recovery.
Recovering After Loss of All
Members of Current Group
Inspect your target database
alert.log
file to determine which online redo log file member is unavailable.
Oracle error messages related to online redo log file failures are
ORA-00312
and
ORA-00313
. Here's an example of errors
written to the
alert.log
file when there are problems with an online redo log file:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u02/oraredo/O12C/redo02b.rdo'
Query
V$LOG
and
V$LOGFILE
views to determine the status of your log group and the member files in each group:
SELECT
a.group#
,a.thread#
,a.status grp_status
,b.member member
,b.status mem_status
,a.bytes/1024/1024 mbytes
FROM v$log a,
v$logfile b
WHERE a.group# = b.group#
ORDER BY a.group#, b.member;
