You can only delete your archived logs AFTER you've copied them
off to tape....
unless you don't want to use them for recovery - which of course you do
otherwise you wouldn't be doing a ackup each night
Neil
noams_at_ncc.co.il wrote in message <7bjib6$4cf$1_at_nnrp1.dejanews.com>...
>I'm sorry if you get this twice (lousy connection)
>
>
>
>My database is working in archive mode (automatic)
>I have 4 online redo log groups each 10MB and my database holds heavy
>transactions.
>
>My problem is that the database is switching it's log file each minute!
>that means my database is producing 10MB of archive each minute.
>
>Although it makes alot of big transactions, I'm not sure that the reason
the
>log files are switched is becuase they are full (maybe cause of some other
>reason).
>
>Anyhows, if I DO have to keep up writing 10MB of archive each minute then
when
>can i delete them (I'm performing a hot backup each night 00:00)
>
>Thanks in advance
>
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 04 1999 - 08:25:05 CST
