Home » RDBMS Server » Server Administration » ora:00257
ora:00257 [message #259080] Tue, 14 August 2007 06:24 Go to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
i have problem when i connect

SQL> connect dev/dev
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.
Re: ora:00257 [message #259085 is a reply to message #259080] Tue, 14 August 2007 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your archiving destination is full.
Release space.

Regards
Michel
Re: ora:00257 [message #259088 is a reply to message #259080] Tue, 14 August 2007 06:34 Go to previous messageGo to next message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
please tell me

how to do
Re: ora:00257 [message #259093 is a reply to message #259088] Tue, 14 August 2007 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Are you a DBA? Do you have full privilege?

Regards
Michel
Re: ora:00257 [message #259132 is a reply to message #259088] Tue, 14 August 2007 08:51 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Get someone who has privileges (and knowledge of what they are doing) to go to the directory where your archive log files are and start removing files, or if it's on a shared filesystem, remove other files.
Re: ora:00257 [message #259199 is a reply to message #259080] Tue, 14 August 2007 11:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
if your using 10g or configure flash recovery area then increase db_recovery_file_dest_size

or connect to RMAN
delete all expired / obsolete files for make free space in flash recovery area.


Regards
Taj

[Updated on: Tue, 14 August 2007 11:25]

Report message to a moderator

Re: ora:00257 [message #259287 is a reply to message #259080] Tue, 14 August 2007 23:12 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

First check whether your archive log destination is set properly or not.

If it is ok then this error comes due to huge archive log generation. Someone made a huge transaction on the database. For removing error message either you off your achive log mode or use,

alter database clear unarchived logfile group 1;

alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;

and so on. After that restart your archive log.

alter system archive log stop 
alter system archive log start


I have not verified my syntax error.




Thanks,
Arju.
Re: ora:00257 [message #259589 is a reply to message #259287] Thu, 16 August 2007 01:02 Go to previous message
anamika_025
Messages: 81
Registered: July 2007
Location: Indore
Member
thanks a lot
Previous Topic: dump
Next Topic: How doese oracle work when getting some cols from database
Goto Forum:
  


Current Time: Wed Dec 07 16:51:11 CST 2016

Total time taken to generate the page: 0.10527 seconds