Home » RDBMS Server » Server Administration » How to purge archive (*.arc) in Oracle 8 safety?
icon9.gif  How to purge archive (*.arc) in Oracle 8 safety? [message #161724] Mon, 06 March 2006 20:22 Go to next message
marco118
Messages: 16
Registered: March 2006
Junior Member
Hi Razz

I am rookie in Oracle 8, when I checked my UNIX only remain 7% storage disk in my machine. I found that the reason is belong too many archive files in Oracle 8. It keeps a lot of *.arc from July 2005 until now . Therefore , I want to delete some archive.arc to free space in unix(purge archive.arc around 3 months ). The Oracle 8 is hotbackup and never shutdown when I get this job until now. So, I would like to know can I directly delete archive.arc in unix machine? I just want make sure everything is safety (I know I have keep recent 3 months for archive.arc file in TAPE) SO,anything I need attention more?

Thanks
Embarassed
Marco118

Report message to a moderator

Re: How to purge archive (*.arc) in Oracle 8 safety? [message #161736 is a reply to message #161724] Mon, 06 March 2006 23:15 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

It depends on your backup strategy. When did you take the last hot backup??

And one more thing if you have old archive log files on tapes then why do you want to keep a copy on the OS also?

You can remove all the archive files from the OS that are there on tapes.

Report message to a moderator

Re: How to purge archive (*.arc) in Oracle 8 safety? [message #161751 is a reply to message #161724] Tue, 07 March 2006 00:23 Go to previous message
marco118
Messages: 16
Registered: March 2006
Junior Member
Hi tarundua

Thanks for teaching, I checked two things.

1) Oracle Enterprize manager - storage manager shows I got archive files from Jul 2005 until now,

2) Unix Platfrom - go into archive directory, It's only show from 20 Feb 2006 to Today's Archive files in directory. (?? where is my previous archive files before 20 Feb 06??)

I have question about why OEM didn't match what I got archive file in same directory? Is there anything my concept is wrong?

The disk Utility is over 92% now, I really need to purge some files for free space.
Pls give a hand! thanks

Marco118

Report message to a moderator

Previous Topic: 8i to 10G
Next Topic: OS authenitication
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 17:12:20 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.