Re: 8.0.4 Server Transaction Logging???

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 27 May 1999 22:47:10 +0200
Message-ID: <927837933.9459.0.pluto.d4ee154e@news.demon.nl>

This already happens automatically. It is called redo log. There is a finite number of redolog files online. Once they have all been written and you are not running the database in archivelog, the oldest redolog files are overwritten. Please readup on redolog and backup and recovery and make sure your database is running in archive log.

Hth,
Sybrand Bakker, oracle DBA

c_p_t_at_my-deja.com wrote in message <7ik01b$c1$1_at_nnrp1.deja.com>...
>I am using 8.0.4 Workgroup Server, and would like to
>log all SQL requests for a certain duration of time.
>The goal is to be able to have full recovery in case
>of disk loss.
>
>I know how to do a full database backup/restore, I need
>the procedure above for 'in-between-backups' data. Could
>anyone pass some hints? I couldn't find such in the 8.0.4
>Documentation.
>
>Thanks,
>cpt
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Thu May 27 1999 - 15:47:10 CDT