Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Rman backup failed with status 6

Created: 27 Feb 2012 | 15 comments

dear all,

im trying to configure RMAN backup to oracle 10G database and im gettting status error 6 even following all steps in manual

please find the log from the job

<<<

02/27/2012 11:56:16 - Info nbjm (pid=8605) starting backup job (jobid=6610) for client bmmi-db-prsrv2, policy RMAN-TEST, schedule RMAN-BKP
02/27/2012 11:56:16 - Info nbjm (pid=8605) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=6610, request id:{E8645904-6120-11E1-8F59-00144F5B9BC6})
02/27/2012 11:56:16 - requesting resource bmmi-db-prsrv2-hcart3-robot-tld-0
02/27/2012 11:56:16 - requesting resource bmmi-nbusrv.NBU_CLIENT.MAXJOBS.bmmi-db-prsrv2
02/27/2012 11:56:16 - requesting resource bmmi-nbusrv.NBU_POLICY.MAXJOBS.RMAN-TEST
02/27/2012 11:56:16 - granted resource  bmmi-nbusrv.NBU_CLIENT.MAXJOBS.bmmi-db-prsrv2
02/27/2012 11:56:16 - granted resource  bmmi-nbusrv.NBU_POLICY.MAXJOBS.RMAN-TEST
02/27/2012 11:56:16 - granted resource  bmmi-db-prsrv2-hcart3-robot-tld-0
02/27/2012 11:56:16 - estimated 0 kbytes needed
02/27/2012 11:56:16 - Info nbjm (pid=8605) started backup job for client bmmi-db-prsrv2, policy RMAN-TEST, schedule RMAN-BKP on storage unit bmmi-db-prsrv2-hcart3-robot-tld-0
02/27/2012 11:56:17 - started process bpbrm (pid=22447)
02/27/2012 11:56:17 - connecting
02/27/2012 11:56:17 - connected; connect time: 0:00:00
02/27/2012 11:56:29 - end writing
02/27/2012 12:04:12 - Info bpbrm (pid=22447) bmmi-db-prsrv2 is the host to backup data from
02/27/2012 12:04:12 - Info bpbrm (pid=22447) reading file list from client
02/27/2012 12:04:13 - Info bpbrm (pid=22447) starting bphdb on client
02/27/2012 12:04:13 - Info bphdb (pid=22450) Backup started
02/27/2012 12:04:13 - Info bphdb (pid=22450) Processing /rman.sh
02/27/2012 12:04:13 - Info bphdb (pid=22450) Waiting for the child status
02/27/2012 12:04:24 - Error bpbrm (pid=22447) from client bmmi-db-prsrv2: ERR - Script exited with status = 1 <the requested operation was partially successful>
02/27/2012 12:04:24 - Error bpbrm (pid=22447) from client bmmi-db-prsrv2: ERR - bphdb exit status = 6: the backup failed to back up the requested files
02/27/2012 12:04:24 - Info bphdb (pid=22450) done. status: 6: the backup failed to back up the requested files
the backup failed to back up the requested files  (6)

>>>

and this is the log from rman script

<<<

Script /rman.sh
==== started on Mon Feb 27 12:04:13 AST 2012 ====

RMAN: /epos/RETAIL/retaildb/10.2.0/bin/rman
ORACLE_SID: RETAIL
ORACLE_USER: oraret
ORACLE_HOME: /epos/RETAIL/retaildb/10.2.0

NB_ORA_FULL: 1
NB_ORA_INCR: 0
NB_ORA_CINC: 0
NB_ORA_SERV: bmmi-nbusrv
NB_ORA_POLICY: RMAN-TEST

Full backup requested
Sun Microsystems Inc. SunOS 5.10 Generic January 2005

++ Cluster SW nstalled but net yet configured
++ Add SW stored in /var/sun/
++ STMS must be enabled before running scinstall
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> RMAN> rget database: RETAIL (DBID=798629165)
using target database control file instead of recovery catalog

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>
allocated channel: ch00
channel ch00: sid=937 devtype=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.1 (2011020313)

allocated channel: ch01
channel ch01: sid=933 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.1 (2011020313)

Starting backup at 27-FEB-12
channel ch00: starting incremental level 0 datafile backupset
channel ch00: specifying datafile(s) in backupset
input datafile fno=00017 name=/epos1/RETAIL/retaildata/ts_vlmain/vlmain03.dbf
input datafile fno=00006 name=/epos/RETAIL/retaildata/ts_vlmain/vlmain01.dbf
input datafile fno=00005 name=/epos/RETAIL/retaildata/ts_v2menu/v2menu01.dbf
input datafile fno=00013 name=/epos/RETAIL/retaildata/UNDO/undotbs02.dbf
input datafile fno=00003 name=/epos/RETAIL/retaildata/SYSAUX/sysaux01.dbf
channel ch00: starting piece 1 at 27-FEB-12
channel ch01: starting incremental level 0 datafile backupset
channel ch01: specifying datafile(s) in backupset
input datafile fno=00008 name=/epos1/RETAIL/retaildata/ts_vlmain/vlmain02.dbf
input datafile fno=00002 name=/epos/RETAIL/retaildata/UNDO/undotbs01.dbf
input datafile fno=00014 name=/epos/RETAIL/retaildata/UNDO/undotbs03.dbf
input datafile fno=00015 name=/epos/RETAIL/retaildata/UNDO/undotbs04.dbf
input datafile fno=00001 name=/epos/RETAIL/retaildata/SYSTEM/system01.dbf
channel ch01: starting piece 1 at 27-FEB-12
RMAN-03009: failure of backup command on ch00 channel at 02/27/2012 12:04:23
ORA-19506: failed to create sequential file, name="bk_51_1_776347456", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  no schedules of the correct type exist in this policy
channel ch00 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ch01 channel at 02/27/2012 12:04:23
ORA-19506: failed to create sequential file, name="bk_52_1_776347456", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  no schedules of the correct type exist in this policy
channel ch01 disabled, job failed on it will be run on another channel
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ch01 channel at 02/27/2012 12:04:23
ORA-19506: failed to create sequential file, name="bk_52_1_776347456", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  no schedules of the correct type exist in this policy
RMAN-03009: failure of backup command on ch00 channel at 02/27/2012 12:04:23
ORA-19506: failed to create sequential file, name="bk_51_1_776347456", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSACreateObject: Failed with error:
   Server Status:  no schedules of the correct type exist in this policy

RMAN>

Recovery Manager complete.

Script /rman.sh
==== ended in error on Mon Feb 27 12:04:23 AST 2012 ====

 >>>

Comments 15 CommentsJump to latest comment

Marianne's picture

"Server Status:  no schedules of the correct type exist in this policy"

Please post your policy config. On your master, run:

bppllist RMAN-TEST -U

Ensure that you have 2 schedules in your policy: Automatic Full Backup as well as Default-Application-Backup schedule.

Automatic Full Backup schedule will simply determine when the scheduler on the master will kick off the script on the client.
The actual backup that is started by the script on the client now needs a Default-Application-Backup schedule with an open window. The default in NBU is to have this schedule open 24x7. Best to leave it this way.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

mjalil's picture

dear Marianne,

i have done as you said to make to schedules and it worked perfectly,

thanks alot

rgrds/ MJ

Marianne's picture

Please mark Solution if your problem is solved?

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

mjalil's picture

actually the backup went fine but one thing that the main job report failure with status 6 but actually the backup finished

it says "the backup failed to back up the requested files  (6)"

nesel's picture

Hi Mjalil, please verify your RMAN script, if backup works fine from the beginning and fails in the end. Please check the child job details, file list if "/db" and "/arch" jobs is done. If your missing "/arch" file list on the child job, maybe archivelogs backup portion causes the error. Please verify if there is archivelogs to be backup.

Marianne's picture

Something is still failing.

Probably the Archive Logs at the end of the backup?

Check RMAN out-file.

Also create dbclient log folder on the client:

# mkdir /usr/openv/netbackup/logs/dbclient
# chmod 777 dbclient

Post dbclient log after next failure as well as RMAN out-file.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

mjalil's picture

this is the error from the script output

<<<

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/27/2012 16:14:27
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /epos/RETAIL/retaildata/ARCHIVELOG/1_28030_641846198.dbf
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
>>>

and find the attached log for dbclient

AttachmentSize
log.022812.txt 147.04 KB
Will Restore's picture

why is that? 

Will Restore -- where there is a Will there is a way

mjalil's picture

this cause is the server one of the database nodes and SUN cluster installed

Marianne's picture

RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /epos/RETAIL/retaildata/ARCHIVELOG/1_28030_641846198.dbf
ORA-27037: unable to obtain file status

PLEASE tell your DBA's to stop deleting/moving, doing WHATEVER they do with the Archive logs.

Rman now needs to take care of them - backup, then delete.

Get your dba to do

change archivelog all crosscheck;

 before trying another backup.

See http://www.shutdownabort.com/errors/RMAN-06059.php

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

mjalil's picture

hi,

actually im a DBA as well so ill do it and i will update u soon

thanks for the help

mjalil's picture

marianne,

i did the command given but the output is nothing changed, and i make the rman connecting to another database for catalog

but still i got the same error as it not finding the file even i do resync the catalog

Yasuhisa Ishikawa's picture
RMAN> change archivelog all crosscheck;
RMAN> delete expired archivelog all;

If no luck, please ask for fix in Oracle's Forum(OTN or so).

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Marianne's picture

You will need to find out from Oracle point of view, since the error is produced by Oracle.

There are a number of Oracle online docs as well as Oracle/Rman forums.

http://docs.oracle.com/cd/B28359_01/backup.111/b28...

http://docs.oracle.com/cd/B10501_01/server.920/a96...

From NBU point of view there is nothing that can be done - NBU is merely reporting the failure reported by Oracle/RMAN.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

mjalil's picture

Marianne,

thanks alot for your help and support, i did the commands for Yasuhisa and cleared the logs of the archive logs

regards

MJ,