Re: cold backup over weekend in archive mode?

No problem doing what you propose (having archives gives the you the *option* of doing hot backups, but certainly doesn't make them mandatory).

The only possible problem (which only you can evaluate) is that potentially, in a worst case scenario, you are looking to have to restore a Sunday backup, and apply archives from Monday, Tuesday, Wednesday, Thursday and most of Friday if you had a failure of some sort last thing on Friday afternoon. In other words, you are looking at a comparitively long mean time to recover.

But if that isn't a major concern (it probably would be in a 24x7 shop), then go for it: cold backups are delightfully easy to do, and it certainly helps not having so much backup work to do each weeknight.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<susana73_at_hotmail.com> wrote in message news:8r01p3$el4$1_at_nnrp1.deja.com...


> Hi there,

>

> I am wondering if I can do a cold backup of the entire database only on

> weekend(Sat and Sun) and backup the archive logs daily?  Am I able to

> recover the database using the archives then?  Is it too risky to that?

>

> Thanks.

>

> Susan

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.