Re: RMAN register database problem ...

When you issue a connect target you don't have to have the SID set if you issue
connect target catalog_user/password_at_target_database.domain

Where the catalog user has execute catalog role.

Ruth
----- Original Message -----
From: Janardhana Babu <jbdonga_at_ucdavis.edu> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, April 28, 2000 7:14 PM
Subject: RE: RMAN register database problem ...

> Deepak,
>
> Thanks a lot. This works and I could register the DB. I still have some
> doubt left. Should I always switch to the target database(by . oraenv or
> export ORACLE_SID=target) to connect to both the databases in order to
> issue RMAN commands? For eg. to resync the database, Can't I get into rcat
> database and issue the command? In other words, should I always switch to
> target database to issue any RMAN commands?
>
> Appreciate a reply.
>
> Thanks,
> -- Janardhana Babu
>
> At 12:29 PM 4/28/00 -0800, Thapliyal, Deepak wrote:
> >JB,
> >
> >try this ..
> >
> >$ export ORACLE_SID=<target>
> >$ rman target / catalog rman/rman_at_fis_test_rcat
> >RMAN> register database
> >
> >lemme know if you are still facing the same prob
> >
> >deepAk
> >
> >-----Original Message-----
> >Sent: Friday, April 28, 2000 12:07 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Dear list members,
> >
> >I have created a catalog database name : rcat, Connect string:
> >fis_test_rcat.
> >The test database Name : rtest, Connect String: fis_test_rtest.
> >Both are Oracle 8.1.5 databases(64 bit) residing on the same box(HP-UX
> >11.0).
> >
> >I have created user rman/rman in "rcat" database with default tablespace
> >rcvcat_ts and granted recovery_catalog_owner to rman, also granted
connect,
> >resource to rman.
> >
> >I have created recovery catalog as follows:
> >$ rman (rman log=create_rman.log is not working, it simply hangs)
> >RMAN> connect catalog rman/rman_at_fis_test_rcat
> >RMAN> create catalog tablespace rcvcat_ts;
> >
> >Now, I need to register "rtest" database in "rcat".
> >When I issue the command suggested in the manual:
> >$ rman target / catalog rman/rman_at_fis_test_rcat , I get the following
> >messages.
> >RMAN-06005 Connected to target database: RCAT(DBID: 166860994)
> >RMAN-06008 Connected to recovery catalog database.
> >RMAN>
> >
> >My target database is RTEST and not RCAT. The above stmt at RMAN-06005
says
> >my target database is RCAT. I tried many ways to connect both target
> >database and catalog database inorder to register the target database
> >"RTEST" in catalog database "RCAT". But none of the stmts are connecting
to
> >the target database.
> >
> >How can I register the target database "RTEST" in catalog database
"RCAT"?
> >Any help is appreciated.
> >
> >Thanks,
> >-- Janardhana Babu
> >
> >--
> >Author: Janardhana Babu
> > INET: jbdonga_at_ucdavis.edu
> >
> >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).
> >
> >
> >--
> >Author: Janardhana Babu
> > INET: jbdonga_at_ucdavis.edu
> >
> >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).
> >--
> >Author: Thapliyal, Deepak
> > INET: DThapliyal_at_ea.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).
>
> --
> Author: Janardhana Babu
> INET: jbdonga_at_ucdavis.edu
>
> 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
Received on Mon May 01 2000 - 07:01:59 CDT