Re: archive redo logfile

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Sep 2003 06:19:56 -0700
Message-ID: <2687bb95.0309100519.5e65bd47@posting.google.com>

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

Lee, the answer depends on if your database is in archivelog mode (which you state) and if you have previously turned on automatic archiving.

You turn on auto archieving either by
alter system archive log start and/or setting init.ora parameter log_archive_start = true
before starting the instance

By the way you could just go to the archive log destination directory and look a few seconds after issuing the command and see if the archived log is there.

HTH -- Mark D Powell -- Received on Wed Sep 10 2003 - 08:19:56 CDT