OraFAQ Forum: Server Administration » archive destination got full

Home » RDBMS Server » Server Administration » archive destination got full (oracle 10.2.0.1,windows)

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

archive destination got full [message #310432]

Tue, 01 April 2008 04:42

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

hi EXperts,
I am getting this whenever i am trying to connect users on 10g
please help me out.

ORA-00257: archiver error. Connect internal only, until freed.

Warning: You are no longer connected to ORACLE.
SQL> host
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 19
Next log sequence to archive 19
Current log sequence 21
SQL> conn PROD/PROD
archive log destination is this
please help me out.

Thanks,
Daniesh

Report message to a moderator

Re: archive destination got full [message #310433 is a reply to message #310432]

Tue, 01 April 2008 04:44

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Free space in your archive file system or enlarge it.

Regards
Michel

Report message to a moderator

Re: archive destination got full [message #310437 is a reply to message #310433]

Tue, 01 April 2008 04:57

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

i cannot find a archive destination please help me

Report message to a moderator

Re: archive destination got full [message #310439 is a reply to message #310437]

Tue, 01 April 2008 05:01

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Did you try

show parameter  USE_DB_RECOVERY_FILE_DEST

Report message to a moderator

Re: archive destination got full [message #310443 is a reply to message #310432]

Tue, 01 April 2008 05:14

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

show parameter DB_RECOVERY_FILE_DEST

Report message to a moderator

Re: archive destination got full [message #310448 is a reply to message #310443]

Tue, 01 April 2008 05:28

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

SQL> show parameter DB_RECOVERY_FILE_DEST

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string x:\flash_recovery_area
db_recovery_file_dest_size big integer 2G
the o/p have pasted above
i need to tell you one more thing was taking import . i am able to connect to database but when u try to connect to user for which i took a import. i am getting this error.
please help me .

Report message to a moderator

Re: archive destination got full [message #310458 is a reply to message #310432]

Tue, 01 April 2008 06:17

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

x:\flash_recovery_area

This is your flash recovery area.

SQL>alter system set db_recovery_file_dest_size=4g scope=both;

Report message to a moderator

Re: archive destination got full [message #310460 is a reply to message #310458]

Tue, 01 April 2008 06:24

daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india

Member

i want to say that imp got stuck. i move some of the arhives to another path
after that i fired a shutdown. its taking lots of time.

Report message to a moderator

Re: archive destination got full [message #310464 is a reply to message #310432]

Tue, 01 April 2008 06:34

varu123
Messages: 754
Registered: October 2007

Senior Member

Quote:

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.

Report message to a moderator

Re: archive destination got full [message #310800 is a reply to message #310432]

Wed, 02 April 2008 08:02

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Whether it is caused by imp or not you would follow the same rules.
You can have a look at,
http://arjudba.blogspot.com/2008/04/ora-00257-archiver-error-connect.html

Report message to a moderator

Previous Topic:	Migrating from oracle 9i to 10g
Next Topic:	partition allocation.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 12 07:05:34 CDT 2026