ORAARCH FULL

[Former Member]

Hi,

We have EP7.0 SP16 , IBM AIX 5L with Oracle 10G.

(Only Java Stack)

Every week Oraarch log files become 100%.

Sometmes Data File full.

How to make archive automatically and delete the old archives automatically.

Can any one explain me step by step or give me some Doc/Links.

And what is DB Statistics, why we need it,please explain?

Regards,

Karthick

Edited by: Karthick Eswaran on Aug 10, 2008 6:15 AM

[Former Member · Accepted solution]

Karthick,

Create a cron job to run a script to check percentage used / capacity of oraarch directory. If it exceeds 80% run a brarchive command to archive the logs.

Cheers,

Nisch

[Former Member · Accepted solution]

If I run BRARCHIVE with ORASID user,I am getting the below error.

BKI2001E: Socket error while connecting to ProLE at 57323@sapprj3: Connection refused

BKI0020I: End of program at: Mon Aug 11 08:35:35 2008 .

BKI0021I: Elapsed time: 00 sec .

BKI0024I: Return code is: 2.

BR0280I BRARCHIVE time stamp: 2008-08-11 08.35.35

BR0279E Return code from '/usr/sap/RD1/SYS/exe/run/backint -u RD1 -f backup -i /oracle/RD1/saparch/.adyohrof.lst -t file -p /oracle/RD1/102_64/dbs/initRD1.utl': 2

BR0232E 0 of 158 files saved by backup utility

BR0280I BRARCHIVE time stamp: 2008-08-11 08.35.35

BR0231E Backup utility call failed

BR0016I 0 offline redo log files processed, total size 0.000 MB

BR0007I End of offline redo log processing: adyohrof.sve 2008-08-11 08.35.35

BR0280I BRARCHIVE time stamp: 2008-08-11 08.35.35

BR0005I BRARCHIVE terminated with errors

Please let me know how to proceed with the archiving.

[Former Member · Accepted solution]

Hi Karthick

The first thing you need to do is get your archive log backups working. From your post it looks like your getting an error in the backint communication with your backup Software.

Are you able to backup the database using brbackup??

Once you have these backup tools working, you can create a script:

#!/bin/sh

PATH=$PATH:/sapmnt/SID/exe

brbackup -c -u / -t online -a -c -cds >> logfile_some_where

This will backup the db and then schedule a archive backup as well. The -cds means it will only delete the redologs when you have backup them up twice.

Regards

Doug

[Former Member · Accepted solution]

Doug,

Is this script for Online Backup or Offline Backup?

I am not able to find out why BRTOOLS is not working properly?

Should I reinstall it?

Regards,

Karthick

[Former Member · Accepted solution]

In addition to what Doug pointed out:

It seems you are using an external backup tool, by means of backint interface. This tool should write log files of its own, and they may have helpful information. So please find out more about it! This should be the most promising thing now. No need to reinstall now, imho.

And by the way:

brbackup -c -u / -t online -a -c -cds >> logfile_some_where

So it's an online backup obviously.

hope this helps

[Former Member · Accepted solution]

Hi Karthick

What third party tool are you using to backup the database? By this I mean what is the tape management software you are using to manage your tape units eg Networker, Tivoli..

Regards

Doug

[Former Member · Accepted solution]

Doug,

We use IBM Tivoli.

[Former Member · Accepted solution]

Hi Karthick

Unfortunately I have never used Tivoli so I can't help you with that part of setting up your backups. I found this link to [Storage manager Documentation|http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp]. Select Storage manager for Enterprise resource Planning to see the documentation for using backint.

The backint program is an interface between the SAP br*tools (brbackup,brarchive) and the Tivoli Storage manager (and other third-party backup management tools).

Once you have this working you are 90% there, the last part (10%) is to configure your backups to guarantee full protection of your database.

I would recommend an online backup nightly followed immediately by an archive log backup. To be able to recover your database fully from an online backup you need these archive logs. They are critical. That is why I recommend the -cds for your archive backup. This does consume a bit more space in your oraarch directory as the redologs are not deleted until they have been saved a second time but you get 2 copies of offline redologs on different tapes.

Good luck

Doug

[Former Member · Accepted solution]

Doug,

Thank you for your reply.I shall go through the IBM Documentation and configure Online Backup.

I'll get in touch with you if I need more info.Thankyou,

regards,

Karthick

[Former Member]

A ._oraarch solution_

1.Configure the archivelog backup 3 times to 4 time a day with option to second copy delete.

i.e

/sapmnt/PRD/exe/brarchive -d util_file -scd -c -u

2.Increase the size of oraarch

3.Write an unix script to move the archive logs at a different location from oraarch immidiately.

B._Statistics*_

The statistics are the import part of our system performance.

The oracle internal mechanism calculates the best possible way of fetching the data from oracle database.

The indexes on table retireves the data with help of uptodata table or index statistics.

this is one of the explanation of your query.

search on net for db statistics.You get many reason why update statistics.

Search term Btree ALSO

HOPE IT HELPS.

Amit Asthana

[Former Member]

Hi,

How to configure Archivelog Backup 3-4 times a day.

Can you please explain me step by step.

Regards,

Karthick

[Former Member]

Use DB13 for it.

[Former Member]

Deepak,

I do have only JAVA Stack.

No ABAP Stack.

So I can not use the Transaction DB13.

Regards,

Karthick

[fidel_vales]

Hi,

Then you could use DB13C on a server with an ABAP instance.

Otherwise you will have to play with the CRON job (in UNIX), check "man cron"

if you have windows, sorry, no clue. I'm sure there are similar tools.