Re: Help: restore a table to different point in the past
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 23 Apr 2016 05:03:11 +0000 (UTC)
Message-ID: <pan.2016.04.23.05.03.11_at_gmail.com>
Date: Sat, 23 Apr 2016 05:03:11 +0000 (UTC)
Message-ID: <pan.2016.04.23.05.03.11_at_gmail.com>
On Fri, 22 Apr 2016 06:18:33 -0700, dshproperty wrote:
> I tried to create a standby database from the old backup without
> connecting to the live database, hoping that i can do a incomplete
> recover and open read only, then recover to next time. The standby
> database creation was successful, but i cannot open it for reading, it
> complains the system file is not from old enough backup and needs more
> recover.
Why would you do a standby DB? You can do duplicate DB from a backup, without connection to the original. You can also skip unnecessary tablespaces.
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Sat Apr 23 2016 - 07:03:11 CEST