configuring RMAN

[BeefStu]

I am in the process of setting up RMAN. I have one DB, called PRI where
I intend to put my target and catalog in my PRI DB.

What I don't understand is why I need to create a orapwd file? Can't I
just do something like this?

rman target sys/sys@PRI catalog rman/rman@PRI

I guess I have a few questions:

1) When does the orapwd file come into play? What entry needs to
be placed into it


2) What is the default directory where the orapwd should be created?

3) is target the really the "DB" am backing up? If not, how do you specify
the DB to backed up

4) Lastly lets say I have another DB called "sec" on another machine? would this be the syntax to use to connect

rman target sys/sys@SEC catalog rman/rman@PRI

As mentioned above, why do I need a orapwd and when will it get used?

Thanks to all who answer this post?

does yor
ORACLE_SID need to be set correctly? Ie lets say I have another DB called
"sec" on the same machine as PRI what command would I use to back that
up? and would anything need to go into the orapwd file, if so what?

[vnktummala]

1. password file required to connect as a DBA user from remote machines. You need to create the password file with SYS / password and set the value for ENTRIES =
2. $ORACLE_HOME/dbs in UNIX and $ORACLE_HOME\database in windows

3. Yes, target is the DB that you want to backup

4. Correct

You need to use the correct service names when connecting to RMAN.

This helps you to understand more about orapwd utility.

http://www.oracleutilities.com/OSUtil/orapwd.html

Thanks,

[mahajanakhil198]

4. Correct

If PRI is the DB that he wants to back up and SEC database has to be the catalog database, then the syntax is not correct. In this case, the connect string should be as follows if PRI identfies the service name of Primary database and SEC of seconday database:

rman target sys/sys@PRI catalog rman/rman@SEC

[vnktummala]

I have one DB, called PRI where
I intend to put my target and catalog in my PRI DB.

4) Lastly lets say I have another DB called "sec" on another machine? would this be the syntax to use to connect

rman target sys/sys@SEC catalog rman/rman@PRI

My understanding about question 4 is, the poster have a db called SEC and want to backup that DB.

Thanks,

[BeefStu]

Now that you guys completely confused me lets try this again.

As mentioned I have a DB called pri, which is my target DB and where
I intend to put my catalog. In addition, all my access to the catalog will
be done with the user RMAN/RMAN.

For this situation, it sounds like I DONT need a password file for this situation
am I correct?

This would be the command line

# backup PRI DB and access the catalog with rman user in pri. within pri
# rman user has sysdba privs?

rman target sys/sys@PRI catalog rman/rman@PRI

My second situation is that I want to backup a DB called "sec", which
is on a different machine as "pri" (catalog is in pri).

For this situation, it sounds like I need an orapwd file to access the catalog
in "pri" from the user "rman"

# backup sec DB and access the catalog with rman user in pri. This command
# will use the user "rman" in the orapwd file to access the catalog.

rman target sys/sys@SEC catalog rman/rman@PRI

The issue as I see it is that we can't get the privs for "rman" since we are
using a different DB "sec" to backup, hence the need for the orapwd file.


Do I have it right? Thanks for everybody's help.