OraFAQ Forum: Server Administration » Delete ORAARCH folder

Home » RDBMS Server » Server Administration » Delete ORAARCH folder

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Delete ORAARCH folder [message #241282]

Tue, 29 May 2007 01:48

kris_caldoza
Messages: 3
Registered: May 2007
Location: Manila

Junior Member

Hi,

Is it safe to delete all the files under the 'ORAARCH' folder to free up space? We are using Oracle9i as DB for our SAP BW/R3 systems and we'd like to free up space on our hard drives by deleting all the *.001 files found under the 'ORAARCH' folder. Is it safe? What's the purpose of these files anyway or the folder for that matter?

Thanks!

-Kris

Report message to a moderator

Re: Delete ORAARCH folder [message #241286 is a reply to message #241282]

Tue, 29 May 2007 01:54

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle does not care about directory names.
So for it, ORAARCH is meaningless.
With such a name I think you put in it archived logs.
You can delete them when you have backed up your database.

Take care, these are really archived logs, check your log_archive% parameters.

Regards
Michel

Report message to a moderator

Re: Delete ORAARCH folder [message #241300 is a reply to message #241282]

Tue, 29 May 2007 02:44

kris_caldoza
Messages: 3
Registered: May 2007
Location: Manila

Junior Member

Thanks for the information Michel.

From the init<SID>.ora file, the parameters related to log are:

*.log_archive_dest='F:\oracle\EC1\oraarch\EC1arch'
*.log_archive_start=true
*.log_buffer=1048576
*.log_checkpoint_interval=0
*.log_checkpoint_timeout=0
*.log_checkpoints_to_alert=true

If, for example, the archived logs/files under 'ORAARCH' were deleted without performing backup, what will be the consequences? What's the use of those archived logs/files?

Regards,
Kris

Report message to a moderator

Re: Delete ORAARCH folder [message #241313 is a reply to message #241282]

Tue, 29 May 2007 03:51

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

Quote:

If, for example, the archived logs/files under 'ORAARCH' were deleted without performing backup, what will be the consequences?

>>> What's the use of those archived logs/files?

I think you need to have a word with your DBA??

Incase of crash/recovery...Only incomplete recovery possible without these archive logs. Embarassed

Brayan.

Report message to a moderator

Re: Delete ORAARCH folder [message #241315 is a reply to message #241300]

Tue, 29 May 2007 03:52

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Consequence: you cannot recover your database in case of media failure.
Action: take a backup as soon as possible.

Regards
Michel

Report message to a moderator

Re: Delete ORAARCH folder [message #241316 is a reply to message #241282]

Tue, 29 May 2007 03:53

Brayan
Messages: 315
Registered: June 2002

Senior Member

Hi,

Once again, it all depends on your backup strategy for how long you want to keep these archives.

Brayan.

Report message to a moderator

Re: Delete ORAARCH folder [message #241319 is a reply to message #241282]

Tue, 29 May 2007 04:19

kris_caldoza
Messages: 3
Registered: May 2007
Location: Manila

Junior Member

Thank you Brayan and Michel for the information! I really appreciate it! Razz

Anyway, that's the thing with our systems. We are still in the process of formulating a suitable backup/recovery strategy.

For now, we will not be able to delete those archived files.

Thanks again.

-Kris

Report message to a moderator

Re: Delete ORAARCH folder [message #241332 is a reply to message #241319]

Tue, 29 May 2007 04:54

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you don't have backup and if already have deleted some files then you can delete all those who came after the ones you already deleted, you can never use them.

Regards
Michel

[Updated on: Tue, 29 May 2007 04:54]

Report message to a moderator

Previous Topic:	How do I create an ASM?
Next Topic:	GLOBAL Partition - 14037

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 22:37:38 CDT 2024