Re: Turning ARCHIVELOGMODE off and on

Hi:

What you've suggested will definitely work. Make sure you always get a back up after turning archivelog mode back on, though.

Also, I'm going to assume that you are doing this with Oracle on NT (since you mentioned paradox). Check the site below for info on the Oracle/NT archiving bug (go to the availability -> backup and recovery page).

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

mohotta_at_my-deja.com wrote in message <7nafeh$t9e$1_at_nnrp1.deja.com>...
>We are gradually migrating database applications from Paradox to Oracle
>7.3. The trouble is: I don't want the database to be running in
>ARCHIVELOGMODE all the time. When I'm about to load a lot of data into
>Oracle, I don't want to create a lot of redo entries. Is it possible
>to:
>
>--Run in ARCHIVELOGMODE for a time;
>--Take the whole database off line;
>--Perform a full physical backup;
>--Bring the database back on line;
>--Alter the system to run with ARCHIVELOGMODE off;
>--Load my data;
>--Take the whole database off line again;
>--Perform another full physical backup;
>--Bring the database back on line, this time with ARCHIVELOGMODE on?
>
>I realize that any redo log files from the earlier ARCHIVELOGMODE period
>will be rendered useless. Even so, is this an OK idea?
>
>Alton Chinn
>SF Planning Dept
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sun Jul 25 1999 - 13:45:03 CDT