Home » RDBMS Server » Backup & Recovery » RMAN parallelism error (9.2.0.2,xp)
RMAN parallelism error [message #296380] Sat, 26 January 2008 07:49 Go to next message
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?
Re: RMAN parallelism error [message #296387 is a reply to message #296380] Sat, 26 January 2008 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: RMAN parallelism error [message #296399 is a reply to message #296380] Sat, 26 January 2008 11:00 Go to previous messageGo to next message
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?
Re: RMAN parallelism error [message #296401 is a reply to message #296399] Sat, 26 January 2008 11:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: RMAN parallelism error [message #296402 is a reply to message #296380] Sat, 26 January 2008 11:41 Go to previous messageGo to next message
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.
Re: RMAN parallelism error [message #296422 is a reply to message #296402] Sat, 26 January 2008 21:16 Go to previous messageGo to next message
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.
Re: RMAN parallelism error [message #296504 is a reply to message #296380] Mon, 28 January 2008 00:34 Go to previous messageGo to next message
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?
Re: RMAN parallelism error [message #296608 is a reply to message #296504] Mon, 28 January 2008 06:45 Go to previous message
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.
Previous Topic: duplicate database weekly using rman
Next Topic: Clone only structure of 9i to 10g
Goto Forum:
  


Current Time: Wed May 15 12:07:50 CDT 2024