urgent help [message #271322] |
Mon, 01 October 2007 05:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
hello guys;
i am a system administrator trainee, i dont know much yet. my mentor gave me the following assignment, he wanted me to know whats wrong. he entered the enterprise manager and tested the tape backup. it gave the bellow error report.
please advice what i should check for. thanks a million
Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 1 12:19:44 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
connected to target database: DEV1 (DBID=3205417984)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> run {
2> allocate channel oem_sbt_backup type 'sbt_tape' format '%U';
3> backup as BACKUPSET current controlfile tag '10012007121942';
4> restore controlfile validate from tag '10012007121942';
5> release channel oem_sbt_backup;
6> }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on oem_sbt_backup channel at 10/01/2007 12:19:47
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
RMAN> allocate channel for maintenance type 'sbt_tape' ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on ORA_MAINT_SBT_TAPE_1 channel at 10/01/2007 12:19:48
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
RMAN> delete noprompt backuppiece tag '10012007121942';
RMAN-00571: ==========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 10/01/2007 12:19:48
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
RMAN> exit;
Recovery Manager complete.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: urgent help [message #271464 is a reply to message #271417] |
Mon, 01 October 2007 13:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
sorry i am being such a pain in the ass
but i searched ibm, dell, microsoft... they have nothing related to it!!!
please please help, tomorrow is my deadline i need to figure it out
thanks
really thanks
|
|
|
|
Re: urgent help [message #271620 is a reply to message #271466] |
Tue, 02 October 2007 04:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
i found the tsm and tdpo installation, i only need the orasbt.dll file from it, where should i copy it ??
in windowns/system32 or in oracle/bin ???
thanks alot guys, you really helped me
|
|
|
|
Re: urgent help [message #271626 is a reply to message #271625] |
Tue, 02 October 2007 04:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
its the dll file responsible for the media management, i tried to put it on the system32, i faced another error (shown below)
should i install the tsd and tdpo ?? or just copy the orasbt.dll file? i dont want to mess the server coz i installed the tsd and tdpo files
thanks again
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of delete command at 10/02/2007 12:24:56
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
OSD-02601: Message 2601 not found; product=RDBMS; facility=SOSD
|
|
|
Re: urgent help [message #271646 is a reply to message #271626] |
Tue, 02 October 2007 05:55 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
one thing i installed the tdpo software, its still not working and giving me this error
----------------------------------------------------------------
RMAN-03002: failure of delete command at 10/02/2007 12:24:56
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
OSD-02601: Message 2601 not found; product=RDBMS; facility=SOSD
----------------------------------------------------------------
what has to be done ??
|
|
|
|
|
Re: urgent help [message #272192 is a reply to message #271657] |
Thu, 04 October 2007 03:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
i want to backup my data from oracle 10i and i have windows2000 advanced server, i am testing the backup tape through oracle enterprise manager, its giving me a ORA-27000, i downloaded the driver and installed it, same error... please help, its urgent
|
|
|
|
|
|
Re: urgent help [message #272681 is a reply to message #272220] |
Sat, 06 October 2007 02:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
here's the new thing:
in oracle enterprise manager, i can test tape backup and test disk backup. i know i was pain in the ass with all my amatuer questions and stuff, see the problem was happening when i perform test tape backup, i tried to do a disk backup and here's what i got:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on oem_disk_backup channel at 10/06/2007 09:41:24
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 7618560 bytes disk space from 10737418240 limit
|
|
|
Re: urgent help [message #272682 is a reply to message #272681] |
Sat, 06 October 2007 03:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
ORA-19809: limit exceeded for recovery files
*Cause: The limit for recovery files specified by the
DB_RECOVERY_FILE_DEST_SIZE was exceeded.
*Action:The error is accompanied by 19804. See message 19804 for further
details.
*Action: None
ORA-19804: cannot reclaim %s bytes disk space from %s limit
*Cause: Oracle cannot reclaim disk space of specified bytes from the
DB_RECOVERY_FILE_DEST_SIZE limit.
*Action: There are five possible solutions:
1) Take frequent backup of recovery area using RMAN.
2) Consider changing RMAN retention policy.
3) Consider changing RMAN archivelog deletion policy.
4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
5) Delete files from recovery area using RMAN.
Regards
Michel
[Updated on: Sat, 06 October 2007 03:36] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
Re: urgent help [message #272947 is a reply to message #272796] |
Mon, 08 October 2007 05:52 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
i searched and searched but couldnt find anything, how should it be like ???
does anyone know the legato software ?? its like tsm and tdpo, if anyone has a link or something
|
|
|
Re: urgent help [message #272952 is a reply to message #272947] |
Mon, 08 October 2007 06:02 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You should post your question on IBM/Legato/TSM/TDPO forum
Regards
Michel
|
|
|