Re: RMAN(10gR2) connection Question

On Jul 16, 6:10 pm, "domin..._at_gmail.com" <domin..._at_gmail.com> wrote:
> On Jul 16, 2:55 pm, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > On Jul 16, 2:06 pm, "domin..._at_gmail.com" <domin..._at_gmail.com> wrote:
>
> > > 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
>
> > I don't really know, but I'll hazard a guess that you are using a
> > special standby database controlfile on the db100dg side and RMAN
> > isn't giving a helpful error about that. Perhaps you have to be able
> > to write to the controlfile to do this. I'm not sure I understand why
> > you don't just connect to the primary. Are they on the same machine?
> > Perhaps it is telling you you really don't have access to the
> > controlfile.
>
> > (I'm awaiting repairs to my standby storage, sighhhhh...)
>
> > jg
> > --
> > @home.com is bogus.http://www.jaedworks.com/shoebox/zumabot.html
>
> Hi Joel,
>
> Thanks for replying my "posting", you have been so helpful for last 8
> years(
> you always reply my posting.
>
> Actually I am trying to connect to the "primary db" from the standby-
> data-guard
> host server
> and somehow I got those error.
> I think I have the correct password.
>
> Or I need to "grant" more permission for that "RMAN"(oracle user), the
> one that I created.
>
> Dominica

The role required is recovery_catalog_owner, not rman_catalog_owner. Something to check...

HTH, Steve Received on Mon Jul 16 2007 - 17:16:53 CDT