| Archive log not able to write.....query [message #222663] |
Mon, 05 March 2007 19:06  |
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 #222923 is a reply to message #222882] |
Tue, 06 March 2007 23:58  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
