Printable View
Hi all,
When I try to open any Oracle tool, I get the ORA-00257 Archive error.
I came to know that this may be due to insufficent disk space in the destination, so I have freed up my drive too(it has 513MB space now..)
But I still get the same error??
Do I need to do anything else?
I am using Oracle 8.1.6 on Windows NT 4.0.
Thanks for any advice.
Shiva.
From oerr:
Error: ORA 257
Text: archiver is stuck.
-------------------------------------------------------------------------------
CONNECT INTERNAL only, until freed
Cause: The ARCH process received an error while trying to archive a redo log
file.
If the problem is not resolved soon, the database will stop executing
transactions.
The most likely cause of this message is that the destination device
is out of space to store the redo log file.
Action: Check the archiver trace file for a detailed description of the
problem.
Also, verify that the device specified in the initialization parameter
ARCHIVE_LOG_DEST is set up properly for archiving.
------
Now that you have freed up some space, you can either turn archiving off or restart archiving (alter system archive log start).
Thanks for your response.
But how am I to get into the system at all...all my SQLPLUS, Enterprise manager, everything if frozen with this error??
I know this may seem silly, but I really have no idea..
Shiva.
I'm not sure on NT, but you should get to a command prompt (might be able to get in through svrmgrl):
c:> sqlplus /nolog
SQL> connect internal
SQL> alter system archive log start;
Thanks.