RE: DBPITR Question

  • From: <rajendra.pande@xxxxxxx>
  • To: <mohammed.bhatti1@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Nov 2014 10:44:01 -0500

First one for sure. You may not have to rebuild the DR – just replace the files 
that will undergo PITR

 

Second I think is a good idea – but don’t believe you need to.

 

Regards 

 

- Raj Pande

UBS AG 

  Global Service Delivery (GSDM) 

  1000 Lincoln Harbor, floor 10, Weehawken NJ 07086

  +1 201 352 0441  (19 422 0441)

 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Mohammed Bhatti
Sent: Thursday, November 20, 2014 10:39 AM
To: oracle-l-freelists
Subject: DBPITR Question

 

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

Please visit our website at 
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html 
for important disclosures and information about our e-mail 
policies. For your protection, please do not transmit orders 
or instructions by e-mail or include account numbers, Social 
Security numbers, credit card numbers, passwords, or other 
personal information.

Other related posts: