Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: multiplexing online redo logs
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