Re: DBA - Archivelog suspend

Sameer Utrankar wrote:
>
> I want to use Archivelog for Hot-backups as 7*24 is the requirement
> for application system. Heavy hitting nightly batch is likely to
> produce Tons of archivelogs and so I would like to suspend archive
> logging during the period of the batch run.
>
> If I have to stop and start the database in order to enable/disable
> archive logging, purpose of 7*24 operation is lost.
>
> Is there a way of enabling/disabling archive logging wihout
> shutdown/startup of database ?
> ----------
> utrankar_at_nyc.pipline.com (Sameer Utrankar)
> All of us can't be heros. Someone has to sit by the curb and clap as they go by.

There are statements ALTER DATABASE ARCHIVELOG/NOARCHIVELOG but they can be issued only when database is not open (mounted, not open), so I think you are running out of choices. Hope I'm wrong...

You may consider of deleting immeadiately these night-born offline redologs, but you should consider carefully restoring options, if something happens.

Timo Haatainen Received on Tue Apr 02 1996 - 00:00:00 CEST