12-20-2016 01:13 AM
I am getting this error from last thurday. It is happining on all my production database. I do not know if it is netbakup side or sap side that the problem is.
Using Instances for backup
12/20/2016 06:42:47 - Info nbjm (pid=22718) starting backup job (jobid=467716) for client sapp1zdb03-ibvip.prasa.com, policy sapp1-RP1-DB-RMAN, schedule Full-Daily
12/20/2016 06:42:47 - Info nbjm (pid=22718) requesting MEDIA_SERVER_ONLY resources from RB for backup job (jobid=467716, request id:{C1321638-C66E-11E6-BCB4-0010E05C118E})
12/20/2016 06:42:47 - requesting resource ZFSHC_bck_source
12/20/2016 06:42:47 - requesting resource prasaerpbck01.prasa.com.NBU_POLICY.MAXJOBS.sapp1-RP1-DB-RMAN
12/20/2016 06:42:47 - granted resource prasaerpbck01.prasa.com.NBU_POLICY.MAXJOBS.sapp1-RP1-DB-RMAN
12/20/2016 06:42:48 - estimated 0 kbytes needed
12/20/2016 06:42:48 - Info nbjm (pid=22718) started backup (backupid=sapp1zdb03-ibvip.prasa.com_1482208968) job for client sapp1zdb03-ibvip.prasa.com, policy sapp1-RP1-DB-RMAN, schedule Full-Daily on storage unit
12/20/2016 06:42:48 - started process bpbrm (pid=13855)
12/20/2016 06:42:49 - Info bpbrm (pid=13855) sapp1zdb03-ibvip.prasa.com is the host to backup data from
12/20/2016 06:42:49 - Info bpbrm (pid=13855) reading file list for client
12/20/2016 06:42:49 - connecting
12/20/2016 06:42:50 - Info bpbrm (pid=13855) starting bphdb on client
12/20/2016 06:42:50 - Info bphdb (pid=28663) Backup started
12/20/2016 06:42:50 - Info bphdb (pid=28663) Waiting for the child status
12/20/2016 06:42:50 - connected; connect time: 0:00:00
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - ************************************************************
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Backup Information:
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Client: sapp1zdb03-ibvip.prasa.com
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - ORACLE_SID: RP12
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - ORACLE_HOME: /oracle/RP1/112
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Online (Hot) Stream backup requested
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Objects being backed up:
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Whole Database
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Archive Logs
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Control File
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Number of channels to allocate (database): 4
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Number of channels to allocate (archive logs): 4
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - OS Authentication is being used
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - A Recovery Catalog is being used
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - RMAN Default Limits will be used (Database)
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - RMAN Default Limits will be used (Archive Logs)
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Backup File Name Formats:
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Database: bk_d%d_u%u_s%s_p%p_t%t
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Archive Log: arch_d%d_u%u_s%s_p%p_t%t
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - Control File: ctrl_d%d_u%u_s%s_p%p_t%t
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - End of Backup Information
12/20/2016 06:42:51 - Info bphdb (pid=28663) INF - ************************************************************
12/20/2016 06:42:53 - Error bpbrm (pid=13855) from client sapp1zdb03-ibvip.prasa.com: ERR - Script exited with status = 1 <the requested operation was partially successful>
12/20/2016 06:42:53 - Error bpbrm (pid=13855) from client sapp1zdb03-ibvip.prasa.com: ERR - bphdb exit status = 6: the backup failed to back up the requested files
12/20/2016 06:42:53 - Info bphdb (pid=28663) done. status: 6: the backup failed to back up the requested files
12/20/2016 06:42:53 - end writing
the backup failed to back up the requested files (6)
12-20-2016 02:09 AM
I think i have found the problem
ERR - Unable to connect to IP12. Error Code = 28,001: ORA-28001: the password has expired
Error while checking the database state
ERR - Unable to connect to SP12. Error Code = 28,001: ORA-28001: the password has expired
Will give this to the person working with Unix system
12-20-2016 08:32 PM
Hi Hendrik,
Was the issue resolved?
Please reply so other might know for future reference.
12-20-2016 09:49 PM
Still waitng for the unix person to fixed this.
12-20-2016 10:34 PM
Please tell us in which log you found the password expire error.
The fact that you managed to identify the problem and the cause is 99% of solving it.
12-21-2016 06:04 AM
Hi,
I think this log get in script output file and bphdb stderr log file.
Thanks & Regards,