Forum Discussion

enguessan's avatar
enguessan
Level 4
16 years ago
Solved

Can some body help me? Emergency

How to solve the following problem I got when trying to backup Oracle Database 10 with RMAN. We don't use RMAN Catalog


Script /opt/app/oracle/admin/SCRIPT/dbmonscnocat.sh

==== started on Mon Jan 18 00:23:40 GMT 2010 ====

Sun Microsystems Inc. SunOS 5.10 Generic January 2005

You have mail.

RMAN> RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> RMAN> talog

RMAN>

RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60>

allocated channel: ch00

channel ch00: sid=3161 devtype=SBT_TAPE

channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

allocated channel: ch01

channel ch01: sid=3202 devtype=SBT_TAPE

channel ch01: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

allocated channel: ch02

channel ch02: sid=3233 devtype=SBT_TAPE

channel ch02: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

allocated channel: ch03

channel ch03: sid=3251 devtype=SBT_TAPE

channel ch03: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

sent command to channel: ch00

sent command to channel: ch01

sent command to channel: ch02

sent command to channel: ch03

Starting backup at 18-JAN-2010

channel ch00: starting incremental level 0 datafile backupset

channel ch00: specifying datafile(s) in backupset

input datafile fno=00002 name=/u07/oracle/oradata/monsc/undotbs01.dbf

channel ch00: starting piece 1 at 18-JAN-2010

channel ch01: starting incremental level 0 datafile backupset

channel ch01: specifying datafile(s) in backupset

input datafile fno=00003 name=/u07/oracle/oradata/monsc/sysaux01.dbf

input datafile fno=00006 name=/u07/oracle/oradata/monsc/ts_ref_moneta_togo01_02.dbf

channel ch01: starting piece 1 at 18-JAN-2010

channel ch02: starting incremental level 0 datafile backupset

channel ch02: specifying datafile(s) in backupset

input datafile fno=00005 name=/u07/oracle/oradata/monsc/ts_ref_moneta_togo01_01.dbf

input datafile fno=00004 name=/u07/oracle/oradata/monsc/users01.dbf

channel ch02: starting piece 1 at 18-JAN-2010

channel ch03: starting incremental level 0 datafile backupset

channel ch03: specifying datafile(s) in backupset

including current control file in backupset

input datafile fno=00001 name=/u07/oracle/oradata/monsc/system01.dbf

channel ch03: starting piece 1 at 18-JAN-2010

channel ch03: finished piece 1 at 18-JAN-2010

piece handle=bk_MONSC_ud4l3nooh_s420_p1_t708567825 tag=MONSC comment=API Version 2.0,MMS Version 5.0.0.0

channel ch03: backup set complete, elapsed time: 00:03:56

channel ch01: finished piece 1 at 18-JAN-2010

piece handle=bk_MONSC_ud2l3nooh_s418_p1_t708567825 tag=MONSC comment=API Version 2.0,MMS Version 5.0.0.0

channel ch01: backup set complete, elapsed time: 00:05:41

channel ch02: finished piece 1 at 18-JAN-2010

piece handle=bk_MONSC_ud3l3nooh_s419_p1_t708567825 tag=MONSC comment=API Version 2.0,MMS Version 5.0.0.0

channel ch02: backup set complete, elapsed time: 00:06:26

channel ch00: finished piece 1 at 18-JAN-2010

piece handle=bk_MONSC_ud1l3nooh_s417_p1_t708567825 tag=MONSC comment=API Version 2.0,MMS Version 5.0.0.0

channel ch00: backup set complete, elapsed time: 00:06:41

Finished backup at 18-JAN-2010

released channel: ch00

released channel: ch01

released channel: ch02

released channel: ch03

sql statement: alter system archive log current

allocated channel: ch00

channel ch00: sid=3161 devtype=SBT_TAPE

channel ch00: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

allocated channel: ch01

channel ch01: sid=3202 devtype=SBT_TAPE

channel ch01: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

allocated channel: ch02

channel ch02: sid=3233 devtype=SBT_TAPE

channel ch02: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

allocated channel: ch03

channel ch03: sid=3251 devtype=SBT_TAPE

channel ch03: Veritas NetBackup for Oracle - Release 6.5 (2007072323)

sent command to channel: ch00

sent command to channel: ch01

sent command to channel: ch02

sent command to channel: ch03

Starting backup at 18-JAN-2010

current log archived

channel ch00: starting archive log backupset

channel ch00: specifying archive log(s) in backup set

input archive log thread=1 sequence=579 recid=543 stamp=708393976

input archive log thread=1 sequence=580 recid=545 stamp=708393977

input archive log thread=1 sequence=581 recid=547 stamp=708480876

channel ch00: starting piece 1 at 18-JAN-2010

channel ch01: starting archive log backupset

channel ch01: specifying archive log(s) in backup set

input archive log thread=1 sequence=576 recid=537 stamp=708307756

input archive log thread=1 sequence=577 recid=539 stamp=708307757

input archive log thread=1 sequence=578 recid=541 stamp=708357771

channel ch01: starting piece 1 at 18-JAN-2010

channel ch02: starting archive log backupset

channel ch02: specifying archive log(s) in backup set

input archive log thread=1 sequence=582 recid=550 stamp=708480877

input archive log thread=1 sequence=583 recid=552 stamp=708566834

input archive log thread=1 sequence=584 recid=554 stamp=708566835

channel ch02: starting piece 1 at 18-JAN-2010

channel ch03: starting archive log backupset

channel ch03: specifying archive log(s) in backup set

input archive log thread=1 sequence=585 recid=556 stamp=708568229

input archive log thread=1 sequence=586 recid=558 stamp=708568230

channel ch03: starting piece 1 at 18-JAN-2010

RMAN-03009: failure of backup command on ch00 channel at 01/18/2010 00:32:46

ORA-19506: failed to create sequential file, name="arch_MONSC_ud5l3np56_s421_p1_t708568230", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: Error received from media manager layer, error text:

VxBSACreateObject: Failed with error:

Server Status: error requesting media (tpreq)

channel ch00 disabled, job failed on it will be run on another channel

RMAN-03009: failure of backup command on ch01 channel at 01/18/2010 00:32:46

ORA-19506: failed to create sequential file, name="arch_MONSC_ud6l3np56_s422_p1_t708568230", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: Error received from media manager layer, error text:

VxBSACreateObject: Failed with error:

Server Status: error requesting media (tpreq)

channel ch01 disabled, job failed on it will be run on another channel

RMAN-03009: failure of backup command on ch02 channel at 01/18/2010 00:32:46

ORA-19506: failed to create sequential file, name="arch_MONSC_ud7l3np56_s423_p1_t708568230", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: Error received from media manager layer, error text:

VxBSACreateObject: Failed with error:

Server Status: error requesting media (tpreq)

channel ch02 disabled, job failed on it will be run on another channel

released channel: ch00

released channel: ch01

released channel: ch02

released channel: ch03

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

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

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

RMAN-03009: failure of backup command on ch03 channel at 01/18/2010 00:32:46

ORA-19506: failed to create sequential file, name="arch_MONSC_ud8l3np56_s424_p1_t708568230", parms=""

ORA-27028: skgfqcre: sbtbackup returned error

ORA-19511: Error received from media manager layer, error text:

VxBSACreateObject: Failed with error:

Server Status: error requesting media (tpreq)

RMAN>

Recovery Manager complete.

Script /opt/app/oracle/admin/SCRIPT/dbmonscnocat.sh

==== ended in error on Mon Jan 18 00:32:46 GMT 2010 ====

7.1.x and Earlier
Backup and Recovery
Database
NetBackup
  • Marianne's avatar
    Marianne
    16 years ago
    You said "The Satus is Error 98 : Unable to allocate new media for backup." This is in fact the description for Status 96.
    Status 98 is not the same as status 96.

    Please note description of status 98  (extract from Troubleshooting Guide):

    error requesting media (tpreq)
    The tape manager and optical manager (bptm) received an error when they requested a media mount from the following: the NetBackup Device Manager service (on Windows) or the Media Manager device daemon (ltid) (on UNIX).

    Try the following:
    *  Check the NetBackup Problems report to determine the reason for the failure. The most common cause is that the NetBackup Device Manager service (on Windows) or the Media Manager device daemon (ltid) (on UNIX) is not running. Start it if necessary.

    As requested previously, information from Details tab in Activity Monitor is a good start. If that does not reveal the problem,  we need to look at  bptm log on the Media server.
  • Nicolai's avatar
    Nicolai
    Moderator
    16 years ago
    This is not a RMAN fault, but a Netbackup error. You need to gain access to the Netbackup console and take a look at the job in the "Activity monitor -> backup job in monitor  -> Detailed Status".




  • enguessan's avatar
    enguessan
    Level 4
    16 years ago
    The Satus is Error 98 : Unable to allocate new media for backup.
    THe robot has some tape on it and i don't know why the backup fail.
    some time the backup go well. and other time it fail with se same error :

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

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

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

    RMAN-03009: failure of backup command on ch03 channel at 01/18/2010 00:32:46

    ORA-19506: failed to create sequential file, name="arch_MONSC_ud8l3np56_s424_p1_t708568230", parms=""

    ORA-27028: skgfqcre: sbtbackup returned error

    ORA-19511: Error received from media manager layer, error text:

    VxBSACreateObject: Failed with error:

    Server Status: error requesting media (tpreq)


    Do somebody encounter this problem?
     

  • Sriram's avatar
    Sriram
    Level 6
    16 years ago
    can you post the dbclient and bphdb logs from the client, specifically run during this error.

    Some questions:

    1.  Was this job running successfully in the past?

    2.  If not while configuring RMAN did you ran oracle_link script before testing a backup?

    3.  How do you run the backup ? Are you running this script through a policy or directly as a script from client?

    4.  Do you have the RMAN netbackup policy configured?

  • Nicolai's avatar
    Nicolai
    Moderator
    16 years ago
    The community  need a screen dump from the job' s "detailed status (Netbackup activity monitor)  in order to help you. There can be many reasons for status code 98.
  • Marianne's avatar
    Marianne
    Level 6
    16 years ago
    You said "The Satus is Error 98 : Unable to allocate new media for backup." This is in fact the description for Status 96.
    Status 98 is not the same as status 96.

    Please note description of status 98  (extract from Troubleshooting Guide):

    error requesting media (tpreq)
    The tape manager and optical manager (bptm) received an error when they requested a media mount from the following: the NetBackup Device Manager service (on Windows) or the Media Manager device daemon (ltid) (on UNIX).

    Try the following:
    *  Check the NetBackup Problems report to determine the reason for the failure. The most common cause is that the NetBackup Device Manager service (on Windows) or the Media Manager device daemon (ltid) (on UNIX) is not running. Start it if necessary.

    As requested previously, information from Details tab in Activity Monitor is a good start. If that does not reveal the problem,  we need to look at  bptm log on the Media server.