RE: Urgent Help - advise
- From: Muqthar Ahmed <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 23 Jul 2004 10:12:23 -0400
Sanjay,
After fixing hardware on Production server, I think you can create Physical
Standby Database and later switch it as Primary.
Can anyone comment on this......what would you do if you get into such
situation?
Thanks
Muqthar
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sanjay Mishra
Sent: Thursday, July 22, 2004 10:00 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Urgent Help - advise
Thanks Riyaz. I had already switchover to standby as production cannot be
stopped. THe old primary is still down as sysadmin are working with HP support
for the hardware support
Thanks
sanjay
Riyaj Shamsudeen <rshamsud@xxxxxxxxxxxx> wrote:
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sanjay Mishra
Sent: Thursday, July 22, 2004 1:27 PM
To: oracle-l@xxxxxxxxxxxxx
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
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
-- Attached file included as plaintext by Ecartis --
-- Desc: Signature
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.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
* * * * * * * *
*
The information contained in this E-mail message is privileged, confidential,
and may be protected from disclosure; please be aware that any other use,
printing,copying,
disclosure or dissemination of this communication may be subject to legal
restriction or sanction. If you think that you have received this E-mail
message in error, please
reply to the sender and delete it from your computer. Thank you.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
