| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent Help - advise
Hi Sanjay
Your question was not clear. So, I am assuming you are trying to convert the former primary to current standby, so that you can switch over later. If this assumption is correct, then the answer 'it depends'. If you have switched over to the standby database gracefully, then you can restore just those four tablespaces and recover the former primary and convert it to standby. Basic premise is that 1) all the redo generated from the primary was propagated to the standby db before the switch 2) Former primary did not generate any redo by itself after the switch and so former primary is essentially a backup of the current primary.
If this premise holds good, then you can restore those 4 tablespaces alone and recover them..
But, If you have kept the primary open after the switch, thereby generating redo or if you have used resetlogs to open the secondary (for some reason), then you must use the current primary (or its backup) to rebuild the standby database.
Let me know if I misunderstood your question..
HTH
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra
Sent: Thursday, July 22, 2004 1:27 PM
To: oracle-l_at_freelists.org
Subject: Urgent Help - advise
Hello everybody
I need the expert advice and direction to one of the following situation
I have Oracle 9i Rel 2 with physical sstandby server. yesterday I lost one of the drive and so I switchover to standby server yesterday. today I was informed that we cannot recover the drive which contain for tablespace and so what is the best method to recover this scenario. The database is 800G and so do I need to restore the whole databasse to recover it or still I can take use the old four tablespaces from backkup and recover it. thanks for your help
Sanjay
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
 |
 |