cancel
Showing results for 
Search instead for 
Did you mean: 

Status 6 error while Oracle XML export policy

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited

 

Environment
 
Netbackup Server = 7.1
Netbackup Client version = 7.1
Product = Oracle11g r2
Product OS = RHEL 5.6
 
Problem
While taking the backup of XML export the below error has been faced. Full/Inc and Cumulative backup are performed successfully.
 
 
Activity Monitor
 
 
6/6/2011 4:19:04 PM - Info nbjm(pid=3392) starting backup job (jobid=3787) for client oracle-nbu, policy Zahid-Oracle_XMLexport, schedule Oracle  
6/6/2011 4:19:04 PM - Info nbjm(pid=3392) requesting MEDIA_SERVER_WITH_ATTRIBUTES resources from RB for backup job (jobid=3787, request id:{74020467-B4A8-44A8-BD64-33BBB8A7AA90})  
6/6/2011 4:19:04 PM - requesting resource Zahid_Oracle_Testpolicy
6/6/2011 4:19:04 PM - requesting resource tpsbkp.NBU_CLIENT.MAXJOBS.oracle-nbu
6/6/2011 4:19:04 PM - requesting resource tpsbkp.NBU_POLICY.MAXJOBS.Zahid-Oracle_XMLexport
6/6/2011 4:19:04 PM - granted resource tpsbkp.NBU_CLIENT.MAXJOBS.oracle-nbu
6/6/2011 4:19:04 PM - granted resource tpsbkp.NBU_POLICY.MAXJOBS.Zahid-Oracle_XMLexport
6/6/2011 4:19:04 PM - granted resource Zahid_Oracle_Testpolicy
6/6/2011 4:19:05 PM - estimated 0 Kbytes needed
6/6/2011 4:19:05 PM - Info nbjm(pid=3392) started backup job for client oracle-nbu, policy Zahid-Oracle_XMLexport, schedule Oracle on storage unit Zahid_Oracle_Testpolicy
6/6/2011 4:19:05 PM - started process bpbrm (4352)
6/6/2011 4:19:06 PM - Info bpbrm(pid=4352) oracle-nbu is the host to backup data from     
6/6/2011 4:19:06 PM - Info bpbrm(pid=4352) reading file list from client        
6/6/2011 4:19:06 PM - connecting
6/6/2011 4:19:08 PM - Info bpbrm(pid=4352) starting bphdb on client         
6/6/2011 4:19:08 PM - connected; connect time: 00:00:02
6/6/2011 4:19:09 PM - Info bphdb(pid=904) Backup started           
6/6/2011 4:19:09 PM - Info bphdb(pid=904) Processing 3a44424e414d453a6f72636c3a4442484f4d453a2f686f6d652f6f7261636c652f6170702f6f7261636c652f70726f647563742f31312e322e302f6462686f6d655f313a44424e45544e414d453a:DBTEMPLATENAME:Test-XML.tpl           
6/6/2011 4:19:09 PM - Info bphdb(pid=904) Waiting for the child status        
6/6/2011 4:20:01 PM - Error bpbrm(pid=4352) from client oracle-nbu: ERR - Script exited with status = 1 <the requested operation was partially successful>
6/6/2011 4:20:01 PM - Error bpbrm(pid=4352) from client oracle-nbu: ERR - bphdb exit status = 6: the backup failed to back up the requested files
6/6/2011 4:20:02 PM - end writing
the backup failed to back up the requested files(6)
6/6/2011 4:20:07 PM - Info bphdb(pid=904) done. status: 6: the backup failed to back up the requested files 
 
Oracle Policy snapshot
 
6 REPLIES 6

Nicolai
Moderator
Moderator
Partner    VIP   

Look in  bporaexp/bporaexp64  debug log.

From the Readme in /usr/openv/netbackup/logs

 bporaexp
                -command-line program on clients to export Oracle
                 data in XML format
                -communicates with bprd on server
 bporaexp64
                -64-bit command-line program on clients to export Oracle
                 data in XML format
                -communicates with bprd on server

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited

 

[oracle@oracle-nbu bporaexp64]$ cat log.060711
00:04:54.436 [16868] <2> vnet_pbxConnect: pbxConnectEx Succeeded
00:04:54.437 [16868] <2> logconnections: BPRD CONNECT FROM 192.168.253.168.42470 TO 192.168.1.17.1556 fd = 4
00:04:54.583 [16868] <2> vnet_pbxConnect: pbxConnectEx Succeeded
00:04:54.584 [16868] <2> logconnections: BPRD CONNECT FROM 192.168.253.168.54057 TO 192.168.1.17.1556 fd = 4
00:04:54.682 [16868] <16> writeToServer: ERR - send() to server on socket failed: Bad file descriptor (9)
00:04:54.682 [16868] <16> dbc_RemoteWriteFile: ERR - could not write progress status message to the NAME socket
00:04:54.682 [16868] <16> VxBSABeginProgressLogging: ERR - Unable to write to progress file.
00:04:54.682 [16868] <4> OAxbsaTransactionBegin: INF - NB_ORA_SERV = tpsbkp 
00:04:54.682 [16868] <4> OAxbsaTransactionBegin: INF - NB_ORA_CLIENT = oracle_nbu 
00:04:54.682 [16868] <4> OAxbsaTransactionBegin: INF - NB_ORA_POLICY = Zahid-Oracle_XMLexport 
00:04:54.682 [16868] <4> OAxbsaTransactionBegin: INF - NB_ORA_SCHED = Oracle 
00:04:54.682 [16868] <4> OAPrintParameters: INF - HELP=N 
00:04:54.682 [16868] <4> OAPrintParameters: INF - NAME=oracle-nbu-XMLnew 
00:04:54.682 [16868] <4> OAPrintParameters: INF - NB_ORA_CLIENT=oracle_nbu 
00:04:54.683 [16868] <4> OAPrintParameters: INF - NB_ORA_SERV=tpsbkp 
00:04:54.683 [16868] <4> OAPrintParameters: INF - ROW_BUFFER=1000 
00:04:54.683 [16868] <4> OAPrintParameters: INF - TABLES=SYS.NETWORKS, SYS.NETWORKSUPP 
00:04:54.683 [16868] <4> OAPrintParameters: INF - USERID=sys/*******@orcl 
00:04:54.683 [16868] <4> OAPrintParameters: INF - CONSISTENT=N 
00:04:54.683 [16868] <4> OAPrintParameters: INF - NB_ORA_POLICY=Zahid-Oracle_XMLexport 
00:04:54.683 [16868] <4> OAPrintParameters: INF - NB_ORA_SCHED=Oracle 
00:04:54.683 [16868] <4> OAPrintParameters: INF - OWNER=HR 
00:04:54.683 [16868] <4> OAPrintParameters: INF - VIEWS=Y 
00:04:54.683 [16868] <4> OAPrintParameters: INF - PARTITIONS=Y 
00:04:54.683 [16868] <4> OAOraConnectDatabase: INF - ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1 
00:04:54.976 [16868] <16> OAOraConnectDatabase: ERR - status = OCI_ERROR 
00:04:54.976 [16868] <16> OAOraConnectDatabase: ERR - ERROR CODE = 28009 ORA-28009: connection as SYS should be as SYSDBA or SYSOPER   
00:04:54.976 [16868] <16> bporaexp64: ERR - Database Archiver terminated with errors. 
00:04:54.976 [16868] <2> bporaexp64: INF - Exiting bporaexp64, status=<6>
00:04:54.976 [16868] <2> OAxbsaTransactionEnd: INF - Entering OAxbsaTransactionEnd
00:04:54.977 [16868] <2> OAxbsaTransactionEnd: INF - Exiting OAxbsaTransactionEnd, status=<0>
[oracle@oracle-nbu bporaexp64]$ 

Nicolai
Moderator
Moderator
Partner    VIP   

These are fatal errors:

My bet would be this one:

OAOraConnectDatabase: ERR - ERROR CODE = 28009 ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

You are connecting as sys:

- USERID=sys/*******@orcl

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited

Where I do correct ? while creating the templete do I mention any specific user ?

Nicolai
Moderator
Moderator
Partner    VIP   

Sorry, I don't know - I have never used the XML exporter.

Zahid_Haseeb
Moderator
Moderator
Partner    VIP    Accredited

(snaps as an exmaple of howto create templete is attached for your reference  )

 

Second thanks i can take the export backup of tables of particular users which I created.(Solved)

Third I am not able to see the tables of any user which I created myself (but able to take the backup if I just select the user from the top + sign which select all tables although they are not able to shown) BUT able to see the default users tables in the BAR USER like HR user tables