Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: multiplexing online redo logs

Re: multiplexing online redo logs

From: Alistair Thomson <thomson_alistair_at_no.spam.yahoo.co.uk>
Date: Wed, 4 Dec 2002 15:21:49 -0000
Message-ID: <asl6ie$aim$1$8302bc10@news.demon.co.uk>


Hi

Connect as system and try an

sql> alter system switch logfile;

then check

sql> select * from v$log;

Alistair

"Uwe" <uwe.embshoff_at_lit.lineas.de> wrote in message news:3e9b0c3d.0212040707.2667cf27_at_posting.google.com...
> Hello,
>
> I want to multiplex my online redo logs on different disk. I used the
> following command to create an additional member for each of my 3 redo
> log groups:
>
> ALTER DATABASE ADD LOGFILE MEMBER
> '/usr2/oracle/mnt2/oradata/ws93/redo01.log' TO GROUP 1;
>
> To me, this doesn't seem to be enough, because when I change some
> data, these files are not updated. Only the initial redo log files are
> updated. When I look into v$logfile, they are "invalid". How can I set
> them to valid?
>
> Thank you!!!
> Uwe
Received on Wed Dec 04 2002 - 09:21:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US