--0-1680914362-1056260326=:47919
Content-Type: text/plain; charset=us-ascii
I'm working with a client and we are in the preliminary stages of doing a level
0 backup of the Oracle database but we cannot get passed this one RMAN error
that seems to point to a failure of Veritas Media Manager, not being able to
mount a tape and write to it. This is really standard stuff for NBU and
Oracle. I'm wondering if it is simply a syntax error or if there is something
wrong with the library itself. I've included the lines in the level 0 script
-called "coldbackup.sh" and the lines from the RMAN-out file that is generated
each time a level 0 backup is initiated.
**
#
the "coldbackup.sh" script where the 'SBT_TAPE" is declared
#
#
#
CMD_STR="
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append << EOF
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
BACKUP
$BACKUP_TYPE
FORMAT 'bk_u%u_s%s_p%p_t%t'
DATABASE;
sql 'alter database open';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
EOF
"
#
# the RMAN error messages
#
#
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
RMAN-00571: =====================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =======
RMAN-00571: ====================================================
RMAN-00579: the following error occurred at 06/20/2003 15:56:59
RMAN-03007: retryable error occurred during execution of command: allocate
RMAN-12004: unhandled exception during command execution on channel ch00
RMAN-10035: exception raised in RPC: ORA-19554: error allocating device, device
type: SBT_TAPE, device name:
ORA-19557: device error, device type: SBT_TAPE, device name:
ORA-27211: Failed to load Media Management Library
Additional information: 25
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.DEVICEALLOCATE
The Netbackup logs don't reveal much other than the fact that the job
completes with a Status 1 (partially successful) but in fact, no tape is
mounted and no data is written. Could it possibly be they have not allocated
any tapes in the Oracle pool? I did not check that out before leaving the site.
Cheers.
martin arata
storage consultant
GovStor, LLC
--0-1680914362-1056260326=:47919
Content-Type: text/html; charset=us-ascii
<DIV>I'm working with a client and we are in the preliminary stages of doing a
level 0 backup of the Oracle database but we cannot get passed this one RMAN
error that seems to point to a failure of Veritas Media Manager, not being able
to mount a tape and write to it. This is really standard stuff for NBU
and Oracle. I'm wondering if it is simply a syntax error or if there is
something wrong with the library itself. I've included the lines in
the level 0 script -called "coldbackup.sh" and the lines from the RMAN-out file
that is generated each time a level 0 backup is initiated.</DIV>
<DIV>**</DIV>
<DIV>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">#<?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'"><o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'"><SPAN
style="mso-tab-count: 1"> </SPAN>the
"coldbackup.sh" script where the 'SBT_TAPE" is declared<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">#<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">#<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">#<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">CMD_STR="<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">ORACLE_HOME=$ORACLE_HOME<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'">export
ORACLE_HOME<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">ORACLE_SID=$ORACLE_SID<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'">export
ORACLE_SID<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'">$RMAN
target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append <<
EOF<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'">RUN
{<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">BACKUP<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'"><SPAN
style="mso-spacerun: yes">
</SPAN>$BACKUP_TYPE<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'"><SPAN
style="mso-spacerun: yes"> </SPAN>FORMAT
'bk_u%u_s%s_p%p_t%t'<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'"><SPAN
style="mso-spacerun: yes">
</SPAN>DATABASE;<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'"><SPAN
style="mso-spacerun: yes"> </SPAN>sql 'alter database
open';<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RELEASE CHANNEL ch00;<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RELEASE CHANNEL ch01;<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">}<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">EOF<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">"<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">#<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS Mincho'">#<SPAN
style="mso-tab-count: 1"> </SPAN>the RMAN error
messages<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">#<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">#<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11>
<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN-00571:
=====================================================<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
=======<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN-00571:
====================================================<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN-00579: the following error occurred at 06/20/2003
15:56:59<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN-03007: retryable error occurred during execution of command:
allocate<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN-12004: unhandled exception during command execution on channel
ch00<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN-10035: exception raised in RPC: ORA-19554: error allocating
device, device type: SBT_TAPE, device name: <o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">ORA-19557: device error, device type: SBT_TAPE, device name:
<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">ORA-27211: Failed to load Media Management
Library<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">Additional information: 25<o:p></o:p></SPAN></P>
<P class=MsoPlainText><SPAN style="mso-fareast-font-family: 'MS
Mincho'">RMAN-10031: ORA-19624 occurred during call to
DBMS_BACKUP_RESTORE.DEVICEALLOCATE<o:p></o:p></SPAN></P></DIV>
<DIV> The Netbackup logs don't reveal much other than the fact that the
job completes with a Status 1 (partially successful) but in fact, no tape is
mounted and no data is written. Could it possibly be they have not
allocated any tapes in the Oracle pool? I did not check that out before
leaving the site.</DIV>
<DIV> </DIV>
<DIV>Cheers.</DIV>
<DIV> </DIV>
<DIV>martin arata</DIV>
<DIV>storage consultant </DIV>
<DIV>GovStor, LLC</DIV>
--0-1680914362-1056260326=:47919--
|