Re: logfile questions

Hello,

If your archivelog mode is active, you
need to save log files before reusing
them.
So, multi files permit to begin the
backup sooner.
If your backup is made on disk, you
don't have any probllem, but on tape
..

If you are not in archive log mode,
it's not important, but it's time to
think at security.

Rollback segment are used to store old
data until commit phase.
Log files is used to restart the
database after a crash.

Regards

-- 
REIP Jean-Claude
jacari.consultant_at_skynet.be

L. Tseng <lesliet_at_u.washington.edu> a
écrit dans l'article
<609812$p62$1_at_nntp6.u.washington.edu>...



> Hi, Oracle experts,

>  

> Help with the following questions

 will be very appreciated.


>  

> 1. What's the criteria when decieding

 how big/many logfile should be?


> 2. Having one big logfile (for

 example, 100MB) or having 4 logfiles


>    with 25MB each; which one is

 recommended?


> 3. What's the difference between

 logfile and rollback segment?


>  

> Thank you in advance.

>  

> Leslie

> ~

>