Re: DBA - Archivelog suspend

Sameer,

It is possible to do this, however with some restrictions:

1. You need to issue the command "alter system archive log STOP;"
2. Execute your batch run.

RESTRICTIONS:

1. Stopping the auto archiver is what theabove command does, however it does not change the mode of operation of the database.
2. To resolve the above issue of mode a work around is to create a very large redo log file(s) just before you start the job, and then take them offline and drop after the job finishes. This can work however note, in case you have to recover with a roll forward, you will need to skip the scns stored in this 'temp' log. You can determine the scns in this file(s) by selecting from the fixed table "X$KCCLE"

Hope this helps you.

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Sr. Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 


In article <4jqd4c$41v_at_news.nyc.pipeline.com>, utrankar_at_nyc.pipeline.com (Sameer Utrankar) writes:


>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.

>