Home » RDBMS Server » Backup & Recovery » RMAN-04006: error from auxiliary database - URGENT
RMAN-04006: error from auxiliary database - URGENT [message #74574] Sun, 09 January 2005 19:35 Go to next message
arun
Messages: 61
Registered: February 2002
Member
Hello,

I'm trying to clone new database from existing database, and both on same server. I'm getting following error while I try to initiate the command as shown below. Kindly help me resolving this.

[[inftw6800cd2:IFDEVL11i:oracle]]$ rman target sys/**** CATALOG rman/****@devrman AUXILIARY sys/****@IFMOON;

Recovery Manager: Release 9.2.0.5.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: IFDEV11I (DBID=3906563803)
connected to recovery catalog database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
Re: RMAN-04006: error from auxiliary database - URGENT [message #74580 is a reply to message #74574 ] Mon, 10 January 2005 04:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 8719
Registered: March 2002
Senior Member
connection to targetDB is good.
connection to rmanDB is good.
connection to auxillaryDB is NOT good.

First make sure auxDB is in nomount stage and try dupication
later,
try recreating the passwordfile for aux.
Then
invoke a seperate session for testing.

$rman
connect target ../..
connect rcvcat ../..@rmandb
connect auxillary ../..@tnsforaux.

If your last step goes good, then you are all set.
Re: RMAN-04006: error from auxiliary database - URGENT [message #118590 is a reply to message #74580 ] Fri, 06 May 2005 04:47 Go to previous messageGo to next message
sharmahamu
Messages: 2
Registered: May 2005
Location: agra
Junior Member

try that
aux in momount stage
connect target 'sys/pass@service_target';
connect catalog 'user/pass@service_target';
connect auxiliary 'sys/pass'
target and auxiliary password is same
all these step done in auxiliary terminal
Re: RMAN-04006: error from auxiliary database - URGENT [message #336086 is a reply to message #74574 ] Thu, 24 July 2008 13:57 Go to previous message
teeroy65
Messages: 2
Registered: July 2008
Location: Terre Haute, IN
Junior Member
So both passwords much match. I am just now getting around to setting up our physical standby and I guess I forgot to create the password file the first time around back in April. Are there consequences if I reset the password on our primary so I can make them match?
Previous Topic:Upgrade Disaster Recovery Database to 9.2.0.8
Next Topic:RMAN Backup Strategy
Goto Forum:
  


Current Time: Fri Aug 29 17:37:56 CDT 2008

Total time taken to generate the page: 0.03696 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.