On Thu, Oct 29, 2009 at 5:13 PM, dx k9 <bitsandbyte...@hotmail.com> wrote:
> Hi all - > > I'm trying to do a PITR and I've noticed that every time I try it, it ups > the number it's looking for by one. > What's in your recovery.conf? > > 00000001.history > 00000002.history > . > . > 00000008.history > > For example one of my transaction log files name is > 0000000100000218000000C1 > > Instead of looking for 0000000100000218000000C1, it replaces the first 1, > with a 2 or > 0000000200000218000000C1, I'm all the way up to 8 now. How do I tell it to > look for 1 or > 0000000100000218000000C1 again. > > Every time your database opens, it comes onto a new timeline. I don't *believe* you can go back to an older timeline once you've opened the database for operation. --Scott
