Standby database in 8i

From: Cyril Thankappan <cyril_thank_at_rediffmail.com>
Date: 20 Dec 2000 09:51:14 -0000
Message-Id: <10716.124994@fatcity.com>

Hi!

 To our grief we r finding that standby database  in 8i (RFS!) is not as romantic as suggested by  the manual.

 We have found that after sometime
 the RFS gives 'some' error (can somebody help please!)  and we find v$archive_dest.error has
 value ORA-3113 while tnsping etc works..

 and after that the RFS doesn't work at all!  it was stuck at sequence no 97 and now
 it is stuck at sequence no 103,
 logs 98-102 r not that on standby host...

 can some one please help!

 Thanks

---

Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com

Participate in crazy auctions at http://auctions.rediff.com/auctions/

---

 From: RanganathK_at_lgcommerznow.com
 Date: Wed, 20 Dec 2000 15:28:55 +0530
 Subject: Stored procedure query

Dear DBA Gurus,

I have a table by name prod_master whose structure as is below:

 MODEL_CD NOT NULL      VARCHAR2(20)
 CAT_LEVEL      NUMBER(3)
 PARENT             VARCHAR2(20)
 PROD_NAME   VARCHAR2(80)
 MAIN_CAT         VARCHAR2(20)

 PROD_DESC VARCHAR2(1000) Received on Wed Dec 20 2000 - 03:51:14 CST