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 -> Re: How To Change Log Switch Sequence?

Re: How To Change Log Switch Sequence?

From: Steve H <steven.hankin_at_citigroup.com>
Date: 8 Feb 2005 02:22:37 -0800
Message-ID: <1107858157.591417.207660@o13g2000cwo.googlegroups.com>


This is easy; they're used in the order they are created.

You can even do this if the database is online.

Use the 'alter system switch logfile' to ensure group #1 is not being used, then drop it and recreate it. Do the same for #2, #3, etc, until all groups have been recreated.

Because they have been recreated in sequence #1...#n, they will be used in that order. Received on Tue Feb 08 2005 - 04:22:37 CST

Original text of this message

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