Forum Discussion

Level 4

13 years ago

Rman backup failed with status 6

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 ====

>>>

7.1.x and Earlier

Active Directory Recovery Agent

Agent for Oracle on Windows or Linux Servers

Backup and Recovery

NetBackup

Marianne
Level 6
13 years ago
"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.
mjalil
Level 4
13 years ago
dear Marianne,

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

thanks alot

rgrds/ MJ
Marianne
Level 6
13 years ago
Please mark Solution if your problem is solved?
mjalil
Level 4
13 years ago
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)"
Marianne
Level 6
13 years ago
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.
Will_Restore
Level 6
13 years ago
why is that?
nesel
Level 4
13 years ago
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.
mjalil
Level 4
13 years ago
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
log.022812.txt147 KB
mjalil
Level 4
13 years ago
this cause is the server one of the database nodes and SUN cluster installed
Marianne
Level 6
13 years ago
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