10-28-2011 03:43 AM
Hi,
After our second installation of Oracle Server, the Oracle policy give these problems,
any idea ? thanks
28 oct. 2011 10:35:10 - Info nbjm (pid=7389) starting backup job (jobid=1335) for client prod.oracle.imist.ma, policy Oracle_policy, schedule Full
28 oct. 2011 10:35:10 - Info nbjm (pid=7389) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=1335, request id:{8303FB1C-0150-11E1-86F7-AEB73F0A4FA5})
28 oct. 2011 10:35:10 - requesting resource Any
28 oct. 2011 10:35:10 - requesting resource netbackup.imist.ma.NBU_CLIENT.MAXJOBS.prod.oracle.imist.ma
28 oct. 2011 10:35:10 - requesting resource netbackup.imist.ma.NBU_POLICY.MAXJOBS.Oracle_policy
28 oct. 2011 10:35:10 - granted resource netbackup.imist.ma.NBU_CLIENT.MAXJOBS.prod.oracle.imist.ma
28 oct. 2011 10:35:10 - granted resource netbackup.imist.ma.NBU_POLICY.MAXJOBS.Oracle_policy
28 oct. 2011 10:35:10 - granted resource netbackup-hcart3-robot-tld-0
28 oct. 2011 10:35:10 - estimated 0 kbytes needed
28 oct. 2011 10:35:10 - Info nbjm (pid=7389) started backup job for client prod.oracle.imist.ma, policy Oracle_policy, schedule Full on storage unit netbackup-hcart3-robot-tld-0
28 oct. 2011 10:35:10 - started process bpbrm (pid=1669)
28 oct. 2011 10:35:11 - Info bpbrm (pid=1669) prod.oracle.imist.ma is the host to backup data from
28 oct. 2011 10:35:11 - Info bpbrm (pid=1669) reading file list from client
28 oct. 2011 10:35:11 - Info bpbrm (pid=1669) starting bphdb on client
28 oct. 2011 10:35:11 - Info bphdb (pid=3213) Backup started
28 oct. 2011 10:35:11 - Info bphdb (pid=3213) Processing 3a44424e414d453a756e69633a4442484f4d453a2f6f7261636c652f6f7261313067323031303a44424e45544e414d453a:DBTEMPLATENAME:template.tpl
28 oct. 2011 10:35:11 - Info bphdb (pid=3213) Waiting for the child status
28 oct. 2011 10:35:11 - connecting
28 oct. 2011 10:35:11 - connected; connect time: 0:00:00
28 oct. 2011 10:35:12 - Error bpbrm (pid=1669) from client prod.oracle.imist.ma: ERR - bphdb exit status = 6: the backup failed to back up the requested files
28 oct. 2011 10:35:12 - Info bphdb (pid=3213) done. status: 6: the backup failed to back up the requested files
28 oct. 2011 10:35:12 - end writing
the backup failed to back up the requested files (6)
Solved! Go to Solution.
11-01-2011 07:58 AM
I delete all templates and create one in client, and configured it in policy inside server.
Afrer restarting the master server, the Full backup run without problems.
Than kyou for help.
Best Regards.
10-28-2011 06:28 AM
Please list all relevant info:
NBU version on Client and Server
OS on Server and client
Oracle version
Steps performed on server and client before backup was attempted.
Status 6 normally means a failure on the Oracle side.
Create dbclient log folder on the client and post dbclient log as well as RMAN output after next failure.
If Unix client, remember to 'chmod 777 dbclient'.
10-28-2011 07:51 AM
NBU version 7.1 on Server
NBU version 7.1 on Client
OS is Linux Redhat 5.2 64bit on Server and Client
Oracle version is : Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
10-28-2011 08:03 AM
Your DBA needs to review RMAN .out file for details on the Oracle side
10-28-2011 08:10 AM
How can i redirect RMAN .out to dbclient log ?
10-28-2011 08:15 AM
RMAN is Oracle and dbclient is NetBackup. Best to keep things simple & separate IMO.
10-28-2011 08:31 AM
Please haw can do this "post dbclient log as well as RMAN output"
Thanks
10-28-2011 10:56 AM
Please download this manual: NBU for Oracle Admin Guide for UNIX, Windows, and Linux http://www.symantec.com/docs/DOC3672
Start by going through the initial linking and configuration steps and see if all the nessary steps were followed in your environment.
The manual also covers the RMAN backup scripts. You Oracle DBA should've created his own script(s)or modified the NBU samples. (The manual will tell you where these sample scripts are located).
The RMAN script will send it's output to a file. This should be hard-coded in the script. We are looking for this file (RMAN output).
From NBU point of view, the dbclient log will be needed. The Troubleshooting section of this manual explains this.
Create the dbclient folder under /usr/openv/netbackup/logs, followed by 'chmod 777 dbclient' so that the oracle user can write to the folder.
10-29-2011 02:58 PM
Error Message continued
<4> bphdb: INF - EXIT STATUS 6: the backup failed to back up the requested files
<16> bphdb: ERR - Script exited with status = 29
Please note
/usr/openv/nebackup/ext/scripts/ORACLEBACK_SCRIPT_NAME.sh in the exact error message is the default where NetBackup puts the.sh file, this may not be the exact place the script will be located, check with the System Administrator/DBA of the Server.
ORACLEBACK_SCRIPT_NAME.sh is a sample name, the actual script name will be dependent upon Administrator/DBA in charge.
bphdb shows "file not found" message.
Check permissions on the script to ensure they are "owner oracle group dba rwxr-xr-x"
Note:
This has been seen on Solaris platforms but may apply to other UNIX platforms too.
The Exit status in Job Monitor fails with a Status 6, however, the ACTUAL exit code for the bphdb process is Status 29 which actually provides the pointer to what is wrong (e.g. "Failed trying to exec a command"). Changing the permissions on the script then enables the command to execute, therefore avoids the resulting Status 6: Failed to backup requested files, which is the final exit code that will be seen if the permissions on the script are incorrect.
10-31-2011 03:41 AM
10-31-2011 04:01 AM
Did you run oracle_link as per the steps in the manual?
10-31-2011 04:40 AM
Because i reinstall Oracle, i forgot to launch oracle_link, but after this solution, in found some problems :
the schedule Default-Application-Backup run without problems, but the Full backup return somme problems like :
31 oct. 2011 11:35:38 - Info bpbrm (pid=27665) prod.oracle.imist.ma is the host to backup data from
31 oct. 2011 11:35:38 - Info bpbrm (pid=27665) reading file list from client
31 oct. 2011 11:35:38 - Info nbjm (pid=7389) starting backup job (jobid=1395) for client prod.oracle.imist.ma, policy Oracle_policy, schedule Full
31 oct. 2011 11:35:38 - Info nbjm (pid=7389) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=1395, request id:{74863ADA-03B4-11E1-8F86-4A28411441BF})
31 oct. 2011 11:35:38 - requesting resource Any
31 oct. 2011 11:35:38 - requesting resource netbackup.imist.ma.NBU_CLIENT.MAXJOBS.prod.oracle.imist.ma
31 oct. 2011 11:35:38 - requesting resource netbackup.imist.ma.NBU_POLICY.MAXJOBS.Oracle_policy
31 oct. 2011 11:35:38 - granted resource netbackup.imist.ma.NBU_CLIENT.MAXJOBS.prod.oracle.imist.ma
31 oct. 2011 11:35:38 - granted resource netbackup.imist.ma.NBU_POLICY.MAXJOBS.Oracle_policy
31 oct. 2011 11:35:38 - granted resource netbackup-hcart3-robot-tld-0
31 oct. 2011 11:35:38 - estimated 0 kbytes needed
31 oct. 2011 11:35:38 - Info nbjm (pid=7389) started backup job for client prod.oracle.imist.ma, policy Oracle_policy, schedule Full on storage unit netbackup-hcart3-robot-tld-0
31 oct. 2011 11:35:38 - started process bpbrm (pid=27665)
31 oct. 2011 11:35:38 - connecting
31 oct. 2011 11:35:39 - Info bpbrm (pid=27665) starting bphdb on client
31 oct. 2011 11:35:39 - Info bphdb (pid=19392) Backup started
31 oct. 2011 11:35:39 - Info bphdb (pid=19392) Processing 3a44424e414d453a756e69633a4442484f4d453a2f6f7261636c652f6f7261313067323031303a44424e45544e414d453a:DBTEMPLATENAME:production_template.tpl
31 oct. 2011 11:35:39 - Info bphdb (pid=19392) Waiting for the child status
31 oct. 2011 11:35:39 - connected; connect time: 0:00:00
31 oct. 2011 11:35:40 - Error bpbrm (pid=27665) from client prod.oracle.imist.ma: ERR - bphdb exit status = 6: the backup failed to back up the requested files
31 oct. 2011 11:35:40 - Info bphdb (pid=19392) done. status: 6: the backup failed to back up the requested files
31 oct. 2011 11:35:40 - end writing
the backup failed to back up the requested files (6)
10-31-2011 07:24 AM
Please clarify this statement?
"the schedule Default-Application-Backup run without problems, but the Full backup return somme problems"
Your policy needs 2 Schedules: Application Backup and automatic backup.
"Full" is automatic backup and does not actually perform the backup. It determines when to start the backup and contains a backup window during which the schedule can start..
Once the script starts running on the client, it starts the actual backup which will then start the child backups. These child backups will always be Application Backup schedule. This default backup window for this schedule is normally 24 x 7.
If NB_ORA_SCHED is specified in the script, the schedule MUST be of type Application Backup.
Details about the different schedule types in the manual.
Please post all of the following:
your policy config : on master, run:
bppllist <policy-name> -U
The backup script.
The RMAN output.
the dbclient log.
10-31-2011 07:58 AM
In side of client, i can run backup from "Bachup, Archiv and Restore" without problems, but whene i start Automatic Backup "Full" in mode Manual Backup the system return :
------------------------------------------------------------------------------------------------------------------
31 oct. 2011 11:35:38 - Info bpbrm (pid=27665) prod.oracle.imist.ma is the host to backup data from
31 oct. 2011 11:35:38 - Info bpbrm (pid=27665) reading file list from client
31 oct. 2011 11:35:38 - Info nbjm (pid=7389) starting backup job (jobid=1395) for client prod.oracle.imist.ma, policy Oracle_policy, schedule Full
31 oct. 2011 11:35:38 - Info nbjm (pid=7389) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=1395, request id:{74863ADA-03B4-11E1-8F86-4A28411441BF})
31 oct. 2011 11:35:38 - requesting resource Any
31 oct. 2011 11:35:38 - requesting resource netbackup.imist.ma.NBU_CLIENT.MAXJOBS.prod.oracle.imist.ma
31 oct. 2011 11:35:38 - requesting resource netbackup.imist.ma.NBU_POLICY.MAXJOBS.Oracle_policy
31 oct. 2011 11:35:38 - granted resource netbackup.imist.ma.NBU_CLIENT.MAXJOBS.prod.oracle.imist.ma
31 oct. 2011 11:35:38 - granted resource netbackup.imist.ma.NBU_POLICY.MAXJOBS.Oracle_policy
31 oct. 2011 11:35:38 - granted resource netbackup-hcart3-robot-tld-0
31 oct. 2011 11:35:38 - estimated 0 kbytes needed
31 oct. 2011 11:35:38 - Info nbjm (pid=7389) started backup job for client prod.oracle.imist.ma, policy Oracle_policy, schedule Full on storage unit netbackup-hcart3-robot-tld-0
31 oct. 2011 11:35:38 - started process bpbrm (pid=27665)
31 oct. 2011 11:35:38 - connecting
31 oct. 2011 11:35:39 - Info bpbrm (pid=27665) starting bphdb on client
31 oct. 2011 11:35:39 - Info bphdb (pid=19392) Backup started
31 oct. 2011 11:35:39 - Info bphdb (pid=19392) Processing 3a44424e414d453a756e69633a4442484f4d453a2f6f7261636c652f6f7261313067323031303a44424e45544e414d453a:DBTEMPLATENAME:production_template.tpl
31 oct. 2011 11:35:39 - Info bphdb (pid=19392) Waiting for the child status
31 oct. 2011 11:35:39 - connected; connect time: 0:00:00
31 oct. 2011 11:35:40 - Error bpbrm (pid=27665) from client prod.oracle.imist.ma: ERR - bphdb exit status = 6: the backup failed to back up the requested files
31 oct. 2011 11:35:40 - Info bphdb (pid=19392) done. status: 6: the backup failed to back up the requested files
31 oct. 2011 11:35:40 - end writing
the backup failed to back up the requested files (6)
--------------------------------------------------------------------------------------------------------------------------
bppllist : on master, this command not existe
backup script : Netbackup 7.1
the dbclient :
**************************************************************************************************
11:34:38.153 [18909] <2> vnet_cached_getaddrinfo_and_update: ../../libvlibs/vnet_addrinfo.c.1371: 0: found in cache service: NULL
11:34:38.153 [18909] <2> logconnections: BPRD CONNECT FROM 172.16.0.5.10997 TO 172.16.0.11.1556 fd = 72
11:34:38.153 [18909] <2> vnet_check_vxss_client_magic_with_info: ../../libvlibs/vnet_vxss_helper.c.833: 0: VxSS not supported: 0 0x00000000
11:34:38.216 [18909] <4> dbc_GetMediaListByName: Media ID : <0000L3>
11:34:38.216 [18909] <4> dbc_GetMediaListByName: File Creation Date and Time : <1320060867>
11:34:38.216 [18909] <4> dbc_GetMediaListByName: File Expiration Date and Time: <1321270467>
11:34:38.216 [18909] <4> dbc_GetMediaListByName: Comment : <Backup ID : prod.oracle.imist.ma_1320060867>
11:34:38.216 [18909] <4> dbc_GetMediaListByName: Keyword : <unic>
11:34:38.216 [18909] <4> VxBSAQueryObject: INF - Object </ctrl_u06mqfp20_s6_p1_t765977664> was found on media <0000L3>.
11:34:38.216 [18909] <2> xbsa_QueryObject: INF - leaving (0)
11:34:38.216 [18909] <2> int_FindBackupImage: INF - XBSA Creation Date and Time : <1320060867>
11:34:38.216 [18909] <2> xbsa_EndTransaction: INF - entering
11:34:38.216 [18909] <4> VxBSAEndTxn: INF - entering VxBSAEndTxn.
11:34:38.216 [18909] <4> VxBSAEndTxn: INF - Transaction being COMMITED.
11:34:38.216 [18909] <4> VxBSAGetEnv: INF - entering GetEnv - NBBSA_LOG_DIRECTORY
11:34:38.216 [18909] <4> VxBSAGetEnv: INF - returning - dbclient
11:34:38.216 [18909] <4> VxBSAEndTxn: INF - Cleaning directory: </usr/openv/netbackup/logs/dbclient>
11:34:38.216 [18909] <4> delete_old_files: entering delete_old_files.
11:34:38.216 [18909] <2> xbsa_EndTransaction: INF - leaving (0)
11:34:38.216 [18909] <2> int_FindBackupImage: INF - leaving
11:34:38.216 [18909] <2> int_SetImageInfoArray: INF - entering
11:34:38.216 [18909] <2> int_SaveBackupPiece: INF - entering
11:34:38.216 [18909] <2> int_SaveBackupPiece: INF - leaving
11:34:38.216 [18909] <2> int_SetImageInfoArray: INF - leaving
11:34:38.216 [18909] <2> int_GetImageInfo2: INF - leaving
11:34:38.216 [18909] <2> int_DumpSbtInfo: INF - entering
11:34:38.216 [18909] <2> int_DumpSbtInfo: INF - Media Information for Backup File : <ctrl_u06mqfp20_s6_p1_t765977664>
11:34:38.216 [18909] <2> int_DumpSbtInfo: INF - Media Sharing Mode : <Multiple Concurrent Users>
11:34:38.216 [18909] <2> int_DumpSbtInfo: INF - File Ordering Mode : <Sequential file access>
11:34:38.216 [18909] <2> int_DumpSbtInfo: INF - Media ID : <0000L3>
11:34:38.216 [18909] <2> int_DumpSbtInfo: INF - File Creation Date and Time : <1320060867>
11:34:38.216 [18909] <2> int_DumpSbtInfo: INF - File Expiration Date and Time : <1321270467>
11:34:38.216 [18909] <2> int_DumpSbtInfo: INF - Comment : <Backup ID : prod.oracle.imist.ma_1320060867>
11:34:38.217 [18909] <2> int_DumpSbtInfo: INF - File Creation Method : <Stream>
11:34:38.217 [18909] <2> int_DumpSbtInfo: INF - leaving
11:34:38.217 [18909] <2> sbtinfo2: INF - leaving
11:34:39.268 [18909] <2> sbtend: INF - entering
11:34:39.268 [18909] <2> int_PerformMetadataCataloging: INF - entering
11:34:39.268 [18909] <2> int_PerformMetadataCataloging: INF - freeing node for backup piece <ctrl_u06mqfp20_s6_p1_t765977664>
11:34:39.268 [18909] <2> int_PerformMetadataCataloging: INF - leaving - Not Configured for Metadata cataloging
11:34:39.268 [18909] <2> int_CleanupThreadSafeStorage: INF - entering
11:34:39.268 [18909] <2> int_CleanupThreadSafeStorage: INF - leaving
11:34:39.268 [18909] <2> int_CleanupInfo2: INF - entering
11:34:39.268 [18909] <2> int_CleanupInfo2: INF - leaving
11:34:39.268 [18909] <4> sbtend: INF - --- END of SESSION ---
11:34:39.268 [18909] <2> sbtend: INF - leaving
11:34:39.268 [18909] <4> VxBSATerminate: INF - entering VxBSATerminate.
11:34:39.268 [18909] <4> VxBSAGetEnv: INF - entering GetEnv - NBBSA_DEBUGFD
11:34:39.268 [18909] <4> VxBSAGetEnv: INF - returning -
10-31-2011 08:18 AM
The Full backup needs to start the script on the client. The script needs to be able to run as root and include "su - <oracle-user> .... " so that actual rman command can run as oracle user with all oracle environment variables.
"bppllist : on master, this command not exist"
It DOES! Did you try to 'find' it?
/usr/openv/netbackup/bin/admincmd/bppllist -U
"backup script : Netbackup 7.1"
PLEASE post the actual backup script.
10-31-2011 08:54 AM
I don't know where i can find The backup script, and his name in client !!!
But the result of "/usr/openv/netbackup/bin/admincmd/bppllist Oracle_policy -U" is
Policy Name: Oracle_policy
Policy Type: Oracle
Active: yes
Effective date: 08/25/2011 14:16:06
Block Incremental: no
Mult. Data Streams: no
Client Encrypt: no
Checkpoint: no
Policy Priority: 0
Max Jobs/Policy: 1
Disaster Recovery: 0
Collect BMR info: no
Residence: (specific storage unit not required)
Volume Pool: NetBackup
Server Group: *ANY*
Keyword: (none specified)
Data Classification: -
Residence is Storage Lifecycle Policy: no
Application Discovery: no
Discovery Lifetime: 0 seconds
Granular Restore Info: no
Ignore Client Direct: no
HW/OS/Client: Linux RedHat2.6 prod.oracle.imist.ma
Include: production_template.tpl
Schedule: Full
Type: Automatic Full Backup
Frequency: every 7 days
Maximum MPX: 1
Synthetic: 0
PFI Recovery: 0
Retention Level: 5 (3 months)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Sunday 18:00:00 --> Monday 05:00:00
Monday 18:00:00 --> Tuesday 05:00:00
Tuesday 18:00:00 --> Wednesday 05:00:00
Wednesday 18:00:00 --> Thursday 05:00:00
Thursday 18:00:00 --> Friday 05:00:00
Friday 18:00:00 --> Saturday 05:00:00
Saturday 18:00:00 --> Sunday 05:00:00
Schedule: Differential-Inc
Type: Differential Incremental Backup
Frequency: every 1 day
Maximum MPX: 1
Synthetic: 0
PFI Recovery: 0
Retention Level: 3 (1 month)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Sunday 18:00:00 --> Monday 05:00:00
Monday 18:00:00 --> Tuesday 05:00:00
Tuesday 18:00:00 --> Wednesday 05:00:00
Wednesday 18:00:00 --> Thursday 05:00:00
Thursday 18:00:00 --> Friday 05:00:00
Friday 18:00:00 --> Saturday 05:00:00
Saturday 18:00:00 --> Sunday 05:00:00
Schedule: Default-Application-Backup
Type: Application Backup
Maximum MPX: 1
Synthetic: 0
PFI Recovery: 0
Retention Level: 1 (2 weeks)
Number Copies: 1
Fail on Error: 0
Residence: (specific storage unit not required)
Volume Pool: (same as policy volume pool)
Server Group: (same as specified for policy)
Residence is Storage Lifecycle Policy: 0
Daily Windows:
Sunday 00:00:00 --> Saturday 23:59:59
10-31-2011 09:22 AM
Policy is referencing a template instead of a script. Does it exist on the Master server?
Also the dbclient log provided shows no errors. Plese check for lines containing <8> or <16>
11-01-2011 03:32 AM
I create bphdb logs directory at client side, i have thoses problems :
10:27:45.008 [2540] <4> bphdb sync_server: INF - BACKUP START 2540
10:27:45.009 [2540] <4> bphdb sync_server: INF - CONTINUE BACKUP message received
10:27:45.009 [2540] <2> bphdb get_filelist: INF - Read filename: <3a44424e414d453a756e69633a4442484f4d453a2f6f7261636c652f6f7261313067323031303a44424e45544e414d453a756e6963:DBTEMPLATENAME:template1.tpl>
10:27:45.009 [2540] <2> bphdb get_filelist: INF - Read filename: <CONTINUE>
10:27:45.009 [2540] <4> bphdb do_backup: INF - Processing 3a44424e414d453a756e69633a4442484f4d453a2f6f7261636c652f6f7261313067323031303a44424e45544e414d453a756e6963:DBTEMPLATENAME:template1.tpl
10:27:45.009 [2540] <4> bphdb do_backup: INF - Waiting for the child status
10:27:45.009 [2541] <4> check_for_valid_database: INF - Database validation buffer = :DBNAME:unic:DBHOME:/oracle/ora10g2010:DBNETNAME:unic
10:27:45.012 [2541] <4> check_for_valid_database: INF - DBNAME=unic DBHOME=/oracle/ora10g2010 DBNETNAME=unic DBTEMPLATENAME=template1.tpl
10:27:45.198 [2541] <4> isUbsValidDatabaseW: INF - Objectinfo from ubs, DBNAME=unic and DBHOME=/oracle/ora10gR2
10:27:45.199 [2541] <4> bphdb do_backup: INF - Template not valid on client: template1.tpl
10:27:45.199 [2541] <4> bphdb Exit: INF - EXIT STATUS 69: invalid filelist specification
10:27:46.011 [2540] <8> delete_old_files: WRN - Directory /usr/openv/netbackup/logs/bpdbsbora does not exist
10:27:46.011 [2540] <8> delete_old_files: WRN - Directory /usr/openv/netbackup/logs/bpubsora does not exist
10:27:46.011 [2540] <16> bphdb Exit: ERR - bphdb exit status = 6: the backup failed to back up the requested files
10:27:46.011 [2540] <4> bphdb Exit: INF - EXIT STATUS 6: the backup failed to back up the requested files
11-01-2011 04:24 AM
Please start from the beginning and tell us step-by-step how and where you configured the template and what the correct template name should be.
Your policy has the following in backup selection: production_template.tpl
bphdb is looking for template1.tpl
How many templates did you create? Where were they created?
How many policies exist for this client?
11-01-2011 07:58 AM
I delete all templates and create one in client, and configured it in policy inside server.
Afrer restarting the master server, the Full backup run without problems.
Than kyou for help.
Best Regards.