Home » RDBMS Server » Server Administration » archive destination got full (oracle 10.2.0.1,windows)
archive destination got full [message #310432] Tue, 01 April 2008 04:42 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 00:29:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.