Home » RDBMS Server » Server Administration » Archive log is frequently filling (Oracle9i,Linux Advance Server 2.1 AS)
Archive log is frequently filling [message #404761] Sat, 23 May 2009 07:45 Go to next message
rakesh_sni
Messages: 11
Registered: September 2008
Location: M.P.
Junior Member
I am working on oracle9i platform Linux Advance Server 2.1 As ,I set my database in archive mode and installed oracle patch set 9.2.0.8 but my archive partition is frequently filling,any body can help me.
Re: Archive log is frequently filling [message #404762 is a reply to message #404761] Sat, 23 May 2009 07:48 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Only reason to have database in archivelog mode is to facilitate the backup and recovery process.
If that was your intention,
You must backup the archivelogs ( backup and delete).
Re: Archive log is frequently filling [message #404861 is a reply to message #404762] Mon, 25 May 2009 01:36 Go to previous messageGo to next message
rakesh_sni
Messages: 11
Registered: September 2008
Location: M.P.
Junior Member
this is not a permanent solution,pl. give another solution if u have
Thanks
Rakesh

[Updated on: Mon, 25 May 2009 01:36]

Report message to a moderator

Re: Archive log is frequently filling [message #404863 is a reply to message #404861] Mon, 25 May 2009 01:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is what it is.
Either you backup and delete the archive logs
or
Do not generate it.
Re: Archive log is frequently filling [message #404867 is a reply to message #404863] Mon, 25 May 2009 01:52 Go to previous messageGo to next message
rakesh_sni
Messages: 11
Registered: September 2008
Location: M.P.
Junior Member
when i delete the all archive logs then how can i removed block courruption if it is occourred.In other place on same configuration archive fills in a month,i want to know the reason why archive partition fills quickly.Thanks
Rakesh
Re: Archive log is frequently filling [message #404870 is a reply to message #404867] Mon, 25 May 2009 02:00 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quoting myself.
>>Either you backup and delete the archive logs.

rakesh_sni wrote
>>i want to know the reason why archive partition fills quickly

May be your code is asking for that.
Whatever it is you need to backup the database and remove the old logs.

>>when i delete the all archive logs then how can i removed block courruption if it is occourred
How are you intending to recover the database if you are not backing it up?
Re: Archive log is frequently filling [message #404880 is a reply to message #404870] Mon, 25 May 2009 02:40 Go to previous messageGo to next message
rakesh_sni
Messages: 11
Registered: September 2008
Location: M.P.
Junior Member
i have a export backup of database and i have recovered the database by that export backup before database crashed the archive partition fills in a month but after recovery it fills every day,why

Tanks
Re: Archive log is frequently filling [message #404883 is a reply to message #404880] Mon, 25 May 2009 02:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>i have a export backup of database and i have recovered the database by that export backup
First export is not a backup process. It never was.
You cannot recover from exported dump. You can only restore to
last dump.

>>before database crashed the archive partition fills in a month but after recovery it fills every day,why
As I said before, your database operations are calling for it.
During the so called "recovery process from exported dump" that you did,
You need to recreate the database and import the dump.
There might be some changes in configurations.
May be before some of the objects were in nologging mode.
Compare the two databases.
Re: Archive log is frequently filling [message #405060 is a reply to message #404883] Tue, 26 May 2009 03:54 Go to previous message
rakesh_sni
Messages: 11
Registered: September 2008
Location: M.P.
Junior Member
how we can see some objects are nologging mode and how we can change that mode and which mode.with regard
Rakesh
Previous Topic: Hit ORA-03232: unable to allocate an extent of 18 blocks from tablespace 3
Next Topic: Data file modification date
Goto Forum:
  


Current Time: Sun Dec 04 16:37:56 CST 2016

Total time taken to generate the page: 0.04331 seconds