Home » RDBMS Server » Server Administration » Delete ORAARCH folder
Delete ORAARCH folder [message #241282] Tue, 29 May 2007 01:48 Go to next message
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
Re: Delete ORAARCH folder [message #241286 is a reply to message #241282] Tue, 29 May 2007 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: Delete ORAARCH folder [message #241300 is a reply to message #241282] Tue, 29 May 2007 02:44 Go to previous messageGo to next message
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
Re: Delete ORAARCH folder [message #241313 is a reply to message #241282] Tue, 29 May 2007 03:51 Go to previous messageGo to next message
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.
Re: Delete ORAARCH folder [message #241315 is a reply to message #241300] Tue, 29 May 2007 03:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: Delete ORAARCH folder [message #241316 is a reply to message #241282] Tue, 29 May 2007 03:53 Go to previous messageGo to next message
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.
Re: Delete ORAARCH folder [message #241319 is a reply to message #241282] Tue, 29 May 2007 04:19 Go to previous messageGo to next message
kris_caldoza
Messages: 3
Registered: May 2007
Location: Manila
Junior Member

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

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
Re: Delete ORAARCH folder [message #241332 is a reply to message #241319] Tue, 29 May 2007 04:54 Go to previous message
Michel Cadot
Messages: 64152
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:
  


Current Time: Sat Dec 10 15:03:02 CST 2016

Total time taken to generate the page: 0.10664 seconds