Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN

Re: RMAN

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Sun, 24 Mar 2002 09:15:45 +1100
Message-ID: <a7ius7$rhg$1@lust.ihug.co.nz>


Just so you get all manual'd out, have a look at the final 4 chapters in the backup and recovery book on my site. That might make it a bit clearer than the Oracle doco.

But I think your real issue is having to decide what connect strings to supply. In the example you quote, the target database is not being specified: that means it has to be the one referenced by the ORACLE_SID environment variable. The catalog database, however, is being specified... and in this case, it is called "rcat". It's being referenced as a tnsnames alias, so there needs to be a tnsnames.ora (or other naming method) configured so that Oracle can resolve that name into the host, and port number, of the Listener that's also been configured to listen out for connections to that database.

So you need to make sure your Listener is working on behalf of both the target and catalog databases; that ORACLE_SID is correctly set to the SID of the target; that tnsnames.ora is configured properly to enable connections to the catalog database. (Or you could do it the other way round: set ORACLE_SID to the catalog, and use tnsnames to specify the target. You could even use tnsnames aliases for both the target and the catalog).

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"J.T. Brooks" <brooks_jt1_at_hotmail.com> wrote in message
news:fsnp9ugs67km50qrpdg9tl2kker4hsds3c_at_4ax.com...

> Am trying to follow the rman document on metalink and got as far as
> logging in as "connect target / rcvcat rman/rman_at_rcat" in rman80. I
> have created all the tables/privilages but don't understand the above.
> Database created in is "flow". Nothing I've tried connects to register
> the database.
>
> Any help appreciated
Received on Sat Mar 23 2002 - 16:15:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US