Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: archive logs
Just another question regarding archive logs
If I do a full backup of the database each night, after shutting it down first. Do I need to keep backups of the archive logs before yesterdays?
If a disaster were to happen during the day, surely the only archive logs needed would be from today?
Am I correct in my assumtion or am I missing something?
Jason
Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:96tf1u$pen$1_at_soap.pipex.net...
> You can recover from your last good backup until the first gap in your
> archived redo logs. This means
>
> either doing a recover until time, or doing recover until cancel - if you
> don't know how many archived logs you actually have.
>
> This is documented in the documentation under the title Incomplete
Recovery.
> I strongly suggest if you actually need to do this that you read carefully
> through this documentation. As Howard Rogers is fond of saying this is
> exactly the reason for the introduction for 5 way multiplexing of archived
> logs in 8i. A good DBA *should* never lose an archived redo log. (I bet we
> all have though <g>).
>
> HTH
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "James" <gatergater2_at_hotmail.com> wrote in message
> news:FUdk6.14461$1%2.814614_at_sjc-read.news.verio.net...
> > if i lose some archive logs what can i restore back too?
> > hypoteticly if i have 20 files and lose 15 file would i only be able to
> > restore up to the 14 file? how does this work?
> >
> >
> >
>
>
Received on Tue Feb 20 2001 - 13:47:54 CST