Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Archiving Theory Question
Thanks Jonathan!
In article <38d29f05.18665609_at_netnews.worldnet.att.net>,
jonathan_at_gennick.com wrote:
> On Mon, 13 Mar 2000 22:59:42 GMT, Satar <satar_at_my-deja.com>
> wrote:
>
> >This is an embarrasing question for an Oracle DBA with 3 years of
> >experience to ask, but here it goes:
>
> Not to worry. I ask lots of questions that fall into this
> category.
>
> >For example, Lets say I'm currently on log sequence 111 on my online
> >redo logs. Let's say that I then shutdown the database. Does my
online
> >redo log 111 get archived?
>
> No. Your redo log file gets closed when you shutdown the
> database, that's all.
>
> >Or does it only get archived during a log
> >switch?
>
> It doesn't really get archived _during_ a log switch either.
> It will get archived after a log switch. How long after
> depends on whether or not you have the archiver process
> running, and on how well the archiver process is keeping up.
>
> regards,
>
> Jonathan
>
> _____________________________________________________
> jonathan_at_gennick.com
> http://gennick.com
> Brighten the Corner Where You Are
>
>
-- Oracle DBA/UNIX System Admin "Opinions are the result of the voices in my head only, and do not reflect my employer or Oracle Corporation." Sent via Deja.com http://www.deja.com/ Before you buy.Received on Wed Mar 15 2000 - 00:00:00 CST