Re[1]: What not to do in a standby environment ?

From: Prem Khanna J <premj_at_rediffmail.com>
Date: 7 Dec 2004 14:57:14 -0000
Message-ID: <20041207145714.28091.qmail@webmail8.rediffmail.com>

Hi Carel , Tony , Niall & Scott ,
First, Thanx all for your replies.

Hi Carel :

Thanx for that TRUNCATE reminder and
about DATA GUARD in 8.1.7. I was really
not aware of it, thought it was from 9i.

Many thanx for the URL.Great help :)

Tony :

>>Its not really a don't do, but you
>>have to be aware that if you add a
>>new datafile to the production db,
>>then you must also manually add it
>>to the standby. Recovery stops until
>>the new datafile is added.

thanx for the corection !

Niall :

>>I wonder if renaming the database and
>>moving the archivelog destinations are
>>good ways to break the standby as well.

Changing the archive log dest never came to my mind. let me test that too.
Thanx Niall.

Scott :

>>http://www.emc.com/products/networking/srdf.jsp

Thanks a many Scott. You have let me know something really new today :)

I have to test all these in a couple of
days on oracle 8.1.7.4/Solaris 9.

I will sure,post , if there is any quite interesting.

Another Question:

---

How about OS patches/upgrades ?
OS patches/upgrades will not be a big
issue ... i feel ... not sure though !!
How about RDBMS patches/upgrades ????
Just rebuild the standby from scratch ?! Or is there any other workaround for it ?

Thanks & Regards,
Prem.

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

Received on Tue Dec 07 2004 - 08:57:33 CST