On Jul 16, 3:16 pm, Steve Howard <stevedhow..._at_gmail.com> wrote:
> 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
Thanks,
Steve,
I got it ..
it still does not work.
Received on Mon Jul 16 2007 - 17:19:14 CDT
