Re: multiplexing online redo logs

In article <asl6ie$aim$1$8302bc10_at_news.demon.co.uk>, "Alistair says...
>
>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
>
>

Perfectly true, but also unnecessary. All that the status of INVALID means is that the file is either inaccessible OR that Oracle has not attempted to access it yet. While switching log files with an ALTER SYSTEM command will clear this status, so will normal operation of the database causing log switches to take place. All you really get by using the ALTER SYSTEM command is a warm fuzzy feeling inside. :)

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Wed Dec 04 2002 - 10:29:13 CST