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.