Home » RDBMS Server » Server Administration » ORA-00257: archiver error. (10.2.0.4)
ORA-00257: archiver error. [message #524052] Wed, 21 September 2011 09:43 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
While connecting to one of the dev database I am getting
following error:-
ORA-00257: archiver error. Connect internal only, until freed.
But when i am checking as sys user there is no archive desination
defined in the db.I mean log_archive_dest locations have not
been given any value.Where can I check Archive destination in
this scenario.Is there any default place where oracle stores
archive logs incase log_archive_dest is not given any value.


Thanks,
Varun
Re: ORA-00257: archiver error. [message #524055 is a reply to message #524052] Wed, 21 September 2011 09:54 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Login as sys and issue

archive log list
Re: ORA-00257: archiver error. [message #524056 is a reply to message #524052] Wed, 21 September 2011 10:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68644
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

Regards
Michel
Re: ORA-00257: archiver error. [message #524058 is a reply to message #524055] Wed, 21 September 2011 10:11 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Mahesh,
I am getting this:-

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7368
Next log sequence to archive 7368
Current log sequence 7370
I have deleted archive logs at this destination but
still getting the same error.

Thanks,
Varun
Re: ORA-00257: archiver error. [message #524061 is a reply to message #524058] Wed, 21 September 2011 10:26 Go to previous messageGo to next message
John Watson
Messages: 8930
Registered: January 2010
Location: Global Village
Senior Member
Physically deleting them isn't enough, you have to tell Oracle that they are gone. Connect with RMAN, and run:

crosscheck archivelog all;
delete expired archivelog all;

then you will be OK.

[update - completed missing syntax]

[Updated on: Wed, 21 September 2011 10:28]

Report message to a moderator

Re: ORA-00257: archiver error. [message #524063 is a reply to message #524061] Wed, 21 September 2011 10:53 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks a lot John
Re: ORA-00257: archiver error. [message #524101 is a reply to message #524063] Wed, 21 September 2011 14:45 Go to previous messageGo to next message
Flyby
Messages: 188
Registered: March 2011
Location: Belgium
Senior Member
the crosscheck is for fixing rman.
Usually I remove the archive log files, issue "alter system switch logfile" as sysdba to wake oracle, and then fixing rman by crosscheck archive log all... (see above)
Re: ORA-00257: archiver error. [message #524104 is a reply to message #524101] Wed, 21 September 2011 14:51 Go to previous message
Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want to archive better use "alter system archive log [current|all]".

Regards
Michel
Previous Topic: CPU use with resource manager
Next Topic: What will be the fastest way to move a db data to another db(has data)?
Goto Forum:
  


Current Time: Wed Apr 24 00:43:12 CDT 2024