Home » RDBMS Server » Backup & Recovery » Rman backup not workinf when writinf to external backup library
Rman backup not workinf when writinf to external backup library [message #477778] Mon, 04 October 2010 07:28 Go to next message
Morgs
Messages: 21
Registered: October 2010
Location: South AFrica
Junior Member

Hi

I am runnign Sap and oracle 10 on Lynix. I have am trying to run incremental backups to tape..

I have tried one to disk which works fine( full Level 0 ) backup) .. I have changed my files (.sap files) to run from tape but its not working...(for an incremental)

I have done the ffg..

List of Backup Sets

===================



BS Key Type LV Size Device Type Elapsed Time Completion Time

W's ---- -- ---------- ----------- ------------ ---------------

1 Incr 1 2.26G DISK 01:06:43 01-OCT-10

BP Key: 1 Status: AVAILABLE Compressed: NO Tag: BEEFZYVJ

Piece Name: /localfs300g/IncrBackupTest/beefzyvj/BEEFZYVJ.INCR

List of Datafiles in backup set 1

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata1/system_1/system.data1

2 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata1/undo_1/undo.data1

3 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata1/sysaux_1/sysaux.data1

4 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata2/sr3_1/sr3.data1

5 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata2/sr3_2/sr3.data2

6 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata2/sr3_3/sr3.data3

7 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata2/sr3_4/sr3.data4

8 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata2/sr3_5/sr3.data5

9 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata2/sr3_6/sr3.data6

10 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata2/sr3_7/sr3.data7

11 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata2/sr3_8/sr3.data8

12 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata3/sr3701_1/sr3701.data1

13 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata3/sr3701_2/sr3701.data2

14 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata3/sr3701_3/sr3701.data3

15 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata3/sr3701_4/sr3701.data4

16 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata3/sr3701_5/sr3701.data5

17 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata3/sr3701_6/sr3701.data6

18 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata3/sr3701_7/sr3701.data7

19 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata4/sr3usr_1/sr3usr.data1

20 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata4/sr3701x_1/sr3701x.data1

21 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata4/sr3701x_2/sr3701x.data2

22 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata4/sr3701x_3/sr3701x.data3

23 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata4/sr3701x_4/sr3701x.data4

24 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata4/sr3701x_5/sr3701x.data5

25 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata4/sr3701x_6/sr3701x.data6

26 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata4/sr3701x_7/sr3701x.data7

27 1 Incr 227383859 01-OCT-10 /oracle/OSZ/sapdata3/sr3701x_8/sr3701x.data8





When doing a backup trying to use the external backup.. (from within the rman db) I get the fog error



RMAN> backup database;



Starting backup at 04-OCT-10

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 10/04/2010 12:01:33

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 2



I have also change to Tape i.e (
configure device type tape;)

I just cant seem to get the backup working to the external backup library..

appreciate any help..

[Updated on: Mon, 04 October 2010 07:34]

Report message to a moderator

Re: Rman backup not workinf when writinf to external backup library [message #477783 is a reply to message #477778] Mon, 04 October 2010 08:04 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
ORA-19554: error allocating device, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library


Media Layer error. Please check your MML status

Thanks
Re: Rman backup not workinf when writinf to external backup library [message #477784 is a reply to message #477783] Mon, 04 October 2010 08:06 Go to previous messageGo to next message
Morgs
Messages: 21
Registered: October 2010
Location: South AFrica
Junior Member

Hi Thanks for that, But would appreciate the comand to check mml Status . first time with Rman.. Normally work wth Sap and Veritan netbackup

Thanks..
Re: Rman backup not workinf when writinf to external backup library [message #477808 is a reply to message #477784] Mon, 04 October 2010 09:56 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Check your MML log files.
Oracle has no more information than what it displayed.

Nevertheless, usually:
Quote:
Additional information: 2

means that a process (here RMAN) can't access a file (here most likely but not necessary the MML itself).

Regards
Michel

[Updated on: Mon, 04 October 2010 09:57]

Report message to a moderator

Previous Topic: Confusion about Backupset
Next Topic: Undo tablespace in hotbackup
Goto Forum:
  


Current Time: Sun Nov 24 16:28:00 CST 2024