cancel
Showing results for 
Search instead for 
Did you mean: 

oracle db backup failure

Lacey_Chu
Level 4

Hi,

I am using NetBackup 7.6.1 to backup my oracle db which is using REHL65.

Master: REHL65

Client: REHL65

The detailed status is listed below:
05/27/2015 11:05:03 - Info nbjm (pid=57832) starting backup job (jobid=271) for client song1-db-1, policy Oracle-VzW, schedule diff-incr
05/27/2015 11:05:03 - Info bpbrm (pid=41068) song1-db-1 is the host to backup data from
05/27/2015 11:05:03 - Info bpbrm (pid=41068) reading file list for client
05/27/2015 11:05:03 - Info nbjm (pid=57832) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=271, request id:{2B5C361C-041D-11E5-983F-2E1F282351E6})
05/27/2015 11:05:03 - requesting resource Oracle
05/27/2015 11:05:03 - requesting resource ming.NBU_CLIENT.MAXJOBS.song1-db-1
05/27/2015 11:05:03 - requesting resource ming.NBU_POLICY.MAXJOBS.Oracle-VzW
05/27/2015 11:05:03 - granted resource  ming.NBU_CLIENT.MAXJOBS.song1-db-1
05/27/2015 11:05:03 - granted resource  ming.NBU_POLICY.MAXJOBS.Oracle-VzW
05/27/2015 11:05:03 - granted resource  Oracle
05/27/2015 11:05:03 - estimated 0 kbytes needed
05/27/2015 11:05:03 - Info nbjm (pid=57832) started backup (backupid=song1-db-1_1432695903) job for client song1-db-1, policy Oracle-VzW, schedule diff-incr on storage unit Oracle
05/27/2015 11:05:03 - started process bpbrm (pid=41068)
05/27/2015 11:05:03 - connecting
05/27/2015 11:05:04 - Info bpbrm (pid=41068) starting bphdb on client
05/27/2015 11:05:04 - Info bphdb (pid=19005) Backup started
05/27/2015 11:05:04 - Info bphdb (pid=19005) Processing /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/hot_database_backup.sh
05/27/2015 11:05:04 - Info bphdb (pid=19005) Waiting for the child status
05/27/2015 11:05:04 - connected; connect time: 0:00:00
05/27/2015 11:05:56 - Error bpbrm (pid=41068) from client song1-db-1: ERR - Script exited with status = 1 <the requested operation was partially successful>
05/27/2015 11:05:56 - Error bpbrm (pid=41068) from client song1-db-1: ERR - bphdb exit status = 6: the backup failed to back up the requested files
05/27/2015 11:05:56 - Info bphdb (pid=19005) done. status: 6: the backup failed to back up the requested files

05/27/2015 11:05:56 - end writing
the backup failed to back up the requested files  (6)


login the server, you can see below error

vi /usr/openv/netbackup/ext/db_ext/oracle/samples/rman/hot_database_backup.sh.out

sql statement: alter system archive log current
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 05/27/2015 07:05:37
RMAN-11003: failure during parse/execution of SQL statement: alter system archive log current
ORA-16038: log 3 sequence# 6 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 3 thread 1: '/opt/PlexView/Oracle/ora02/oradata/plxdb/redo/redo03.log'

 

Can anyone help me resolve it? Thanks in advance!

 

Regards,

Lacey

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Level 6
Partner    VIP    Accredited Certified
This is an Oracle error, not NBU. Your dba needs to investigate.

View solution in original post

2 REPLIES 2

Marianne
Level 6
Partner    VIP    Accredited Certified
This is an Oracle error, not NBU. Your dba needs to investigate.

Michael_G_Ander
Level 6
Certified

Looks like the archive log area is full.

A workaround can be to outcomment the sql  alter switch log in the rman script with # and the run backup to free up some space and then remove the # again.

The standard questions: Have you checked: 1) What has changed. 2) The manual 3) If there are any tech notes or VOX posts regarding the issue