Re: log switch sequence

From: <satar_at_my-dejanews.com>
Date: Tue, 03 Nov 1998 00:34:59 GMT
Message-ID: <71lj3k$7mu$1@nnrp1.dejanews.com>

You guys got me, I don't know why that would happen. Anyway, the real reason I replied to this post, is to point out that you only have one member per group. Which is dangerous, seeing how this can be a single point of faliure. Make sure you have 2 members per group.

Satar

In article <71ej75$3hf$1_at_home.kpbank.ru>, real_at_kpbank.ru (Alexey M. Reshetov) wrote:

> SELECT group#, thread#, sequence#, members, archived, status FROM v$log;
> GROUP# THREAD# SEQUENCE# MEMBERS ARC STATUS
> ------ ------- --------- ------- --- --------
> 1 1 238 1 NO INACTIVE
> 2 1 239 1 NO INACTIVE
> 3 1 237 1 NO INACTIVE
> 4 1 240 1 NO CURRENT
>
> And later, when ALTER SYSTEM SWITCH LOGFILE occurs, switching of logfiles
> will: 1,2,4,3.
>
> I don't know about any negative consequences of it. It's only test system,
> and I never look for such database with archivelog mode and recovering.
>
> Regards,
> ____________________________________________________
> Alexey Reshetov
> real_at_kpbank.ru
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 02 1998 - 18:34:59 CST