Re: rman problem revisted

I would suggest that you create a recovery catalog in a completely separtate database and create the rman user for this database. Remove the rman user from the other 2. Then run the catrman.sql on the new database as the rman user. Having to rman users and 2 recovery catalogs is probably not good. I would advise that you do a cold backup of the recovery catalog database. You can't backup the recovery catalog database with the same recovery catalog.

HTH,
Ruth
----- Original Message -----
From: ramon de los reyes <amity308_at_bcd.weblinq.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, July 13, 2000 5:54 AM
Subject: rman problem revisted

> What I have is one box with 2 database running .
> I have rman user in database test1 and another rman user in database
test2.
> I have run both catrman.sql in test1 and in test2.
>
> My purpose is that database test1 one will store the recovery catalog of
> test2 and vice versa.
>
> what I have tried is :
>
> 1. Connect rman locally:
>
> export ORACLE_SID=test2
>
> rman rcvcat rman/<password>@test1
>
> 2. Connect rman remotely:
>
> rman target rman/<password>@test2 rcvcat rman/<password>@test1
>
> The result is the same .... segment fault (core dump).
>
> The core dump has a size of 12MB....
>
> But when I run rman with nocatalog it runs.... I really don't have an idea
> why...
> We always shutdown the database and today it gives me the same error.
>
> finally, how do i check the hard/soft cpu and process parameters for my
> oracle users???
>
> Clarification : Could I just create another separate database and store
the
> recovery catalog of both database i.e. test1 and test2????
>
> Again thank you all
>
> Ramon
>
>
>
>
> --
> Author: ramon de los reyes
> INET: amity308_at_bcd.weblinq.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Jul 14 2000 - 09:44:59 CDT