Oracle policy failed

[aitallal]

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.

[Yasuhisa_Ishika]

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

[pikachu]

It looks like the job failed right away.

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

[aitallal]

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.

[aitallal]

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]

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 

[aitallal]

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_Ander]

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 · Accepted solution]

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.

[aitallal]

Hi,

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

Best regards,