OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ora:00257

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora:00257 [message #259080]

Tue, 14 August 2007 06:24

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.

Report message to a moderator

Re: ora:00257 [message #259085 is a reply to message #259080]

Tue, 14 August 2007 06:31

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Your archiving destination is full.
Release space.

Regards
Michel

Report message to a moderator

Re: ora:00257 [message #259088 is a reply to message #259080]

Tue, 14 August 2007 06:34

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

please tell me

how to do

Report message to a moderator

Re: ora:00257 [message #259093 is a reply to message #259088]

Tue, 14 August 2007 06:43

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Are you a DBA? Do you have full privilege?

Regards
Michel

Report message to a moderator

Re: ora:00257 [message #259132 is a reply to message #259088]

Tue, 14 August 2007 08:51

joy_division
Messages: 4963
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.

Report message to a moderator

Re: ora:00257 [message #259199 is a reply to message #259080]

Tue, 14 August 2007 11:25

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

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.

Report message to a moderator

Re: ora:00257 [message #259589 is a reply to message #259287]

Thu, 16 August 2007 01:02

anamika_025
Messages: 81
Registered: July 2007
Location: Indore

Member

thanks a lot

Report message to a moderator

Previous Topic:	dump
Next Topic:	How doese oracle work when getting some cols from database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 20:25:27 CDT 2024