Xref: alice comp.databases.oracle.misc:30499
Path: alice!news-feed.fnsi.net!netnews.com!newshub.northeast.verio.net!iad-peer.news.verio.net!uunet!ffx.uu.net!in4.uu.net!news.mel.aone.net.au!newsfeed-in.aone.net.au!not-for-mail
From: Gregory Hudson <gmhudson@acslink.aone.net.au>
Newsgroups: comp.databases.oracle.misc
Subject: Problem with RMAN connecting to a replicating database
Date: Wed, 05 May 1999 20:48:34 +1000
Organization: Gregory Hudson
Lines: 36
Message-ID: <37302202.DEB0F922@acslink.aone.net.au>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.mel.aone.net.au 925901496 18561 203.12.188.120 (5 May 1999 10:51:36 GMT)
NNTP-Posting-Date: 5 May 1999 10:51:36 GMT
X-Mailer: Mozilla 4.05 [en] (Win95; I)

I am having a problem connecting Recovery Manager to a database that is
replicating and in archivelog mode.  This is Oracle8 on NT4/SP3.

The rman connection string works on noarchivelog non replicating
databases and is
c:\> rman80 target 'sys/password@ottr-prod' rcvcat
'rman/password@ottr-demo'

The response is

Recovery Manager: Release 8.0.4.0.0 - Production
RMAN-06005: connected to target database :PROD
RMAN-06008: connected to recovery catalog database
RMAN-00569:=========error message stack follows========
RMAN-00554:initilization of internal recovery manager package failed
RMAN-07001:Could not open channel default
RMAN-10008:Could not create channel context
RMAN-10024:Errror setting up for rpc polling
RMAN-10006:Error running sql statement: select distinct my.sid, sex
serial from
v$mystat my.x$ksuser sex where sex.sid = my.sid
RMAN-10002:ORACLE error:ORA-01455:converting column overflows interger
datatype

and then bails out to the C:\> prompt

I get a straight connection is connecting to other non replicating
databases.  Is this a known problem with replication.

Does anyone have a backup methodology for a live replicating database in
archivelog mode.

All suggestion gratefully accepted

Gregory Hudson

