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 -> different ways of archiving current redo log

different ways of archiving current redo log

From: Prem K Mehrotra <premmehrotra_at_hotmail.com>
Date: 23 Mar 2004 10:48:47 -0800
Message-ID: <43441e77.0403231048.373be43d@posting.google.com>


I have seen different ways of archiving logs and want to clarify their usage:

  1. alter system switch logfile

Does this command really archives current redo log before switch, or it simply switches and archiving is done later in background (asynchronus manner)

2. alter system archive log current:
I will think this command will actually archive the current log and then only swtch to next log, i.e, archiving and next log are synchronus operations.

3. alter system archive log all:
This command will archive all filled redo logs but will not complete current log because it will not be full.

Thanks,

Prem Received on Tue Mar 23 2004 - 12:48:47 CST

Original text of this message

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