Home » RDBMS Server » Backup & Recovery » ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #132348] Fri, 12 August 2005 01:50 Go to next message
cuisia
Messages: 21
Registered: July 2005
Junior Member
ORA-19554: error allocating device, device type: SBT_TAPE, device name:

While usting Veritas NetBackup to Backup Oracle Database to Tape.
Getting this error.

INF - Recovery Manager: Release 9.2.0.6.0 - 64bit Production
INF - connected to target database: MCVRPRD (DBID=3745749981)
INF - using target database controlfile instead of recovery catalog
INF - sql statement: alter system archive log current
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: ===========================================================
INF - RMAN-03009: failure of allocate command on ch00 channel at 05/11/2005 08:20:30
INF - ORA-19554: error allocating device, device type: SBT_TAPE, device name:
INF - ORA-27211: Failed to load Media Management Library
INF - Recovery Manager complete.
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager

Pls help me out to solve this problem

Thanks
Cuisia
Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #132398 is a reply to message #132348] Fri, 12 August 2005 09:49 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You have problems with MML API.
post your OS,backup script and output of
RMAN>show all
Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #132588 is a reply to message #132398] Mon, 15 August 2005 00:24 Go to previous messageGo to next message
cuisia
Messages: 21
Registered: July 2005
Junior Member
Hi

I am using windows 2000 server in 10g.

this the scripts.....

backup device type sbt tag '%TAG' database include current controlfile;
backup device type sbt tag '%TAG' archivelog all;


thanks,
Mike cuisia
Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #132629 is a reply to message #132588] Mon, 15 August 2005 07:07 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
insufficient information.
have you configured the tape systems?
Are channels properly allocated? You are not explicitly allocating the channels. SO it must be done in configuration for autoallocation.

post the output of show all( as already asked in previous posting).

should help you.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconc1.htm#430706

Above all, do you have the MML API for RMAN to talk to tapes?
This API needs a seperate license.


Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #132805 is a reply to message #132629] Tue, 16 August 2005 05:14 Go to previous messageGo to next message
cuisia
Messages: 21
Registered: July 2005
Junior Member
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # 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 1 DEVICE TYPE 'SBT_TAPE' CONNECT 'sys/oracle@orcl';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.1.0/db_1/dbs/snapcf_orcl.f'; # default

RMAN> backup database;

Starting backup at 16-AUG-05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/16/2005 18:06:26
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

I change my OS in linux ?

Please help

Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #132841 is a reply to message #132805] Tue, 16 August 2005 07:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Do you have MML for Veritas installed / configured.
I dont think so.
without that, you cannot backup directly to tape.
Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #364742 is a reply to message #132841] Tue, 09 December 2008 22:13 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
I've got one problem same to yours.

First time, my database is configured backup directly to tape, and my scripts have had run successfully for a long time. 2 months ago, our tape was moved off because of expiration time hired. And I've just configure again to backup to disk.

This is RMAN's configuration lines now:
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 2;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'D:\arc_backup\arc_%d_%s_%p.bkp';
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 4 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\BACKUP\CONTROLFILE\SNAPSHOT_RATING.F'
;


Every time I crosscheck,delete or single operation to do anything, such as archivelog all, this reports:
RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1050 instance=rating1 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=973 instance=rating1 devtype=DISK
released channel: ORA_DISK_1
released channel: ORA_DISK_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 12/10/2008 11:01:15
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library

RMAN>


So that, I must pin it in a run{}
RMAN> run{
2> allocate channel d1 type disk;
3> crosscheck archivelog all;
4> }
allocated channel: d1
channel d1: sid=1050 instance=rating1 devtype=DISK
 stamp=672941590
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06975_0662123403.001 recid=23800
 stamp=672944770
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06976_0662123403.001 recid=23802
 stamp=672948044
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06977_0662123403.001 recid=23803
 stamp=672948617
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06978_0662123403.001 recid=23804
 stamp=672949173
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06979_0662123403.001 recid=23806
 stamp=672952523
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06980_0662123403.001 recid=23808
 stamp=672955755
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06981_0662123403.001 recid=23810
 stamp=672959509
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06982_0662123403.001 recid=23813
 stamp=672964478
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06983_0662123403.001 recid=23815
 stamp=672966105
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06984_0662123403.001 recid=23816
 stamp=672967086
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06985_0662123403.001 recid=23818
 stamp=672973050
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06986_0662123403.001 recid=23819
 stamp=672980318
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06987_0662123403.001 recid=23820
 stamp=672980847
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06988_0662123403.001 recid=23822
 stamp=672981355
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06989_0662123403.001 recid=23823
 stamp=672981479
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06990_0662123403.001 recid=23824
 stamp=672981528
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06991_0662123403.001 recid=23826
 stamp=672999107
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06992_0662123403.001 recid=23827
 stamp=673000725
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06993_0662123403.001 recid=23829
 stamp=673001529
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06994_0662123403.001 recid=23830
 stamp=673002064
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06995_0662123403.001 recid=23831
 stamp=673002397
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06996_0662123403.001 recid=23832
 stamp=673002453
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06997_0662123403.001 recid=23834
 stamp=673005653
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06998_0662123403.001 recid=23836
 stamp=673008659
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_06999_0662123403.001 recid=23837
 stamp=673009475
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07000_0662123403.001 recid=23839
 stamp=673012370
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07001_0662123403.001 recid=23840
 stamp=673012380
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07002_0662123403.001 recid=23841
 stamp=673012395
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07003_0662123403.001 recid=23843
 stamp=673013259
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07004_0662123403.001 recid=23844
 stamp=673014802
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07005_0662123403.001 recid=23846
 stamp=673016337
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07006_0662123403.001 recid=23847
 stamp=673018173
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07007_0662123403.001 recid=23848
 stamp=673019041
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07008_0662123403.001 recid=23849
 stamp=673019824
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07009_0662123403.001 recid=23852
 stamp=673023793
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07010_0662123403.001 recid=23854
 stamp=673027392
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07011_0662123403.001 recid=23855
 stamp=673031708
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07012_0662123403.001 recid=23857
 stamp=673036076
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07013_0662123403.001 recid=23859
 stamp=673036769
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07014_0662123403.001 recid=23860
 stamp=673037455
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07015_0662123403.001 recid=23862
 stamp=673041133
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07016_0662123403.001 recid=23864
 stamp=673044651
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07017_0662123403.001 recid=23866
 stamp=673048847
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07018_0662123403.001 recid=23870
 stamp=673053549
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07019_0662123403.001 recid=23871
 stamp=673055667
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07020_0662123403.001 recid=23872
 stamp=673056254
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07021_0662123403.001 recid=23874
 stamp=673063013
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07022_0662123403.001 recid=23876
 stamp=673066329
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07023_0662123403.001 recid=23877
 stamp=673067154
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07024_0662123403.001 recid=23879
 stamp=673067975
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07025_0662123403.001 recid=23880
 stamp=673068095
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07026_0662123403.001 recid=23881
 stamp=673068141
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07027_0662123403.001 recid=23883
 stamp=673068770
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07028_0662123403.001 recid=23884
 stamp=673078912
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07029_0662123403.001 recid=23886
 stamp=673086816
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07030_0662123403.001 recid=23888
 stamp=673090560
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07031_0662123403.001 recid=23889
 stamp=673091076
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07032_0662123403.001 recid=23890
 stamp=673091622
validation succeeded for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_07033_0662123403.001 recid=23892
 stamp=673095091
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17044_0662123403.002 recid=23790
 stamp=672927061
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17045_0662123403.002 recid=23792
 stamp=672932940
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17046_0662123403.002 recid=23796
 stamp=672935686
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17047_0662123403.002 recid=23798
 stamp=672940731
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17048_0662123403.002 recid=23801
 stamp=672945511
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17049_0662123403.002 recid=23805
 stamp=672949211
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17050_0662123403.002 recid=23807
 stamp=672953817
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17051_0662123403.002 recid=23809
 stamp=672957822
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17052_0662123403.002 recid=23811
 stamp=672962415
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17053_0662123403.002 recid=23812
 stamp=672962615
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17054_0662123403.002 recid=23814
 stamp=672965414
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17055_0662123403.002 recid=23817
 stamp=672973083
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17056_0662123403.002 recid=23821
 stamp=672981389
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17057_0662123403.002 recid=23825
 stamp=672997285
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17058_0662123403.002 recid=23828
 stamp=673001563
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17059_0662123403.002 recid=23833
 stamp=673002492
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17060_0662123403.002 recid=23835
 stamp=673006984
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17061_0662123403.002 recid=23838
 stamp=673011801
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17062_0662123403.002 recid=23842
 stamp=673012432
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17063_0662123403.002 recid=23845
 stamp=673016371
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17064_0662123403.002 recid=23850
 stamp=673019863
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17065_0662123403.002 recid=23851
 stamp=673023387
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17066_0662123403.002 recid=23853
 stamp=673027203
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17067_0662123403.002 recid=23856
 stamp=673031967
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17068_0662123403.002 recid=23858
 stamp=673036573
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17069_0662123403.002 recid=23861
 stamp=673040384
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17070_0662123403.002 recid=23863
 stamp=673044062
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17071_0662123403.002 recid=23865
 stamp=673048285
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17072_0662123403.002 recid=23867
 stamp=673048921
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17073_0662123403.002 recid=23868
 stamp=673052479
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17074_0662123403.002 recid=23869
 stamp=673053582
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17075_0662123403.002 recid=23873
 stamp=673056292
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17076_0662123403.002 recid=23875
 stamp=673066254
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17077_0662123403.002 recid=23878
 stamp=673068011
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17078_0662123403.002 recid=23882
 stamp=673068806
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17079_0662123403.002 recid=23885
 stamp=673083833
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17080_0662123403.002 recid=23887
 stamp=673089274
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17081_0662123403.002 recid=23891
 stamp=673091663
validation failed for archived log
archive log filename=D:\ARCHIVE_ORA01\ARC_ORA02_17082_0662123403.002 recid=23893
 stamp=673095948
Crosschecked 200 objects

released channel: d1

RMAN>


How I avoid this problem?
Thank you very much!
Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #364744 is a reply to message #364742] Tue, 09 December 2008 22:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>And I've just configure again to backup to disk.
Sure?
What do you think these configs do?
Quote:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXPIECESIZE 4 G;

[Updated on: Tue, 09 December 2008 22:46]

Report message to a moderator

Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #364789 is a reply to message #364744] Wed, 10 December 2008 01:05 Go to previous messageGo to next message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you for your reply!

I am sure because the firs configuration in RMAN are such as

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';#default


And I did not know how I remove this line from RMAN's configuration lines, so that, I remove the #default from _SBT_.

Was I am wrong?

May you clarify more?

Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #364892 is a reply to message #364789] Wed, 10 December 2008 06:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I remove the #default from _SBT_
You just removed the comment.
>>And I did not know how I remove this line from RMAN's configuration lines
You can "clear" them.
http://www.orafaq.com/forum/m/328289/0/?srch=rman+clear#msg_328289
Re: ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #365662 is a reply to message #364892] Thu, 11 December 2008 20:33 Go to previous message
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you very much!

I removed them successfully!
Previous Topic: Problem in Registering a Database through cmdfile
Next Topic: Move the datafile to another database
Goto Forum:
  


Current Time: Wed Apr 24 20:04:42 CDT 2024