Re: DBPITR Question
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: Mohammed Bhatti <mohammed.bhatti1@xxxxxxxxx>
- Date: Thu, 20 Nov 2014 11:07:37 -0600
Mohammed,
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@xxxxxxxxx
> 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
>
Other related posts:
