OraFAQ Forum: Backup & Recovery » RMAN parallelism error

Home » RDBMS Server » Backup & Recovery » RMAN parallelism error (9.2.0.2,xp)

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

RMAN parallelism error [message #296380]

Sat, 26 January 2008 07:49

varu123
Messages: 754
Registered: October 2007

Senior Member

RMAN> backup
2> (datafile 1,2,3
3> filesperset=1
4> channel ora_disk_1)
5> (archivelog from sequence 100 until sequence 102 thread 1
6> filesperset=3
7> channel ora_disk_3);

Starting backup at 26-JAN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=13 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=14 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/26/2008 18:55:47
RMAN-06033: channel ora_disk_1 not allocated

Isn't the channel allocated?

Report message to a moderator

Re: RMAN parallelism error [message #296387 is a reply to message #296380]

Sat, 26 January 2008 08:56

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

Senior Member
Account Moderator

Quote:

RMAN-06033: channel string not allocated
Cause: An rman command requests a specific channel, but the requested channel has not been allocated.
Action: ALLOCATE the channel, or correct the channel identifier.

Regards
Michel

Report message to a moderator

Re: RMAN parallelism error [message #296399 is a reply to message #296380]

Sat, 26 January 2008 11:00

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

starting backup at 26-JAN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=12 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=13 devtype=DISK
allocated channel: ORA_DISK_3

What does these messages indicate then?
Ain't channels allocated?

Report message to a moderator

Re: RMAN parallelism error [message #296401 is a reply to message #296399]

Sat, 26 January 2008 11:16

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

Senior Member
Account Moderator

Or does this mean it will use allocated channel X if it is allocated?

Post the WHOLE session AND configurated parameters.

Regards
Michel

Report message to a moderator

Re: RMAN parallelism error [message #296402 is a reply to message #296380]

Sat, 26 January 2008 11:41

varu123
Messages: 754
Registered: October 2007

Senior Member

RMAN>SHOW DEVICE TYPE;
RMAN configuration parameters are:
CONFIGURE DEVICE TYPE DISK PARALLALISM 3;

In effect,rman should allocate 3 channels with default format.

Report message to a moderator

Re: RMAN parallelism error [message #296422 is a reply to message #296402]

Sat, 26 January 2008 21:16

ebrian
Messages: 2794
Registered: April 2006

Senior Member

varu123 wrote on Sat, 26 January 2008 12:41

RMAN>SHOW DEVICE TYPE;
RMAN configuration parameters are:
CONFIGURE DEVICE TYPE DISK PARALLALISM 3;

In effect,rman should allocate 3 channels with default format.

RMAN will only allocate 3 channels if you have set RMAN up to allocate channels automatically or if you have allocated channels manually. It appears that you haven't done either.

Report message to a moderator

Re: RMAN parallelism error [message #296504 is a reply to message #296380]

Mon, 28 January 2008 00:34

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

RMAN will only allocate 3 channels if you have set RMAN up to allocate channels automatically

CONFIGURE DEVICE TYPE DISK PARALLALISM 3;

What does this command set RMAN to then?

Report message to a moderator

Re: RMAN parallelism error [message #296608 is a reply to message #296504]

Mon, 28 January 2008 06:45

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You are correct. CONFIGURE DEVICE ... PARALLALISM 3 does allocate the channels as indicated in your output above, but it doesn't allocate the channels for you to attach to them directly. In order to specify and attach to the channels you should allocate 3 channels that you create and name.

Report message to a moderator

Previous Topic:	duplicate database weekly using rman
Next Topic:	Clone only structure of 9i to 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:41:56 CST 2024