RMAN(10gR2) connection Question

From: <dominica_at_gmail.com>
Date: Mon, 16 Jul 2007 21:06:43 -0000
Message-ID: <1184620003.893344.149390@g37g2000prf.googlegroups.com>

Hi All,

 Sorry I have a "dumb" RMAN question.
I am very confused.

I have db100 (primary) and db100dg(standby). I am not using catalog db. I am using nocatalog for now. (later on, I might change).

I am trying to do backup on db100dg side. I login to the standby side and take the standby out of recovery mode and
then do backup , it is fine.
And I in my last step, I want to backup the controlfile from the primary side and I want to login to primary side. ORACLE_SID=db100dg(it is set correctly).

I try to do the following command:

rman target rman/rman-password_at_db100_primary_db nocatalog;

Recovery Manager: Release 10.2.0.3.0 - Production on Mon Jul 16 15:49:53 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571:

---

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

---

RMAN-00571:

---

RMAN-00554: initialization of internal recovery manager package failed RMAN-04005: error from target database:
ORA-01031: insufficient privileges

I have created a "RMAN" user on the primary side, ( I grant dba , rman_catalog_owner permission to RMAN user ) and give the password: "rman-password" on the primary side.

The reason I try to connect from the db100dg side, is I want to connect to the primary side and then I could create a controlfile
for backup.

Any idea/suggestions are welcome.
Sorry, I am just very very confused.

Thanks,

Dominica Received on Mon Jul 16 2007 - 16:06:43 CDT