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