Forum Discussion

aitallal's avatar
aitallal
Level 4
14 years ago
Solved

Oracle policy failed

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.

 

  • 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.

  • Check progress log logged under /usr/openv/netbackup/logs/user_ops/dbext/oracle on the client.
  • It looks like the job failed right away.

     

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

  • 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.

     

  • 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.

     

     

  • 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 

  • 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.

  • 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


     

  • 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.

  • Hi,

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

     

    Best regards,