Home » RDBMS Server » Server Administration » what will happen when archive log destination filled?
what will happen when archive log destination filled? [message #198874] Wed, 18 October 2006 22:29 Go to next message
dak.dba
Messages: 7
Registered: October 2006
Location: hyd
Junior Member
what will happen when archive log destination filled?
our database is up and running, archive log destination is filled.
what will happen to the database?
Re: what will happen when archive log destination filled? [message #198877 is a reply to message #198874] Wed, 18 October 2006 22:45 Go to previous messageGo to next message
fuyuncat
Messages: 2
Registered: October 2006
Junior Member

it may lead ur DB be hung...
Re: what will happen when archive log destination filled? [message #198930 is a reply to message #198874] Thu, 19 October 2006 03:54 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Oracle VER.

Add more space on ur hard disk
or
remove unneccessary file from hard disk.
Re: what will happen when archive log destination filled? [message #198946 is a reply to message #198874] Thu, 19 October 2006 05:05 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> what will happen to the database?
Database will appear to be "hanging" as stated fuyuncat.
Actually, database will cease to operate. An alert will be written to alertsid.log and all operations will be suspended.
Re: what will happen when archive log destination filled? [message #198960 is a reply to message #198946] Thu, 19 October 2006 06:12 Go to previous messageGo to next message
dak.dba
Messages: 7
Registered: October 2006
Location: hyd
Junior Member
thanks mahesh
Re: what will happen when archive log destination filled? [message #344562 is a reply to message #198960] Sat, 30 August 2008 10:35 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Users cannot connect to the db server if archive log is full and database will hang.
so make sure your archive log filesystem is safe by removing previous or old archivelogs.

Regards,
Balaji
Re: what will happen when archive log destination filled? [message #344571 is a reply to message #344562] Sat, 30 August 2008 12:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nice to see you want to share what you learned (from here) but is it necessary to do it in a 2 years old topic?

./fa/4921/0/

Regards
Michel

[Updated on: Sat, 30 August 2008 12:01]

Report message to a moderator

Re: what will happen when archive log destination filled? [message #344634 is a reply to message #344571] Sun, 31 August 2008 04:44 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

topic version should not matter. only the contents inside the topic should matter. i have mentioned the last point for those who may come across this topic in future.

Regards
Balaji Smile
Re: what will happen when archive log destination filled? [message #344645 is a reply to message #344634] Sun, 31 August 2008 06:24 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't add anything that has already been said.

Regards
Michel
Previous Topic: Schema,User,Database
Next Topic: move DB from one server to another server [merged]
Goto Forum:
  


Current Time: Sun Dec 11 07:53:17 CST 2016

Total time taken to generate the page: 0.08129 seconds