OraFAQ Forum: Backup & Recovery » ERROR ALLOCATING DEVICE

Home » RDBMS Server » Backup & Recovery » ERROR ALLOCATING DEVICE

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

ERROR ALLOCATING DEVICE [message #167120]

Tue, 11 April 2006 07:50

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

Quote:

RMAN> SHOW ALL;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # defa
ult
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'c:\oracle\cold\rman1\backup_db_%d_S
_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;
CONFIGURE CHANNEL 5 DEVICE TYPE DISK MAXOPENFILES 5;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK FORMAT 'g:\cold\rman1\backup_db_%d_S_%s_P
_%p_T_%t' MAXPIECESIZE 1024 M;
CONFIGURE CHANNEL 6 DEVICE TYPE DISK FORMAT 'g:\cold\rman1\backup_db_%d_S_%s_P
_%p_T_%t' MAXPIECESIZE 1024 M;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA92\DATABASE\SNCFTESTDB1.ORA
'; # default

Quote:

RMAN> DELETE OBSOLETE;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 04/11/2006 17:41:27
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

I HAVE NOT USED TAPE DRIVE. HOW TO SOLVE THIS PROBLEM ??

[Updated on: Tue, 11 April 2006 07:51]

Report message to a moderator

Re: ERROR ALLOCATING DEVICE [message #167122 is a reply to message #167120]

Tue, 11 April 2006 08:00

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

Senior Member
Account Moderator

Obviously the problem is with the MML API.
Some problem with your TAPE or related Media layers.
Did you configure the API for the Media manager you are using ? Like veritas?

Report message to a moderator

Re: ERROR ALLOCATING DEVICE [message #167125 is a reply to message #167122]

Tue, 11 April 2006 08:04

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

tape drive is not attached in my system.. can u explain how to configure the API for the Media manager ???

Report message to a moderator

Re: ERROR ALLOCATING DEVICE [message #167127 is a reply to message #167125]

Tue, 11 April 2006 08:10

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

Senior Member
Account Moderator

>> tape drive is not attached in my system
Then where are backing up to?
Comment or remove all RMAN configurations that has SBT_TAPE.
>> can u explain how to configure the API for the Media manage
Refer to your Media manager documentation ( what ever you use veritas/legato...)

Report message to a moderator

Re: ERROR ALLOCATING DEVICE [message #167131 is a reply to message #167127]

Tue, 11 April 2006 08:16

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

how to remove all RMAN configurations that has SBT_TAPE ?.

i try to take backup in disk only. but i mistakenly i configured
both(disk and SBT_DISK).

[Updated on: Tue, 11 April 2006 08:28]

Report message to a moderator

Re: ERROR ALLOCATING DEVICE [message #167135 is a reply to message #167131]

Tue, 11 April 2006 08:37

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

Senior Member
Account Moderator

You can CLEAR the settings.
Like this
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconfg.htm#451806

Report message to a moderator

Re: ERROR ALLOCATING DEVICE [message #167144 is a reply to message #167135]

Tue, 11 April 2006 09:20

venkatraghavan
Messages: 83
Registered: October 2005
Location: chennai

Member

my problem was solved.
thanks for your great help.

[Updated on: Tue, 11 April 2006 09:21]

Report message to a moderator

Previous Topic:	Recovery catalog creation
Next Topic:	ORACLE RMAN PROBLEM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 18:15:40 CDT 2024