Home » Server Options » Data Guard » ORA-00257 archiver error. Connect internal only until freed (Oracle EE database 9.0.1.4, Solaris 8)
ORA-00257 archiver error. Connect internal only until freed [message #674834] Mon, 18 February 2019 22:35 Go to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Our Standby database encountered an ORA-01666 error after startup yesterday.
What my colleague executed on that morning was to "SELECT SWITCHOVER_STATUS FROM V$DATABASE"
on both Production & Standby databases.

After this the "archiver error" appeared, both database and application is now inaccessible.

Please assist us on what to do.

Thank you in advance.


Re: ORA-00257 archiver error. Connect internal only until freed [message #674835 is a reply to message #674834] Tue, 19 February 2019 00:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01666: control file is for a standby database
 *Cause:  Attempting to mount, recover, or open a standby database without
          the appropriate command option to designate a standby database.
 *Action: Use the standby option or appropriate commands, or mount with
          the primary control file.
Re: ORA-00257 archiver error. Connect internal only until freed [message #674836 is a reply to message #674835] Tue, 19 February 2019 00:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00257: archiver error. Connect internal only, until freed.
 *Cause:  The archiver process received an error while trying to archive
         a redo log.  If the problem is not resolved soon, the database
         will stop executing transactions. The most likely cause of this
         message is the destination device is out of space to store the
         redo log file.
 *Action:  Check 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.
Re: ORA-00257 archiver error. Connect internal only until freed [message #674837 is a reply to message #674834] Tue, 19 February 2019 01:48 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
To avoid the ora-01666 you need to run
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;

The ora-00257 is because you have not removed old archive logfiles. Do it with RMAN.

Data Guard did work in 9i release 1, but you have to do a lot of the management yourself. The automation was not complete.
Re: ORA-00257 archiver error. Connect internal only until freed [message #674842 is a reply to message #674836] Tue, 19 February 2019 04:38 Go to previous messageGo to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Sir,

We have re-set the archive destination folder,
then refreshed the archiver process.
dB and Apps are now accessible.

Thanks for your prompt assistance.

Best regards,
Re: ORA-00257 archiver error. Connect internal only until freed [message #674843 is a reply to message #674837] Tue, 19 February 2019 04:40 Go to previous messageGo to next message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Yes Sir, we did that also prior to stop and restarting the archive process.

Thank you.
Re: ORA-00257 archiver error. Connect internal only until freed [message #674844 is a reply to message #674836] Tue, 19 February 2019 04:40 Go to previous message
reym21
Messages: 241
Registered: February 2010
Location: Philippines
Senior Member

Sir Michel,

We have re-set the archive destination folder,
then refreshed the archiver process.
dB and Apps are now accessible.

Thanks for your prompt assistance.

Best regards,

[Updated on: Tue, 19 February 2019 04:40]

Report message to a moderator

Previous Topic: Error 12154 received logging on to the standby (split from hijacked topic)
Next Topic: ORA-00603: ORACLE server session terminated by fatal error
Goto Forum:
  


Current Time: Thu Mar 28 06:09:33 CDT 2024