ORA-19554: error allocating device, device type: SBT_TAPE, device name: [message #132348] |
Fri, 12 August 2005 01:50 |
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 #132805 is a reply to message #132629] |
Tue, 16 August 2005 05:14 |
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 #364742 is a reply to message #132841] |
Tue, 09 December 2008 22:13 |
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!
|
|
|
|
|
|
|