thomas.hiller_at_warema.de (Thomas) wrote in message news:<6e366956.0110032330.32ef4b65_at_posting.google.com>...
> Hello
>
> Is it possible to switch the archival mode on or off without closing the database ?
>
> Oracle Version: 7.3.4
>
> regards
> Thomas
You can do an alter system noarchivelog. Just remember, an alter
system command is only in effect for the life of the instance. Also be
aware if you turn off achiving and at some point turn it on again,
make sure you have taken a backup of the database or you will have
gaps in your archive log sequence numbers (preventing recovery).
Received on Thu Oct 04 2001 - 12:07:35 CDT
