Mirror Redo log file status is showing Invalid [message #63422] |
Mon, 04 October 2004 08:09 |
gurinder
Messages: 16 Registered: September 2004
|
Junior Member |
|
|
sTATUS OF OnlineRedo Log mirror is showing Invalid
is this a problem or how can i make it valid
SELECT * FROM V$LOGFILE;
GROUP# STATUS TYPE MEMBER
------ ------- ------- ---------------------------------------
3 STALE ONLINE C:ORACLEORADATABTRTREDO03.LOG
2 STALE ONLINE C:ORACLEORADATABTRTREDO02.LOG
1 ONLINE C:ORACLEORADATABTRTREDO01.LOG
1 INVALID ONLINE D:REDO_LOGSLOG1B.LOG
2 INVALID ONLINE D:REDO_LOGSLOG2B.LOG
3 INVALID ONLINE D:REDO_LOGSLOG3B.LOG
|
|
|
|
Re: Mirror Redo log file status is showing Invalid [message #63432 is a reply to message #63422] |
Mon, 04 October 2004 12:06 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
An INVALID status indicates that the log file is not accessible. Check to see if you can still see it on disk.
To fix it, you need to drop the damaged members:
ALTER DATABASE DROP LOGFILE MEMBER 'D:REDO_LOGSLOG1B.LOG';
Then, add them again (ensure the directory is valid):
ALTER DATABASE ADD LOGFILE MEMBER 'D:REDO_LOGSLOG1B.LOG' TO GROUP 1;
Best regards.
Frank
|
|
|
Re: Mirror Redo log file status is showing Invalid [message #64174 is a reply to message #63432] |
Mon, 27 December 2004 10:58 |
Steven G.
Messages: 1 Registered: December 2004
|
Junior Member |
|
|
I had to do a combination of dropping , forcing a log switch, and reuse/add of the log file.
- drop
SQL> alter database drop logfile member
'/d1/oradata/intralink/dbs/ilnk_redolog_g03_m02.dbf';
- force
SQL> ALTER SYSTEM SWITCH ;
- reuse
SQL> ALTER DATABASE ADD LOGFILE MEMBER '/d1/oradata/intralink/dbs/ilnk_redolog_g03_m02.dbf'reuse to group 1 ;
|
|
|