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

This message: [ Message body ]
Next message: Deepa balu via OracleMonster.com: "How to add a deleted datafile again"
Previous message: Mark A: "Re: Db2, Oracle, SQL Server"
In reply to: Steve: "Re: How To Change Log Switch Sequence?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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