OraFAQ Forum: Server Administration » Archive log is frequently filling

Home » RDBMS Server » Server Administration » Archive log is frequently filling (Oracle9i,Linux Advance Server 2.1 AS)

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

Archive log is frequently filling [message #404761]

Sat, 23 May 2009 07:45

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.

Report message to a moderator

Re: Archive log is frequently filling [message #404762 is a reply to message #404761]

Sat, 23 May 2009 07:48

Mahesh Rajendran
Messages: 10708
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).

Report message to a moderator

Re: Archive log is frequently filling [message #404861 is a reply to message #404762]

Mon, 25 May 2009 01:36

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Archive log is frequently filling [message #404867 is a reply to message #404863]

Mon, 25 May 2009 01:52

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

Report message to a moderator

Re: Archive log is frequently filling [message #404870 is a reply to message #404867]

Mon, 25 May 2009 02:00

Mahesh Rajendran
Messages: 10708
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?

Report message to a moderator

Re: Archive log is frequently filling [message #404880 is a reply to message #404870]

Mon, 25 May 2009 02:40

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

Report message to a moderator

Re: Archive log is frequently filling [message #404883 is a reply to message #404880]

Mon, 25 May 2009 02:53

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: Archive log is frequently filling [message #405060 is a reply to message #404883]

Tue, 26 May 2009 03:54

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

Report message to a moderator

Previous Topic:	Hit ORA-03232: unable to allocate an extent of 18 blocks from tablespace 3
Next Topic:	Data file modification date

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:49:15 CST 2024