Re: archive logs

All things being well you are correct. However this strategy relies on a single point of failure. Last nights backup. If you don't have the backup, or you can't restore from it, then you're dead. Being paranoid what we do for our backup strategy is as follows.

1. Export the entire database every night. - this gives a logical backup for cases like hardware failure.
2. Backup the database every night
3. Don't delete archives for 4 days.

we also import the export to our DR site daily as well.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Jason Seeley" <me_at_127.0.0.1> wrote in message
news:bPzk6.328$02M1.7536853_at_news.xtra.co.nz...


> 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?

> > >

> > >

> > >

> >

> >

>

>