Re: DBPITR Question

Doing either of these is not necessary. If you have flashback database enabled on your standby, just make sure you have enough retention to flashback to before the resetlogs.

If you don't have flashback database enabled, simply create a guaranteed restore point on the standby before the resetlogs.

When you are done with the PITR on the primary, flashback the standby to before the resetlogs and enable recovery as normal.

Disabling cluster_database will not make any difference in either the primary or standby database.

Seth Miller

On Thu, Nov 20, 2014 at 9:39 AM, Mohammed Bhatti <mohammed.bhatti1_at_gmail.com
> wrote:

> Hi All,
>
> 2-node 11gR2 RAC on ASM in a Data Guard environment on RHEL 5.10
>
> This is a test database and I want to do a DBPITR. Before I proceed I
> have a couple of questions:
>
> 1. Should I disable DG and plan on re-building the DG environment after
> the restore?
> 2. Should I alter system set cluster_database=false scope=spfile sid='*'
> before starting the DBPITR?
>
> Thanks
>
> --
> mohammed
>

--
http://www.freelists.org/webpage/oracle-l