cancel
Showing results for 
Search instead for 
Did you mean: 

No object matched the specified predicate.

Taufan_MTG
Level 3

Hi all,
I need a help. i'm getting error when i backup my oracle. my client is win 10. actualy 


02/19/2020 02:10:21 - Info nbjm (pid=14215) starting backup job (jobid=275518) for client XXXX, policy XXXX, schedule BACKUP_FULL_XXXX_DAILY
02/19/2020 02:10:21 - Info nbjm (pid=14215) requesting MEDIA_SERVER_ONLY resources from RB for backup job (jobid=275518, request id:{4EE21648-5282-11EA-8B5E-EAE62E57153D})
02/19/2020 02:10:21 - requesting resource stu_disk_XXXX
02/19/2020 02:10:21 - requesting resource XXXX.NBU_POLICY.MAXJOBS.XXXX
02/19/2020 02:10:21 - granted resource XXXX.NBU_POLICY.MAXJOBS.XXXX
02/19/2020 02:10:21 - estimated 0 kbytes needed
02/19/2020 02:10:21 - Info nbjm (pid=14215) started backup (backupid=XXXX_1582053021) job for client XXXX, policy XXXX, schedule BACKUP_FULL_XXXX_DAILY on storage unit
02/19/2020 02:10:21 - started process bpbrm (pid=176250)
02/19/2020 02:10:22 - Info bpbrm (pid=176250) XXXX is the host to backup data from
02/19/2020 02:10:22 - Info bpbrm (pid=176250) reading file list for client
02/19/2020 02:10:22 - Info bpbrm (pid=176250) starting bphdb on client
02/19/2020 02:10:22 - connecting
02/19/2020 02:10:22 - connected; connect time: 0:00:00
02/19/2020 02:10:23 - Info bphdb (pid=4596) Backup started
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - ************************************************************
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Backup Information:
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Client: XXXX
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - ORACLE_SID: XXXXX
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - ORACLE_HOME: c:\oracle\app\product\11.2.0\dbhome_1
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Online (Hot) Stream backup requested
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Objects being backed up:
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Whole Database
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Archive Logs
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Control File
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Number of channels to allocate (database): 4
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Number of channels to allocate (archive logs): 1
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - OS Authentication is being used
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - RMAN Default Limits will be used (Database)
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - RMAN Default Limits will be used (Archive Logs)
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Backup File Name Formats:
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Database: bk_d%d_u%u_s%s_p%p_t%t
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Archive Log: arch_d%d_u%u_s%s_p%p_t%t
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Control File: ctrl_d%d_u%u_s%s_p%p_t%t
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - End of Backup Information
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - ************************************************************
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Database status is: OPEN
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - Database open mode is: READ WRITE
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - ARCHIVE LOG mode is: ARCHIVELOG
02/19/2020 02:10:24 - Info bphdb (pid=4596) INF - CDB mode: NOT ENABLED
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - Starting Oracle Recovery Manager.
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - Using: "c:\oracle\app\product\11.2.0\dbhome_1\bin\rman.exe"
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - Connection info: target / nocatalog
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - Start of Recovery Manager input.
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - # -----------------------------------------------------------------
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - # RMAN command section
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - # -----------------------------------------------------------------
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - RUN {
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - ALLOCATE CHANNEL ch00
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - TYPE 'SBT_TAPE';
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - SEND 'NB_ORA_CLIENT=XXXX,NB_ORA_SID=RTGSGEN2BKP,NB_ORA_SERV=bminbudc01,NB_ORA_POLICY=XXXX,NB_ORA_PARENT_JOBID=275518,NB_ORA_SCHED=BACKUP_FULL_XXXX_DAILY,NB_ORA_PC_SCHED=BACKUP_FULL_XXXX_DAILY,NB_ORA_PC_STREAMS=4';
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - # DEDUPE storage unit was detected - switching to a non-snapshot proxy backup
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - BACKUP
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - INCREMENTAL LEVEL=0 PROXY
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - FORMAT 'bk_d%d_u%u_s%s_p%p_t%t'
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - DATABASE;
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - RELEASE CHANNEL ch00;
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - # Backup Archived Logs
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - sql 'alter system archive log current';
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - ALLOCATE CHANNEL ch00
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - TYPE 'SBT_TAPE';
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - SEND 'NB_ORA_CLIENT=XXXX,NB_ORA_SID=RTGSGEN2BKP,NB_ORA_SERV=bminbudc01,NB_ORA_POLICY=XXXX,NB_ORA_PARENT_JOBID=275518,NB_ORA_SCHED=BACKUP_FULL_XXXX_DAILY';
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - BACKUP
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - FORMAT 'arch_d%d_u%u_s%s_p%p_t%t'
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - ARCHIVELOG
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - ALL
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - DELETE INPUT;
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - RELEASE CHANNEL ch00;
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - # Control file backup
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - ALLOCATE CHANNEL ch00
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - TYPE 'SBT_TAPE';
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - SEND 'NB_ORA_CLIENT=XXXX,NB_ORA_SID=RTGSGEN2BKP,NB_ORA_SERV=bminbudc01,NB_ORA_POLICY=XXXX,NB_ORA_PARENT_JOBID=275518,NB_ORA_SCHED=BACKUP_FULL_XXXX_DAILY';
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - BACKUP
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - FORMAT 'ctrl_d%d_u%u_s%s_p%p_t%t'
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - CURRENT CONTROLFILE;
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - RELEASE CHANNEL ch00;
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - }
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - End of Recovery Manager input.
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - Start of Recovery Manager output.
02/19/2020 02:10:25 - Info bphdb (pid=4596) INF - Recovery Manager: Release 11.2.0.2.0 - Production on Wed Feb 19 02:18:55 2020
02/19/2020 02:10:26 - Info bphdb (pid=4596) INF - connected to target database: RTGSGEN2 (DBID=3582668555)
02/19/2020 02:10:26 - Info bphdb (pid=4596) INF - using target database control file instead of recovery catalog
02/19/2020 02:10:27 - Info bphdb (pid=4596) INF - allocated channel: ch00
02/19/2020 02:10:27 - Info bphdb (pid=4596) INF - channel ch00: SID=141 device type=SBT_TAPE
02/19/2020 02:10:28 - Info bphdb (pid=4596) INF - file E:\DATA\RTGSGEN2\DATAFILES\OPER.DBF cannot be proxy backed up
02/19/2020 02:10:28 - Info bphdb (pid=4596) INF - current control file cannot be backed up by proxy.
02/19/2020 02:10:28 - Info bphdb (pid=4596) INF - channel ch00: starting incremental level 0 proxy datafile backup at 19-FEB-20
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - released channel: ch00
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - RMAN-00571: ===========================================================
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - RMAN-00571: ===========================================================
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - RMAN-03009: failure of backup command on ch00 channel at 02/19/2020 02:19:08
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - ORA-27196: skgfpbk: sbtpcbackup returned error
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - ORA-19511: Error received from media manager layer, error text:
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - VxBSACreateObject: Failed with error:
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - No object matched the specified predicate.
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - Recovery Manager complete.
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - End of Recovery Manager output.
02/19/2020 02:10:37 - Info bphdb (pid=4596) INF - End Oracle Recovery Manager.
02/19/2020 02:10:38 - Error bpbrm (pid=176250) from client XXXX: ERR - failed executing command <"C:\Program Files\Veritas\NetBackup\bin\bpdbsbora.exe" -enhbackup -L "BRMJBD592" -rw -i "C:\Program Files\Veritas\NetBackup\Logs\user_ops\dbext\logs\input.4596.0.0219120.021854" -jobid 275518>
02/19/2020 02:10:38 - Error bpbrm (pid=176250) from client XXXX: ERR - exit status: <1>
02/19/2020 02:10:38 - Error bpbrm (pid=176250) from client XXXX: ERR - bphdb exit status = 6: the backup failed to back up the requested files
02/19/2020 02:10:39 - Info bphdb (pid=4596) done. status: 6: the backup failed to back up the requested files
02/19/2020 02:10:39 - end writing
the backup failed to back up the requested files (6)

Actually this client has been backed up using nbu on our DC, and when I changed the backup process using NBU in DR, it give me error.

2 REPLIES 2

Nicolai
Moderator
Moderator
Partner    VIP   

" No object matched the specified predicate" usually mean Netbackup was asked for something but couldn't find it.

With VERBOSE = 5 re-run the operation and take a closer look in the bpbdb debug catalog. If bphdb catalog doesn't exist in [install_path]/netbackup/logs/ create it.

Also look out for speical letter in client names, typical the result of a typo error.

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@Taufan_MTG 

Are you really on NBU 7.6?
And using Oracle on Windows 10?
I have just checked the 7.6 DB SCL - Windows 10 is not supported for Oracle agent. 

About the failing job -
Please help us to understand the reference to PROXY?

file E:\DATA\RTGSGEN2\DATAFILES\OPER.DBF cannot be proxy backed up Info bphdb (pid=4596)
INF - current control file cannot be backed up by proxy.

How is the OIP or script configured? 

About this:

Actually this client has been backed up using nbu on our DC, and when I changed the backup process using NBU in DR, it give me error.

Is DR a different master? 
What have you done to change master server on Oracle Client?

I have once assisted a customer to change a Windows Oracle client to a new master - 
Although everything was updated on NBU side, we found that there was still a connection attempt to the previous master. 
Oracle had to be restarted on the Win server for changes to take effect. 
(I know it does not make sence, but nothing else worked.)