Re: 8i "until change is before resetlogs" error
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 15 Oct 2009 09:16:56 -0700 (PDT)
Message-ID: <8256195f-11dd-422e-ac50-451b287c8a69_at_t2g2000yqn.googlegroups.com>
On Oct 13, 1:43 pm, Kasparov <ganesh.tam..._at_gmail.com> wrote:
> My point is I am not able to restore from "latest" backup because of
> the "alter database open resetlogs" done with earlier restore (this
> caused the issue with resetlogs_change# and next_change#). And I want
> to know to avoid such situation what should be done. Because whatever
> I have found on Net seems to tell me that my procedure is correct. So
> I dont understand why I cant restore from my latest backup.
Date: Thu, 15 Oct 2009 09:16:56 -0700 (PDT)
Message-ID: <8256195f-11dd-422e-ac50-451b287c8a69_at_t2g2000yqn.googlegroups.com>
On Oct 13, 1:43 pm, Kasparov <ganesh.tam..._at_gmail.com> wrote:
> My point is I am not able to restore from "latest" backup because of
> the "alter database open resetlogs" done with earlier restore (this
> caused the issue with resetlogs_change# and next_change#). And I want
> to know to avoid such situation what should be done. Because whatever
> I have found on Net seems to tell me that my procedure is correct. So
> I dont understand why I cant restore from my latest backup.
I am pretty sure the "Recovering a Pre-RESETLOGS Backup" mentioned in my response tells you how to handle recovering through a reset logs.
- Mark D Powell --