OraFAQ Forum: Backup & Recovery » RMAN-04006: error from auxiliary database

Home » RDBMS Server » Backup & Recovery » RMAN-04006: error from auxiliary database - URGENT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN-04006: error from auxiliary database - URGENT [message #74574]

Sun, 09 January 2005 19:35

arun
Messages: 67
Registered: January 2000

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

Report message to a moderator

Re: RMAN-04006: error from auxiliary database - URGENT [message #74580 is a reply to message #74574]

Mon, 10 January 2005 04:08

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

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.

Report message to a moderator

Re: RMAN-04006: error from auxiliary database - URGENT [message #118590 is a reply to message #74580]

Fri, 06 May 2005 04:47

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

Report message to a moderator

Re: RMAN-04006: error from auxiliary database - URGENT [message #336086 is a reply to message #74574]

Thu, 24 July 2008 13:57

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?

Report message to a moderator

Re: RMAN-04006: error from auxiliary database - URGENT [message #435103 is a reply to message #118590]

Mon, 14 December 2009 05:42

yempati
Messages: 1
Registered: December 2009

Junior Member

we have to connect from catalog DB i guess...how ever when tried to connect from catalog DB i was getting an error saying

RMAN-04006: error from auxiliary database: ORA-28547: connection to server failed, probable Oracle Net admin error

my listener and tnsnames.ora as follows

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC3))
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Practice)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = yempati)
(ORACLE_HOME = /oraeng/app/oracle/product/11.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = yempati)
(ORACLE_HOME = /oraeng/app/oracle/product/11.1.0)
(SID_NAME = yempati)
)
)

LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Practice)(PORT = 1321))
)
)
)

SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(SID_NAME = aux)
(ORACLE_HOME = /oraeng/app/oracle/product/11.1.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = yempati)
(ORACLE_HOME = /oraeng/app/oracle/product/11.1.0)
(SID_NAME = aux)
)
)

tnsnames.ora....

yempati =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.2.30)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = yempati)
)
)

auxll =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.2.30)(PORT = 1321))
)
(CONNECT_DATA =
(SERVICE_NAME = aux)
)
)

i am unable to connect to auxiliary DB.

Report message to a moderator

Re: RMAN-04006: error from auxiliary database - URGENT [message #435116 is a reply to message #435103]

Mon, 14 December 2009 06:45

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As you didn't tell us what you did (or better show us by copy and paste) we can't help.

Regards
Michel

Report message to a moderator

Previous Topic:	Data Recovery after SET UNUSED was performed on a column
Next Topic:	RMAN to disk - no tape handling - procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 01:05:57 CST 2024