Home » RDBMS Server » Backup & Recovery » urgent help
urgent help [message #271322] Mon, 01 October 2007 05:16 Go to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

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 #271323 is a reply to message #271322] Mon, 01 October 2007 05:20 Go to previous messageGo to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
just reinstall the media management library software .
Re: urgent help [message #271329 is a reply to message #271323] Mon, 01 October 2007 05:38 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Check metalink Note:359197.1. And when you're there (metalink.oracle.com), search for the error.

MHE
Re: urgent help [message #271331 is a reply to message #271322] Mon, 01 October 2007 05:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read and follow OraFAQ Forum Guide, especially about silly title and "urgent" word.

Regards
Michel
Re: urgent help [message #271335 is a reply to message #271322] Mon, 01 October 2007 05:59 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

so the best way is to reinstall the mml ???
any other sujjestion about the cause of the problem ???

thanks a million guys
Re: urgent help [message #271344 is a reply to message #271335] Mon, 01 October 2007 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The root of the problem is clear: MML is not or badly installed or configured, so Oracle can't connect it.

Regards
Michel
Re: urgent help [message #271353 is a reply to message #271344] Mon, 01 October 2007 07:15 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

so what dll file i should reinstall, whats the name of the actual media manager library file
thanks guys
Re: urgent help [message #271363 is a reply to message #271353] Mon, 01 October 2007 07:51 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

ok i found the file, its ORASBT.DLL
where can i get a mml ???
thanks
Re: urgent help [message #271376 is a reply to message #271363] Mon, 01 October 2007 08:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ask your vendor. Oracle does not provide MML.

Regards
Michel
Re: urgent help [message #271385 is a reply to message #271376] Mon, 01 October 2007 08:48 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

does anyone know where i can download that file or buy it ???
a link or something ?
Re: urgent help [message #271389 is a reply to message #271385] Mon, 01 October 2007 08:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On your vendor web site.

Regards
Michel
Re: urgent help [message #271411 is a reply to message #271389] Mon, 01 October 2007 10:44 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

what is it supposed to be ???
i've been working for a week.
give me examples, i will buy the mml . from ibm ? dell you mean ?
Re: urgent help [message #271417 is a reply to message #271411] Mon, 01 October 2007 11:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TDPO (Tivoli Data Protection for Oracle, iirc) module for TSM (Tivoli Storage Management).

Regards
Michel

[Updated on: Mon, 01 October 2007 11:16]

Report message to a moderator

Re: urgent help [message #271464 is a reply to message #271417] Mon, 01 October 2007 13:14 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

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 #271466 is a reply to message #271464] Mon, 01 October 2007 13:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you search for TSM and TDPO?
They are IBM products.

Regards
Michel
Re: urgent help [message #271620 is a reply to message #271466] Tue, 02 October 2007 04:19 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

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 #271625 is a reply to message #271620] Tue, 02 October 2007 04:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know this DLL.
Where do you find this?

Regards
Michel
Re: urgent help [message #271626 is a reply to message #271625] Tue, 02 October 2007 04:33 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

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 messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

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 #271654 is a reply to message #271646] Tue, 02 October 2007 06:32 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

should i install the tdpo and tsm both ???
Re: urgent help [message #271657 is a reply to message #271654] Tue, 02 October 2007 06:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Follow the manual or ask your question on an IBM forum.

Regards
Michel

[Updated on: Tue, 02 October 2007 06:44]

Report message to a moderator

Re: urgent help [message #272192 is a reply to message #271657] Thu, 04 October 2007 03:48 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

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 #272195 is a reply to message #272192] Thu, 04 October 2007 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer
 *Cause:  sbtinit returned an error, additional information indicates
          error
 *Action: verify that vendor's storage subsystem product is operating
          correctly

Regards
Michel
Re: urgent help [message #272196 is a reply to message #272195] Thu, 04 October 2007 03:54 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

i did its working just fine on other computer.

i searched all possible website.
havent any of you have faced a problem like that ??
Re: urgent help [message #272220 is a reply to message #272196] Thu, 04 October 2007 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search the differences between the other computer and the failing one.

Regards
Michel
Re: urgent help [message #272681 is a reply to message #272220] Sat, 06 October 2007 02:00 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

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 messageGo to next message
Michel Cadot
Messages: 64103
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 #272764 is a reply to message #272682] Sun, 07 October 2007 03:06 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

what parameter should i put in the media management setting ?
icon5.gif  Re: urgent help [message #272767 is a reply to message #272764] Sun, 07 October 2007 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Question Question Question

The correct one with the correct setting.

Regards
Michel


[Updated on: Sun, 07 October 2007 03:27]

Report message to a moderator

Re: urgent help [message #272769 is a reply to message #272767] Sun, 07 October 2007 03:37 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

whats the correct settings ??
Re: urgent help [message #272771 is a reply to message #271322] Sun, 07 October 2007 03:39 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

The settings which work fine.
Re: urgent help [message #272772 is a reply to message #272771] Sun, 07 October 2007 03:49 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

which are ?? what settings will work fine ?
write the settings which will work fine
Re: urgent help [message #272788 is a reply to message #272772] Sun, 07 October 2007 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't you understand that we don't undestand your question?

Regards
Michel
Re: urgent help [message #272790 is a reply to message #272788] Sun, 07 October 2007 07:09 Go to previous messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

check the attached image, i took a print screen
thank guys
  • Attachment: untitled.JPG
    (Size: 143.45KB, Downloaded 283 times)
Re: urgent help [message #272796 is a reply to message #272790] Sun, 07 October 2007 08:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
These are the parameters that are indicated in the documentation of your media mamanager.

Regards
Michel

[Updated on: Sun, 07 October 2007 08:42]

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 messageGo to next message
ziadaher
Messages: 70
Registered: October 2007
Location: lebanon
Member

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
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You should post your question on IBM/Legato/TSM/TDPO forum

Regards
Michel
Previous Topic: RMAN - shutdown clone hanging
Next Topic: How to find current and last log sequence number which was backed
Goto Forum:
  


Current Time: Sat Dec 03 22:06:01 CST 2016

Total time taken to generate the page: 0.34288 seconds