Re: switching logs

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 04 Aug 2003 23:37:23 +0200
Message-ID: <bdktiv0lr707njnef6vvu8lu3b19all5c2@4ax.com>

On Mon, 04 Aug 2003 07:36:56 GMT, "Francesco" <fmarchioniNIENTESPAM_at_libero.it> wrote:

>Hi all!
>I have found a dba faq explaining how to switch and recreate larger redo
>logs.
>That's it:
>
>``create logs 5-8
>``switch to log 5
>``drop logs 1-4
>
>now my question is: how to issue these commands? (I refer to these ``
>characters) via sql-plus ?
>or some other parameter files ?
>Thanks a lot
>Francesco
>
>

alter database add logfile group
alter system switch logfile
alter database drop logfile group

syntax descriptions in the sql reference manual

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Aug 04 2003 - 16:37:23 CDT