Home » RDBMS Server » Server Utilities » How To Manage The Oracle Archive File
How To Manage The Oracle Archive File [message #69199] Tue, 20 November 2001 19:41 Go to next message
Anant Tiwari
Messages: 1
Registered: November 2001
Junior Member
Dear Friend

I have very big problem that at present my Database in Archive Mode.
I specify in Init.ora.

log_archive_start = true
log_archive_dest_1 = "location=/usr/local/oracle/OraHome1/admin/dporalnx/arch"
log_archive_format = arch_%t_%s.arc

My problem that In a week My Disk going to full Because of Archive file.
What I have to do the old archive file. And I am also seeing that in a day Oracle server making 30 to 35 very big file.
So please help me to resolve this problem.

Thanks
Anant Tiwari

----------------------------------------------------------------------
Re: How To Manage The Oracle Archive File [message #69204 is a reply to message #69199] Wed, 21 November 2001 03:44 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
Take the backup of archive log files while taking hot backup of database and you can delete those archive logs or you can compress it.

----------------------------------------------------------------------
Previous Topic: SQL LOader
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  


Current Time: Fri Mar 29 08:22:04 CDT 2024