Re: Restoring from an old cold backup

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 26 Jun 2005 12:51:12 +0200
Message-ID: <42be889f$0$15604$ba620e4c@news.skynet.be>

"NotSoCleverNickName" <ennis_at_escape.ca> wrote in message news:1119556063.443635.215420_at_g14g2000cwa.googlegroups.com...
> Most of the examples of doing a database restore start off from a full
> cold or
> hot backup and then continue on with the archive logs and redo logs.
>
> What if I happen to loose a full backup, but I still have an older full
> backup?
> Can I still recover to the point of my last archive log?
>
> Assumine a senario like this:
> Cold_20050501
> ArhiveLog_100
> ArhiveLog_101
> ArhiveLog_102
> ...
> ArhiveLog_150
> Cold_20050508 <- Corrupt or non-existant after the crash
> ArhiveLog_151 (yes I know they should be backed up somewhere
> else, etc.
> ArhiveLog_152 humour me with this thought experiement)
> ...
> ArhiveLog_169
> *crash*
>
> Could I restore Cold_20050501 and then apply the ArchiveLog_100 through
> ArchiveLog_169, or the somehow tied to Cold_20050508?
>
> NSCNN
>

As long as you have all the archived log files since your older full backup, yes you can fully recover. However, it could take a while depending on the number of archived log files you have to restore from tape and apply to the db.

Matthias Received on Sun Jun 26 2005 - 05:51:12 CDT