Home » RDBMS Server » Server Administration » Archive log not able to write.....query
Archive log not able to write.....query [message #222663] Mon, 05 March 2007 19:06 Go to next message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
Hi,

i had a scenario where in the archive log process was not able to write the logs on the disk because the disk went out of space. I would like to know, in this scenario when the ARCH process is trying to archive the redo logs, is it possible to login to the Database ( i mean can some user connect to data base by establishing a session).

Thanks
Re: Archive log not able to write.....query [message #222665 is a reply to message #222663] Mon, 05 March 2007 19:13 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>is it possible to login to the Database
IIRC, only SYS can log into the DB under this condition.
Re: Archive log not able to write.....query [message #222882 is a reply to message #222663] Tue, 06 March 2007 17:58 Go to previous messageGo to next message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
Hi anacedent,

what is it that stops us from creating a new session with the DB.

Thanks
Re: Archive log not able to write.....query [message #222923 is a reply to message #222882] Tue, 06 March 2007 23:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

HI,
what is it that stops us from creating a new session with the DB.

When any user want to create new session then they will get below error. so you don't need to do anything.

C:\Documents and Settings\m.taj.FAKHRUDDIN>sqlplus scott/tiger

SQL*Plus: Release 10.1.0.2.0 - Production on Wed Mar 7 09:55:13 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

ERROR:
ORA-00257: archiver error. Connect internal only, until freed.


regards
Taj

[Updated on: Tue, 06 March 2007 23:58]

Report message to a moderator

Re: Archive log not able to write.....query [message #223114 is a reply to message #222923] Wed, 07 March 2007 10:29 Go to previous message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
Thanks for the confimative answer. I would further bug you with one more question as to what happens in the server side when ARCH process is hung and a session request comes from a workstation. I understand that the redo logs maintain the compiled inverse code for any DML operation performed on the database, so is it linked to session creation be any user.

Thanks
Previous Topic: Installing Oracle on Unix
Next Topic: ORA 7445 exception encountered
Goto Forum:
  


Current Time: Fri Dec 09 19:47:24 CST 2016

Total time taken to generate the page: 0.05787 seconds