Can not start SAP (J2EE) --> Oraarch was full

[Former Member]

Hi Everybody,

i can not start the sap system because thre is no space left under /oracle/<instance>/oraarch.

In /oracle/<instance>/oraarch i have the following files:

D05arch1_347_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 9 23:00 D05arch1_348_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 9 23:00 D05arch1_349_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 10 20:00 D05arch1_350_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 10 23:00 D05arch1_351_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 10 23:20 D05arch1_352_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 11 23:00 D05arch1_353_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 11 23:00 D05arch1_354_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 12 20:00 D05arch1_355_651422181.dbf

-rw-r----- 1 orad05 dba 43980800 May 12 23:00 D05arch1_356_651422181.dbf

-rw-r----- 1 orad05 dba 45900800 May 12 23:21 D05arch1_357_651422181.dbf

can i delete all files which was not created today or copy them to an other place? And how can i avoid this problem for the next time?

regards,

Seed

Edited by: seed_mopo on May 13, 2008 11:38 AM

[Former Member · Accepted solution]

Seed,

Are you backing up the files in this directory? These files should be backed up at regular intervals. YOu need these files for your database recovery. If you are backing them up, but it filled up before the backup started, you need to increase space for this directory. If you think the frequency of the files are unusual, check your system and see what's running & creating these logs.

-RK

[Former Member · Accepted solution]

Hi,

sorry for the late anwser!

Unitl now we copy the files every two weeks manually to another device bevor our space (4,5 GB) runs full. Is that a normal process? And if not how can i check my system?

regards,

Seed

Edited by: seed_mopo on May 22, 2008 5:33 PM

[Former Member · Accepted solution]

Hi,

Archivelogs are constantly created when the system is in use, frequency depends on how much activity is on the system. You need to back up these files to tape so that in the event of a crash you need these files along with your database backup to recover the system to a point in time.

You can get help here - http://help.sap.com/saphelp_nw04/helpdata/en/0d/d2f6b74a0c11d182b80000e829fbfe/content.htm

-Regards

RK

[lbreddemann]

Hi Seed,

archiver stuck ? You're serious ...? That kind of problem really should never appear...

Well perhabs it's a good idea to read some notes like:

SAP Note 14562 BRARCHIVE - archiver stuck

SAP Note 391 Archiver stuck

and the documentation [Setting Up Archiving|http://help.sap.com/saphelp_nw04/helpdata/en/65/96f1e4a6974512962197918624e1c5/frameset.htm].

If you have already done everything mentioned in the notes and the problem still appears, I propose you check for errors in the brarchive logs and the Oracle Alert.log.

KR Lars