Home » RDBMS Server » Backup & Recovery » multiple channels in RMAN (11g R1 )
multiple channels in RMAN [message #553453] Fri, 04 May 2012 11:23 Go to next message
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.
Re: multiple channels in RMAN [message #553506 is a reply to message #553453] Sat, 05 May 2012 15:37 Go to previous messageGo to next message
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
Re: multiple channels in RMAN [message #553638 is a reply to message #553506] Mon, 07 May 2012 07:42 Go to previous messageGo to next message
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.. ??
Re: multiple channels in RMAN [message #553795 is a reply to message #553638] Tue, 08 May 2012 09:36 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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>
icon6.gif  Re: multiple channels in RMAN [message #553963 is a reply to message #553943] Wed, 09 May 2012 07:59 Go to previous message
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:
  


Current Time: Thu Mar 28 14:43:21 CDT 2024