Re: archive redo logfile

From: Pete's <empete2000_at_yahoo.com>
Date: 10 Sep 2003 06:33:01 -0700
Message-ID: <6724a51f.0309100533.6b237793@posting.google.com>

Before the log switch perform the following:

select *
from v$log;

Check the data it returns, then issue your log switch and then re-issue the above statement. You could then got out to the filesystem and check to see if the archive made it there.

Pete's

Lee <gnt00011_at_partner1.nri.co.jp> wrote in message news:<3F5EDB8D.ED7D3BD3_at_partner1.nri.co.jp>...
> Hello
> i use command 'alter system switch logfile' to switch redo logfile,
> i want to know if the redo logfile was archived atomatically
> at the same time?
> (database is Oracle9i , archivelog mode)
>
> Thanks in advance
>
> Lee
Received on Wed Sep 10 2003 - 08:33:01 CDT