Re: Turning ARCHIVELOGMODE off and on

Yes, it is possible and seems to be the only soln for a very big Load other than adding many bigger redolog files to handle the huge volume of data without facing 'cannot allocate log' errors and database hangups and filled LOG_ARCHIVE_DEST problems etc..

I would take One more Hotbackup after putting the Database in Archivelog mode in the final step..

-Thiru

mohotta_at_my-deja.com wrote:

> 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 Fri Jul 23 1999 - 14:52:07 CDT