06-24-2016 02:34 AM
Hi everyone,
starting the running netbackup to backup oracle looks ok, but after few mins, there is a error prompt. "the backup failed to back up the requested files" does anyone know how to solve it?
06/24/2016 17:04:02 - Info nbjm (pid=8324) starting backup job (jobid=107) for client bidb01, policy tet, schedule test
06/24/2016 17:04:02 - Info nbjm (pid=8324) requesting MEDIA_SERVER_ONLY resources from RB for backup job (jobid=107, request id:{B1198AA3-92E0-4C61-9FBC-72306C45F7AB})
06/24/2016 17:04:02 - requesting resource bighorn-hcart3-robot-tld-0
06/24/2016 17:04:02 - requesting resource netbackupserver.domain.local.NBU_POLICY.MAXJOBS.tet
06/24/2016 17:04:02 - granted resource netbackupserver.domain.local.NBU_POLICY.MAXJOBS.tet
06/24/2016 17:04:03 - estimated 0 kbytes needed
06/24/2016 17:04:03 - Info nbjm (pid=8324) started backup (backupid=bidb01_1466759042) job for client bidb01, policy tet, schedule test on storage unit
06/24/2016 17:04:03 - started process bpbrm (pid=22120)
06/24/2016 17:04:04 - Info bpbrm (pid=22120) bidb01 is the host to backup data from
06/24/2016 17:04:04 - Info bpbrm (pid=22120) reading file list for client
06/24/2016 17:04:05 - connecting
06/24/2016 17:04:07 - Info bpbrm (pid=22120) starting bphdb on client
06/24/2016 17:04:07 - Info bphdb (pid=11522) Backup started
06/24/2016 17:04:07 - connected; connect time: 0:00:00
06/24/2016 17:04:08 - Info bphdb (pid=11522) Waiting for the child status
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - ************************************************************
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Backup Information:
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Client: bidb01
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - ORACLE_SID: PRDR1
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - ORACLE_HOME: /u01/app/oracle/product/12.1.0.2/dbhome_1
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Online (Hot) Stream backup requested
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Objects being backed up:
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Whole Database
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Archive Logs
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Control File
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Number of channels to allocate (database): 1
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Number of channels to allocate (archive logs): 1
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Oracle Authentication is being used
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - RMAN Default Limits will be used (Database)
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - RMAN Default Limits will be used (Archive Logs)
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Backup File Name Formats:
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Database: bk_d%d_u%u_s%s_p%p_t%t
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Archive Log: arch_d%d_u%u_s%s_p%p_t%t
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - Control File: ctrl_d%d_u%u_s%s_p%p_t%t
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - End of Backup Information
06/24/2016 17:04:08 - Info bphdb (pid=11522) INF - ************************************************************
06/24/2016 17:04:09 - Info bphdb (pid=11522) INF - Database status is: OPEN
06/24/2016 17:04:09 - Info bphdb (pid=11522) INF - Database open mode is: READ WRITE
06/24/2016 17:04:09 - Info bphdb (pid=11522) INF - ARCHIVE LOG mode is: ARCHIVELOG
06/24/2016 17:04:09 - Info bphdb (pid=11522) INF - CDB mode: NOT ENABLED
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - Starting Oracle Recovery Manager.
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - Using: /u01/app/oracle/product/12.1.0.2/dbhome_1/bin/rman
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - Connection info: target 'sys/*****@PRDR' nocatalog
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - Start of Recovery Manager input.
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - # -----------------------------------------------------------------
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - # RMAN command section
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - # -----------------------------------------------------------------
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - RUN {
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - ALLOCATE CHANNEL ch00
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - TYPE 'SBT_TAPE'
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - SEND 'NB_ORA_CLIENT=bidb01,NB_ORA_SID=PRDR1,NB_ORA_SERV=netbackupserver.domain.local,NB_ORA_POLICY=tet,NB_ORA_PARENT_JOBID=107,NB_ORA_SCHED=test';
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - BACKUP
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - INCREMENTAL LEVEL=0
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - FORMAT 'bk_d%d_u%u_s%s_p%p_t%t'
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - DATABASE;
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - RELEASE CHANNEL ch00;
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - # Backup Archived Logs
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - sql 'alter system archive log current';
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - ALLOCATE CHANNEL ch00
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - TYPE 'SBT_TAPE'
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - SEND 'NB_ORA_CLIENT=bidb01,NB_ORA_SID=PRDR1,NB_ORA_SERV=netbackupserver.domain.local,NB_ORA_POLICY=tet,NB_ORA_PARENT_JOBID=107,NB_ORA_SCHED=test';
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - BACKUP
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - FORMAT 'arch_d%d_u%u_s%s_p%p_t%t'
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - ARCHIVELOG
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - ALL
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - DELETE INPUT;
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - RELEASE CHANNEL ch00;
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - # Control File Backup
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - ALLOCATE CHANNEL ch00
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - TYPE 'SBT_TAPE'
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - SEND 'NB_ORA_CLIENT=bidb01,NB_ORA_SID=PRDR1,NB_ORA_SERV=netbackupserver.domain.local,NB_ORA_POLICY=tet,NB_ORA_PARENT_JOBID=107,NB_ORA_SCHED=test';
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - BACKUP
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - FORMAT 'ctrl_d%d_u%u_s%s_p%p_t%t'
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - CURRENT CONTROLFILE;
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - RELEASE CHANNEL ch00;
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - }
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - End of Recovery Manager input.
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - Start of Recovery Manager output.
06/24/2016 17:04:10 - Info bphdb (pid=11522) INF - Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jun 24 17:04:10 2016
06/24/2016 17:04:12 - Info bphdb (pid=11522) INF - connected to target database: PRDR (DBID=2847249115)
06/24/2016 17:04:12 - Info bphdb (pid=11522) INF - using target database control file instead of recovery catalog
06/24/2016 17:04:12 - Info bphdb (pid=11522) INF - allocated channel: ch00
06/24/2016 17:04:12 - Info bphdb (pid=11522) INF - channel ch00: SID=9 instance=PRDR2 device type=SBT_TAPE
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - channel ch00: starting incremental level 0 datafile backup set
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00018 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_ods__cnbltfp9_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00014 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnblt9vp_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00023 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnbltl6v_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00013 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnblt8s5_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00017 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_ods__cnbltdqh_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00011 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnblt6x0_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00025 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnbltn1h_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00032 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnblttg7_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00039 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_index_bi_cnblv0lk_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00006 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnblsy1v_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00027 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_stats_bi_cnbltoz0_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00009 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnblt56w_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00003 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_undotbs1_cmtwhjyt_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00035 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_ods__cnbltx2c_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00010 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnblt60y_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00026 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnblto10_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00030 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnbltrmk_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00019 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_sap__cnbltgog_.dbf
06/24/2016 17:04:13 - Info bphdb (pid=11522) INF - input datafile file number=00024 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnbltm6b_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00037 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnbltys7_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00020 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnblthjs_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00004 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_undotbs2_cmtwhr8q_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00036 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnbltxw7_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00034 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_ods__cnbltw75_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00028 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnbltptj_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00008 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_bods_cnblt4bs_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00033 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnbltv94_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00041 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnqwcqjv_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00002 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_sysaux_cmtwhft0_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00001 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_system_cmtwh9ct_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00021 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnbltjgr_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00029 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnbltqr9_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00005 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_users_cmtwhsmb_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00022 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnbltkgb_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00038 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnbltzo0_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00007 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_boe__cnblt3ck_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00012 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnblt7ss_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00015 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnbltbwt_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00016 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_lph__cnbltcvo_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00031 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_dwh__cnbltsjz_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00040 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnqts73z_.dbf
06/24/2016 17:04:14 - Info bphdb (pid=11522) INF - input datafile file number=00042 name=/u02/app/oracle/oradata/datastore/.ACFS/snaps/PRDR/PRDR/datafile/o1_mf_tbl_stg__cnqy79fv_.dbf
06/24/2016 17:19:19 - Error bpbrm (pid=22120) from client bidb01: ERR - Script exited with status = 1 <the requested operation was partially successful>
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - released channel: ch00
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - RMAN-00571: ===========================================================
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - RMAN-00571: ===========================================================
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - RMAN-03009: failure of backup command on ch00 channel at 06/24/2016 17:19:19
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - ORA-19506: failed to create sequential file, name="bk_dPRDR_u08r8v8od_s8_p1_t915383053", parms=""
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - ORA-27028: skgfqcre: sbtbackup returned error
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - VxBSACreateObject: Failed with error:
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - Server Status: Communication with the server has not been initiated or the server status has not been retrieved from the serve
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - Recovery Manager complete.
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - End of Recovery Manager output.
06/24/2016 17:19:19 - Info bphdb (pid=11522) INF - End Oracle Recovery Manager.
06/24/2016 17:19:19 - Error bpbrm (pid=22120) from client bidb01: ERR - bphdb exit status = 6: the backup failed to back up the requested files
06/24/2016 17:19:21 - Info bphdb (pid=11522) done. status: 6: the backup failed to back up the requested files
06/24/2016 17:19:21 - end writing
the backup failed to back up the requested files (6)
Thanks
Yip
06-24-2016 02:41 PM
06-26-2016 08:05 PM
everything is looks fine. but i still hits this error.
1: (96) unable to allocate new media for backup, storage unit has none available
06-26-2016 08:57 PM
06-27-2016 03:49 AM
Looks to me like a timeout issue, as there is more 15 minutes between the start and stop of the file list creation, maybe increasing the CLIENT_READ_TIMEOUT to 1800 would help
Other than that I suggest to go through the steps here:
https://www.veritas.com/community/forums/general-database-backup-error-troubleshooting
06-27-2016 10:13 PM
i tired its not working.
now im doing Drive diagnotics and result get Failed. i think i shd debug from there first.
06-27-2016 11:27 PM