Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to deal with ORA-27211 errors when NBU backs up the database. The article is very detailed and has a certain reference value. Interested friends must finish reading it!

The installation and configuration of Veritas Netbackup 7.0 quickly reported error 6 when backing up the Oracle 11G database. Looking up the output log of NBU, it was found that an ORA-27211 error occurred. The specific error messages are as follows:

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03009: failure of allocate command on ch00 channel at 09/21/2012 14:36:13

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

ORA-27211: Failed to load Media Management Library

Additional information: 2

RMAN > RMAN >

Recovery Manager complete.

Script / usr/openv/hot_database_backup.sh

= ended in error on Fri Sep 21 14:36:13 CST 2012 =

Errors are also encountered when backing up RMAN on the database side

Oracle@dbsvr$ rman nocatalog target sys/oracle@test

Recovery Manager: Release 11.2.0.3.0-64bit Production

Copyright (c) 1982, 2011, Oracle.

All rights reserved.

Connected to target database: TRAIN (DBID=678348214)

Using target database controlfile instead of recovery catalog

RMAN > run {

2 > allocate channel ch00 type 'SBT_TAPE'

3 > backup full database

4 > release channel ch00

5 >}

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03009: failure of allocate command on ch00 channel at 11/13/2005 15:10:28

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

ORA-27211: Failed to load Media Management Library

Additional information: 25

No. 6 error is a common typical error in NBU. For the analysis of several situations of No. 6 error, you can refer to my previous blog post http://xjsunjie.blog.51cto.com/999372/935347,. Of course, the error we encountered today is another situation, specific analysis of specific problems.

After examining the output log of NBU, let's take a look at the log generated by Oracle at the time of backup:

$more data_ora_0579.trc

Oracle process number: 2917

Unix process pid: 5244, p_w_picpath: oracletrain@db

* ACTION NAME: (0000001 STARTED1) 2012-09-21 14 purl 3628.230

* SERVICE NAME: () 2012-09-21 14 purl 3628.230

* SESSION ID: (160.7) 2012-09-21 1415 3628.230

SKGFQ OSD: Error in function sbtinit on line 4381

SKGFQ OSD: Look for SBT Trace messages in file / oracle/app/oracle/product/11.2.0/admin/train/udump/sbtio.log

SBT Initialize failed for oracle.static

As you can see from the log above, this is due to the failure of sbtinit during backup. Try Oracle's testing tool:

Oracle@db$ sbttest / etc/hosts

The sbt function pointers are loaded from oracle.static library.

Libobk.so could not be loaded. Check that it is installed

After analysis, the main reason is that the backup failure error caused by the file libobk.so does not exist in Oracle.

Here's what we can do.

Oracle@db$ ln-s / usr/openv/netbackup/bin/libobk.so64 / oracle/app/oracle/product/11.2.0/db_1/lib/libobk.so

Make a soft link to the libobk.so64 file in NBU to the corresponding directory of ORACLE

Let's test it again:

Oracle@db$ sbttest / etc/hosts

The sbt function pointers are loaded from libobk.so library.

-- sbtinit succeeded

-sbtinit (2nd time) succeeded

Sbtinit: Media manager supports SBT API version 2.0

Sbtinit: Media manager is version 5.0.0.0

Sbtinit: vendor description string=Veritas NetBackup for Oracle-Release 7.0 (2011020316)

Sbtinit: allocated sbt context area of 8 bytes

Sbtinit: proxy copy is supported

-- sbtinit2 succeeded

-regular_backup_restore starts..

Or you can execute the ORACLE_LINK script in the BIN directory of NBU.

Then back up the strategy in NBU and find that it is ready for normal backup.

Note: it is suggested that the ORACLE instance needs to be closed before running the script. If you are a version of ORACLE 9i or above, you can do this directly online.

The above is all the contents of the article "how to deal with ORA-27211 errors when NBU backs up the database". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.