Home » RDBMS Server » Backup & Recovery » ERROR ALLOCATING DEVICE
ERROR ALLOCATING DEVICE [message #167120] Tue, 11 April 2006 07:50 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 24 10:38:03 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.