need to remove unwanted data in log file

[Former Member]

hai experts,

how to identify and remove the unwanted data from log file.plz help me.

regards,

pugazh.

[Former Member · Accepted solution]

u can delete logs frm oraarch directory which r very old.if u delete all the files in oraarch directory ie.,recent archive files u will have problem with the startup of database or ur appserver so even if u take backup keep recent archive files for system startup issues.

if it is useful plz rewrd points

[Former Member · Accepted solution]

hai shekar,

thanks. but how will i keep the hard disc space sufficient without taking back up of whole data in orrach file? .are u know any other option plz help me.

[former_member204746 · Accepted solution]

you can move those oraarch files on another disk nutil you back them up properly. this will free up space temporarily.

[Former Member · Accepted solution]

hai ,

is there any permanent solution other than orrach file.plz help me.

[former_member204746 · Accepted solution]

run brachive with option -d (or better, with option -sd)

[Former Member · Accepted solution]

hai eric,

what is the functionality of this command and where can i use this command? in command prompt? for this back up is not neccessary? plz help me.

[former_member204746 · Accepted solution]

brarchive takes a backup of all offline redologs, then deleted them. this is done at OS level.

if you do not need them and you do not need archiving, a permanent solution is to disable archiving:

stop SAP first, then:

sqlplus / as sysdba

shutdown immediate;

startup mount

alter database noarchivelog;

alter database open;

exit

after this, you will never be able to do a recovery point-in-time, and won't be able to start online backups.

[Former Member]

Thanks all for guid and helped me.The problem is solved.

[Former Member]

hi pugazh,

as i told u earlier there is no other go.u have to take backup of all the old archive files n delete from the oraarch directory.keep the fresh archive files(recent) in the oraarch directory so as to avoid startup problems of appserver or dbserver.

i think this gives u a better approach 2 ur problem.

feel free 2 contact on any issue.

rewrd points r welcome.

shekar.

[Former Member]

plz help me to remove the unwanted log file from ides server because there is low space for hard disc.

[former_member227600]

hi,

you can remove oraarc data from IDES server & if you want to keep backup of this data ,than you can write this data on exteranal drive or any other storage media.

karan.

[former_member204746]

also delete:

/usr/sap/SID/D/work/.old

[Former Member]

hai karan,

i taken the back up of oraarch file in my pen drive.noe ides is working fine. but i taken back up of only old datas from orrach. is there any problem occur if i remove the whole orrach file.from ides?. plz reply help me.

thanks

pugazh.

[Former Member]

i removed only old datas in orrach not all. so if in future again the hard disc space is getting low.but iam affraid to remove all datas in orrach and taken back up. plz help me

[former_member227600]

Hi,

you can remove all data from oraarc dir without taking backup,but in future if your system get down & you have no backup(database backup) than you will face a serious problem,thats why i am saying take backup of oraarc on any other storage media.

karan