Video Screencast Help

Oracle policy failed

Created: 05 Sep 2011 • Updated: 09 Sep 2011 | 9 comments
This issue has been solved. See solution.

Hi,

I use Oracle 10g and Netbackup 7.1 on Linux Redhat 5.2 64bit servers.

After executing Oracle_policy, i had some errors :

 

5 sept. 2011 14:52:04 - Info nbjm (pid=9368) starting backup job (jobid=230) for client prod.oracle.imist.ma, policy Oracle_policy, schedule Differential-Inc
5 sept. 2011 14:52:04 - Info nbjm (pid=9368) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=230, request id:{9ED5752E-D7CE-11E0-B3F2-92639A107E18})
5 sept. 2011 14:52:04 - requesting resource Any
5 sept. 2011 14:52:04 - requesting resource netbackup.NBU_CLIENT.MAXJOBS.prod.oracle.imist.ma
5 sept. 2011 14:52:04 - requesting resource netbackup.NBU_POLICY.MAXJOBS.Oracle_policy
5 sept. 2011 14:52:04 - granted resource  netbackup.NBU_CLIENT.MAXJOBS.prod.oracle.imist.ma
5 sept. 2011 14:52:04 - granted resource  netbackup.NBU_POLICY.MAXJOBS.Oracle_policy
5 sept. 2011 14:52:04 - granted resource  netbackup-hcart3-robot-tld-0
5 sept. 2011 14:52:05 - Info bpbrm (pid=12915) prod.oracle.imist.ma is the host to backup data from
5 sept. 2011 14:52:05 - Info bpbrm (pid=12915) reading file list from client
5 sept. 2011 14:52:05 - Info bpbrm (pid=12915) starting bphdb on client
5 sept. 2011 14:52:05 - Info bphdb (pid=6833) Backup started
5 sept. 2011 14:52:05 - Info bphdb (pid=6833) Processing 3a44424e414d453a756e69633a4442484f4d453a2f6f7261636c652f6f7261313067323031303a44424e45544e414d453a:DBTEMPLATENAME:production_template.tpl
5 sept. 2011 14:52:05 - Info bphdb (pid=6833) Waiting for the child status
5 sept. 2011 14:52:05 - estimated 0 kbytes needed
5 sept. 2011 14:52:05 - Info nbjm (pid=9368) started backup job for client prod.oracle.imist.ma, policy Oracle_policy, schedule Differential-Inc on storage unit netbackup-hcart3-robot-tld-0
5 sept. 2011 14:52:05 - started process bpbrm (pid=12915)
5 sept. 2011 14:52:05 - connecting
5 sept. 2011 14:52:05 - connected; connect time: 0:00:00
5 sept. 2011 14:52:08 - Error bpbrm (pid=12915) from client prod.oracle.imist.ma: ERR - Script exited with status = 1 <the requested operation was partially successful>
5 sept. 2011 14:52:08 - Error bpbrm (pid=12915) from client prod.oracle.imist.ma: ERR - bphdb exit status = 6: the backup failed to back up the requested files
5 sept. 2011 14:52:08 - Info bphdb (pid=6833) done. status: 6: the backup failed to back up the requested files
5 sept. 2011 14:52:08 - end writing
the backup failed to back up the requested files  (6)

 

 

Thanks.

 

Comments 9 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

Check progress log logged under /usr/openv/netbackup/logs/user_ops/dbext/oracle on the client.

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

aitallal's picture

Hi,

 

the part of progress log in dbext/oracle that have errors is :

 

INF - allocated channel: ch00
INF - channel ch00: starting incremental level 0 datafile backupset
INF - RMAN-03009: failure of backup command on ch00 channel at 09/07/2011 18:19:05
INF - ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
INF - continuing other job steps, job failed will not be re-run
INF - channel ch00: starting incremental level 0 datafile backupset
INF - including current control file in backupset
INF - including current SPFILE in backupset
INF - piece handle=bk_u0emlvg4p_s14_p1_t761249945 tag=TAG20110907T181905 comment=API Version 2.0,MMS Version 5.0.0.0
INF - channel ch00: backup set complete, elapsed time: 00:01:15
INF - released channel: ch00
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: ===========================================================
INF - RMAN-03009: failure of backup command on ch00 channel at 09/07/2011 18:19:05
INF - ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
INF - Recovery Manager complete.
INF - End of Recovery Manager output.

 

 

I found in Internet that i shoud change NOREDOLOG mode to REDOLOG mode;

But now the backup show this error:

 released channel: ch00
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: ===========================================================
INF - RMAN-03009: failure of backup command on ch00 channel at 09/08/2011 12:31:46
INF - ORA-19506: failed to create sequential file, name="bk_u0hmm1g5b_s17_p1_t761315499", parms=""
INF - ORA-27028: skgfqcre: sbtbackup returned error
INF - ORA-19511: Error received from media manager layer, error text:
INF -    VxBSACreateObject: Failed with error:
INF -    Server Status:  operation not allowed during this time period
INF - Recovery Manager complete.
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager.

 

 

pikachu's picture

It looks like the job failed right away.

 

On the client check the dbclient log and see what rman is doing.

Nothing has changed...

aitallal's picture

the part of progress log in dbext/oracle that have errors is :

 

INF - allocated channel: ch00
INF - channel ch00: starting incremental level 0 datafile backupset
INF - RMAN-03009: failure of backup command on ch00 channel at 09/07/2011 18:19:05
INF - ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
INF - continuing other job steps, job failed will not be re-run
INF - channel ch00: starting incremental level 0 datafile backupset
INF - including current control file in backupset
INF - including current SPFILE in backupset
INF - piece handle=bk_u0emlvg4p_s14_p1_t761249945 tag=TAG20110907T181905 comment=API Version 2.0,MMS Version 5.0.0.0
INF - channel ch00: backup set complete, elapsed time: 00:01:15
INF - released channel: ch00
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: ===========================================================
INF - RMAN-03009: failure of backup command on ch00 channel at 09/07/2011 18:19:05
INF - ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
INF - Recovery Manager complete.
INF - End of Recovery Manager output.

 

pikachu's picture

I  just looked up : ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode

http://www.symantec.com/docs/TECH136157 - DOCUMENTATION: How to troubleshoot Oracle backup problems in NetBackup 6.x and 7.x 

Nothing has changed...

aitallal's picture

I found in Internet that i shoud change NOREDOLOG mode to REDOLOG mode;

But now the backup show this error:

 released channel: ch00
INF - RMAN-00571: ===========================================================
INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
INF - RMAN-00571: ===========================================================
INF - RMAN-03009: failure of backup command on ch00 channel at 09/08/2011 12:31:46
INF - ORA-19506: failed to create sequential file, name="bk_u0hmm1g5b_s17_p1_t761315499", parms=""
INF - ORA-27028: skgfqcre: sbtbackup returned error
INF - ORA-19511: Error received from media manager layer, error text:
INF -    VxBSACreateObject: Failed with error:
INF -    Server Status:  operation not allowed during this time period
INF - Recovery Manager complete.
INF - End of Recovery Manager output.
INF - End Oracle Recovery Manager.

Michael G Andersen's picture

The message:

INF -    Server Status:  operation not allowed during this time period

indicates that your Application Backup schedule (the red one) windows does not contain the time in question

Regards

Michael

 

Will Restore's picture

Assume the following:

■ Users perform database backup operations during business hours, 08:00 to 13:00.

■ The automatic backups that use this policy start between 18:00 and 22:00.

In this scenario, the Application Backup schedule must have a start time of 0800

and a duration of 14 hours.

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

SOLUTION
aitallal's picture

Hi,

I would like to thank you a lot of your remplys and your collaboration.

 

Best regards,