cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Arch/Log status 6

Claudio_Veronez
Level 6
Partner Accredited
Hello,

I 'm trying to run an Archive log Oracle backup,

I got status 6.

RMAN log (executing from the client)

<html><ol>
<li>INF - Begin progress logging for process: (4316)
<li>INF - Starting Oracle Recovery Manager.
<li>INF - Using: /opt/oracle/10.2/bin/rman
<li>INF - Connection info: target 'sys/*****@bgw' nocatalog
<li>INF - Start of Recovery Manager input.
<li>INF - # -----------------------------------------------------------------
<li>INF - # RMAN command section
<li>INF - # -----------------------------------------------------------------
<li>INF - RUN {
<li>INF - # Backup Archived Logs
<li>INF - sql 'alter system archive log current';
<li>INF - ALLOCATE CHANNEL ch00
<li>INF -     TYPE 'SBT_TAPE';
<li>INF - SEND 'NB_ORA_CLIENT=svmmprod-oracle,NB_ORA_POLICY=svmmprod-oracle-arch,NB_ORA_SERV=svbackup';
<li>INF - BACKUP
<li>INF -     FORMAT 'arch-s%s-p%p-t%t'
<li>INF -     ARCHIVELOG
<li>INF -         ALL
<li>INF -     DELETE INPUT;
<li>INF - RELEASE CHANNEL ch00;
<li>INF - # Control file backup
<li>INF - ALLOCATE CHANNEL ch00
<li>INF -     TYPE 'SBT_TAPE';
<li>INF - SEND 'NB_ORA_CLIENT=svmmprod-oracle,NB_ORA_POLICY=svmmprod-oracle-arch,NB_ORA_SERV=svbackup';
<li>INF - BACKUP
<li>INF -     FORMAT 'arch-s%s-p%p-t%t'
<li>INF -     CURRENT CONTROLFILE;
<li>INF - RELEASE CHANNEL ch00;
<li>INF - }
<li>INF - End of Recovery Manager input.
<li>INF - Start of Recovery Manager output.
<li>INF - Recovery Manager: Release 10.2.0.1.0 - Production on Mon Dec 7 14:28:59 2009
<li>INF - RMAN-00571: ===========================================================
<li>INF - RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
<li>INF - RMAN-00571: ===========================================================
<li>INF - ORA-01031: insufficient privileges
<li>INF - Recovery Manager complete.
<li>INF - End of Recovery Manager output.
<li>INF - End Oracle Recovery Manager.
</ol></html>



I have tryed to log w/ SO option and the DB option w/ TNS and stuff?


Any Idea??



1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Did you notice the problem in dbclient log?

17:00:12.451 [1614] <8> VxBSAQueryObject: WARNING - NBBSA_CLIENT_HOST name= <svmmprod-oracle> differs from NBU config name= <svmmprod2>
17:00:12.452 [1614] <2> logconnections: BPRD CONNECT FROM 192.168.20.74.45403 TO 192.168.4.26.13720
17:00:12.486 [1614] <16> VxBSAQueryObject: ERR - dbc_get_string() failed 135
17:00:12.486 [1614] <16> xbsa_QueryObject: ERR - VxBSAQueryObject: Failed with error:
   Server Status:  client is not validated to perform the requested operation

The hostname sent by Rman is svmmprod-oracle
The hostname in the client bp.conf seems to be svmmprod2 
If this a cluster, see this TechNote for more info: http://seer.entsupport.symantec.com/docs/271446.htm


View solution in original post

19 REPLIES 19

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
ORA-01031: insufficient privileges - as which user are you running the backup?
Extract from TechNote How to troubleshoot Oracle backup problems :
If the backup shows an ORA-01031: insufficient privileges error message, remember the account being used for backups must have sysdba rights.

Also have a look at this URL:
http://download.oracle.com/docs/cd/B13789_01/server.101/b10734/rcmtroub.htm
Find the section called: RMAN Denies Logon to Target Database

Claudio_Veronez
Level 6
Partner Accredited
So, I have tryed the backup using the SO login, and the SYS user, both of them I got the same error



Claudio_Veronez
Level 6
Partner Accredited
I have noted that the ARCH and the oracle on line backup

there is 4 jobs, 3 APP and one ARCH,, the arch one I get status 6 althought the others I get status 0

the on line backup, there is a schedule. online and a schedule SUN (that runs a full backup on sundays) the sun police goes fine but the online i get the error 6 and sometimes error 13...


I' m trying the Logs and the links that Marianne sends, If i got the answer I 'll post it here and vote.


rilwan_dawodu
Level 4
Certified
The above output did not show any parameter for the policy that you want to kick off in the backup policy. You will need to specify the 'send 'NB_ORA_SCHED=' parameter in your script.

I beleive there is a schedule created already in NBU for the arch backup in that policy, if not you will need to first create a schedule then specify the above parameter in your script.

Claudio_Veronez
Level 6
Partner Accredited
I 've tried to create a sched and and recreate the template.


the DBA has told me something about the Media manager - RMAN can not connect to that.

I'm very confused, because we have another servers using exactely the same policy, sched, template (changin hosts etc to work of course)



rilwan_dawodu
Level 4
Certified
The shcedule will have to be created from NBU (so this is outside of the client)
The template will be on the client (DB server) and it should be owned by oracle user
You might want to create a script that will call the template (this script will be owned by root)

What do you mean by RMAN cannot connect?
Do you have the sym link to the libobk file created in your oracle lib directory on the client?

If the 3 first lines are in place, confirm from the DBA what is the issue with RMAN connectivity.
When this is resolved I beleive you should be able to run the backup successfully.

let me know how it goes

Claudio_Veronez
Level 6
Partner Accredited
Thanks a Lot

Really


Claudio_Veronez
Level 6
Partner Accredited
I had used the NB wizard at the client to create a template, even running it the same error appeard.


Claudio_Veronez
Level 6
Partner Accredited
Let me see If I'm Right

1)  log in the client  and start the jnbSA
2) go to the backup area
3) select the instance (dont opening the instance because I don't wanna put the password here)
4) N N F (next next finsh)
5) select server name, policy name, and stuff

after that I should create a policy in NB (master server)

type oracle.and select the template that I create to backup.


Am I missing something?


Claudio_Veronez
Level 6
Partner Accredited
----BPHDB

11:13:51.071 [25097] <2> logparams: -sb -rdbms oracle -S svbackup -to 300 -c svmmprod-oracle-arch -s arch -clnt svmmprod-oracle -FULL -kl 28 -b svmmprod-oracle_1260364594 -jobid 352251
11:13:51.072 [25097] <4> bphdb main: INF - setenv NB_ORA_POLICY=svmmprod-oracle-arch
11:13:51.072 [25097] <4> bphdb main: INF - setenv NB_ORA_CLIENT=svmmprod-oracle
11:13:51.072 [25097] <4> bphdb main: INF - setenv NB_ORA_MODE=B
11:13:51.072 [25097] <4> bphdb main: INF - NB_ORA_POLICY=svmmprod-oracle-arch
11:13:51.072 [25097] <4> bphdb main: INF - NB_ORA_SCHED not defined.
11:13:51.072 [25097] <4> bphdb main: INF - NB_ORA_PC_SCHED=arch
11:13:51.072 [25097] <4> bphdb main: INF - NB_ORA_SERV=svbackup
11:13:51.072 [25097] <4> bphdb main: INF - NB_ORA_PC_BTYPE not set
11:13:51.072 [25097] <4> bphdb main: INF - setenv NB_ORA_FULL=1
11:13:51.072 [25097] <4> bphdb main: INF - setenv NB_ORA_INCR=0
11:13:51.072 [25097] <4> bphdb main: INF - setenv NB_ORA_CINC=0
11:13:51.072 [25097] <4> bphdb main: INF - setenv NB_ORA_SCHEDULED=1
11:13:51.073 [25097] <4> bphdb sync_server: INF - BACKUP START
11:13:51.171 [25097] <4> bphdb sync_server: INF - CONTINUE BACKUP message received.
11:13:51.171 [25097] <2> bphdb get_filelist: INF - Read filename: <3a44424e414d453a6267773a4442484f4d453a2f6f70742f6f7261636c652f31302e322f3a44424e45544e414d453a:DBTEMPLATENAME:svmmprod-oracle-arch.tpl>
11:13:51.171 [25097] <2> bphdb get_filelist: INF - Read filename: <CONTINUE>
11:13:51.171 [25097] <4> bphdb do_backup: INF - Processing 3a44424e414d453a6267773a4442484f4d453a2f6f70742f6f7261636c652f31302e322f3a44424e45544e414d453a:DBTEMPLATENAME:svmmprod-oracle-arch.tpl
11:13:51.173 [25097] <4> bphdb keepalive_timeout: INF - bphdb still working.
11:13:51.173 [25097] <2> bphdb keepalive_timeout: INF - bphdb- Sending a keepalive.
11:13:51.173 [25097] <4> bphdb do_backup: INF - Keepalives will be sent every 150 seconds.
11:13:51.173 [25097] <4> bphdb do_backup: INF - Waiting for the child status.
11:13:51.174 [25098] <4> check_for_valid_database: INF - Database validation buffer = :DBNAME:bgw:DBHOME:/opt/oracle/10.2/:DBNETNAME:
11:13:51.174 [25098] <4> check_for_valid_database: INF - DBNAME=bgw DBHOME=/opt/oracle/10.2/ DBNETNAME= DBTEMPLATENAME=svmmprod-oracle-arch.tpl
11:13:51.178 [25098] <4> isUbsValidDatabase: INF - Objectinfo from ubs, DBNAME=acrs and DBHOME=/opt/oracle/10.2/
11:13:51.178 [25098] <4> isUbsValidDatabase: INF - Objectinfo from ubs, DBNAME=bgw and DBHOME=/opt/oracle/10.2/
11:13:51.178 [25098] <4> bphdb do_backup: INF - Template valid on client:  svmmprod-oracle-arch.tpl
11:13:51.178 [25098] <4> bphdb do_backup: INF - Child executing /usr/openv/netbackup/bin/bpdbsbora -rw -t svmmprod-oracle-arch.tpl
11:13:59.528 [25097] <16> bphdb do_backup: ERR - Script exited with status = 1 <the requested operation was partially successful>
11:13:59.528 [25097] <4> bphdb main: file /tmp/obackup_class deleted.
11:13:59.611 [25097] <16> bphdb Exit: ERR - bphdb exit status = 6: the backup failed to back up the requested files

11:13:59.611 [25097] <4> bphdb Exit: INF - EXIT STATUS 6: the backup failed to back up the requested files




Will_Restore
Level 6
Same error as before (ORA-01031: insufficient privileges)?

What does your DBA have to say?

Claudio_Veronez
Level 6
Partner Accredited
Same Error

rilwan_dawodu
Level 4
Certified
1.  ok create a template file for the on the client manually and set the file permission to be executable by all. The file should be owned by oracle.
The template can look like this;

run {
  allocate channel t1 type 'SBT_TAPE';
  SEND_POLICY_IS_DETERMINED_AT_RUNTIME
  SEND_SCHEDULE_IS_DETERMINED_AT_RUNTIME
  SEND_CLIENT_IS_DETERMINED_AT_RUNTIME
  backup
    filesperset 500
    format 'arch_%s_%p_%t'
    SEND_ARCHIVERANGE_IS_DETERMINED_AT_RUNTIME
  backup current controlfile tag='controlfile backup'
    format 'control_%s_%p_%t';
}

2. Yes. the backup selection in the already created backup policy can be full path to the template file or a script that will call the template. A schedule will need to be created as well if not already created.

3. check that the libobk.so file exist. it should be sym linked to libobk.so64.1 file (in netbackup - bin directory on the client).    The libobk.so location should be at  <oracle home>/lib/


If all these are in place and you still encounter error, lets see the excerpt from the rman log


you might as well try out the steps in the technote below as a resolution to the error you are experiencing in the bphdb log
http://seer.entsupport.symantec.com/docs/289956.htm




Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Please also ensure you have dbclient log before next backup attempt. (Remember to chmod 777 dbclient.)

Claudio_Veronez
Level 6
Partner Accredited
By the way thank for the tip  777
DBCLIENT

17:00:03.700 [1614] <4> VxBSAEndTxn: INF - Transaction being COMMITED.
17:00:03.700 [1614] <2> int_DumpSbtInfo: INF - Media Information for Backup File : <arch-s3104-p1-t705689954>
17:00:03.700 [1614] <2> int_DumpSbtInfo: INF - Media Sharing Mode : <Single User>
17:00:03.700 [1614] <2> int_DumpSbtInfo: INF - File Ordering Mode : <Sequential file access>
17:00:03.700 [1614] <2> int_DumpSbtInfo: INF - Media ID : <S00087>
17:00:03.700 [1614] <2> int_DumpSbtInfo: INF - File Creation Date and Time : <1260903725>
17:00:03.700 [1614] <2> int_DumpSbtInfo: INF - File Expiration Date and Time : <1263582125>
17:00:03.700 [1614] <2> int_DumpSbtInfo: INF - Comment : <Backup ID : svmmprod-oracle_1260903725>
17:00:03.700 [1614] <2> int_DumpSbtInfo: INF - File Creation Method : <Stream>
17:00:12.450 [1614] <2> int_RemoveImage: INF - Removing backup image => <c-4293121411-20091215-06>
17:00:12.450 [1614] <2> int_logDateRange: INF - Start Time = 12/14/09 12:00:00
17:00:12.450 [1614] <2> int_logDateRange: INF - End Time = 12/16/09 12:00:00
17:00:12.450 [1614] <4> VxBSABeginTxn: INF - entering VxBSABeginTxn.
17:00:12.451 [1614] <4> VxBSAQueryObject: INF - entering QueryObject.
17:00:12.451 [1614] <4> dbc_GetServerClientConfig: ServerName: <svbackup>, ClientName: <svmmprod2>
17:00:12.451 [1614] <8> VxBSAQueryObject: WARNING - NBBSA_CLIENT_HOST name= <svmmprod-oracle> differs from NBU config name= <svmmprod2>
17:00:12.452 [1614] <2> logconnections: BPRD CONNECT FROM 192.168.20.74.45403 TO 192.168.4.26.13720
17:00:12.486 [1614] <16> VxBSAQueryObject: ERR - dbc_get_string() failed 135
17:00:12.486 [1614] <16> xbsa_QueryObject: ERR - VxBSAQueryObject: Failed with error:
   Server Status:  client is not validated to perform the requested operation
17:00:12.486 [1614] <4> VxBSAEndTxn: INF - entering VxBSAEndTxn.
17:00:12.486 [1614] <4> VxBSAEndTxn: INF - Transaction being COMMITED.
17:00:12.486 [1614] <16> int_RemoveImage: ERR - Failed to remove, c-4293121411-20091215-06, from image catalog.

17:00:13.412 [1614] <4> sbtend: INF - --- END of SESSION ---
17:00:13.412 [1614] <4> VxBSATerminate: INF - entering VxBSATerminate.


something about image clean up ??


I think that will solve 2 problems of mine.. my catalog is growing a lot

Claudio_Veronez
Level 6
Partner Accredited
by tha way sorry about that 5 days, I wasn 't in my city.


Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
Did you notice the problem in dbclient log?

17:00:12.451 [1614] <8> VxBSAQueryObject: WARNING - NBBSA_CLIENT_HOST name= <svmmprod-oracle> differs from NBU config name= <svmmprod2>
17:00:12.452 [1614] <2> logconnections: BPRD CONNECT FROM 192.168.20.74.45403 TO 192.168.4.26.13720
17:00:12.486 [1614] <16> VxBSAQueryObject: ERR - dbc_get_string() failed 135
17:00:12.486 [1614] <16> xbsa_QueryObject: ERR - VxBSAQueryObject: Failed with error:
   Server Status:  client is not validated to perform the requested operation

The hostname sent by Rman is svmmprod-oracle
The hostname in the client bp.conf seems to be svmmprod2 
If this a cluster, see this TechNote for more info: http://seer.entsupport.symantec.com/docs/271446.htm


View solution in original post

Claudio_Veronez
Level 6
Partner Accredited
I have made a Test w/ that,

that server is something wierd, 2 solaris cluster, and just one of the nodes have the database, something crazy about ericcsson dudes.

I 'll back the hostname and try again...

thanks a lot

Claudio_Veronez
Level 6
Partner Accredited
I had changed the host,
and followed the tech note, (create the altnames)
I have set the preference interface (NB in hosts)


And it done... THANKS..

i have set the /etc/hosts

<ip>  svmmprod1
<ip> svmmprod2
<ip> svmmprod-oracle

even the svmmprod2 and svmmprod-oracle being the same server i used 2 different ips, because I have to backup files and another stuff.

THANKS a lot Marianne, I are great,
I hope some day I help you too.