OraFAQ Forum: Backup & Recovery » multiple channels in RMAN

Home » RDBMS Server » Backup & Recovery » multiple channels in RMAN (11g R1 )

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

multiple channels in RMAN [message #553453]

Fri, 04 May 2012 11:23

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hello Expert,

I am working to configure on both the nodes of RAC server, but getting error invalid username and password even the password is right.. And the remote_login_passwordfile is set to exclusive.


RMAN> run {
2> ALLOCATE CHANNEL ch1 DEVICE TYPE DISK CONNECT 'sys/sys@node1';
3>  ALLOCATE CHANNEL ch2 DEVICE TYPE DISK CONNECT 'sys/sys@node2';
4> backup datafile 1;
5> }

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel ch1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01017: invalid username/password; logon denied

and when trying to connect with sqlplus i'm getting below error


CCLCLMP1 /oravl01/oracle/11.1.0.7/network/admin > sqlplus sys/sys@node2 as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Fri May 4 12:11:59 2012

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

ERROR:
ORA-24313: user already authenticated

please suggest.

Report message to a moderator

Re: multiple channels in RMAN [message #553506 is a reply to message #553453]

Sat, 05 May 2012 15:37

BeefStu
Messages: 208
Registered: October 2011

Senior Member

With your RMAN command not sure why your trying to connect. It would make a lot more sense to have a shared disk group like +FRA, which is accessible from all nodes than you can do somehting like this:


RMAN> CONFIGURE CHANNEL 0 DEVICE TYPE DISK FORMAT   '+FRA';
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   '+FRA';
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT   '+FRA';

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

As for your sqlplus you should really consider setting up scan nodes. The purpose of this is that Oralce will do load balancing for you automatically and you never have to worry, which node your logging into.

You may want to conisder reading up a bit more on RAC to take advantage of this features.

Hope that points you in the right direction

Report message to a moderator

Re: multiple channels in RMAN [message #553638 is a reply to message #553506]

Mon, 07 May 2012 07:42

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Hi,

I am trying to allocate channel on both the nodes but not getting why it is prompting to invalid username and password when password is right.. ??

Report message to a moderator

Re: multiple channels in RMAN [message #553795 is a reply to message #553638]

Tue, 08 May 2012 09:36

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

You only need to connect to one of the nodes to do a database/file backup.
But if you want to spread the work across different instances:

ALLOCATE CHANNEL ch1 DEVICE TYPE DISK CONNECT '@node1';
ALLOCATE CHANNEL ch2 DEVICE TYPE DISK CONNECT '@node2';

[Updated on: Tue, 08 May 2012 10:59] by Moderator

Report message to a moderator

Re: multiple channels in RMAN [message #553943 is a reply to message #553795]

Wed, 09 May 2012 07:01

dba_7722
Messages: 197
Registered: August 2010
Location: Delhi

Senior Member

Thanks. Yes i'm trying to spread workload across the nodes. But still getting the error.


RMAN> run {
2> allocate channel ch1 DEVICE TYPE DISK CONNECT 'node1';
3> allocate channel ch2 DEVICE TYPE DISK CONNECT 'node2';
4> crosscheck archivelog all;
5> }

using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel ch1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01005: null password given; logon denied

RMAN> run {
2> allocate channel ch1 DEVICE TYPE DISK CONNECT '@node1';
3> allocate channel ch2 DEVICE TYPE DISK CONNECT '@node2';
4> crosscheck archivelog all;
5> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12001: could not open channel ch1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-01031: insufficient privileges

RMAN>

Report message to a moderator

Re: multiple channels in RMAN [message #553963 is a reply to message #553943]

Wed, 09 May 2012 07:59

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Copy and paste your full RMAN session, starting the with the rman command.
Mad

[Updated on: Wed, 09 May 2012 08:01]

Report message to a moderator

Previous Topic:	dB becoming unstable
Next Topic:	ORA-01113: file 5 needs media recovery

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:28:58 CST 2025