on 09-30-2008 8:21 AM
hai experts,
how to identify and remove the unwanted data from log file.plz help me.
regards,
pugazh.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
Thanks all for guid and helped me.The problem is solved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
plz help me to remove the unwanted log file from ides server because there is low space for hard disc.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.