ORA-00257 : PL/SQL DEVELOPER
queryz
Posted messages
110
Status
Membre
-
baronmow Posted messages 8 Status Membre -
baronmow Posted messages 8 Status Membre -
Hello,
When I try to access my datamart on pl/sql, I get this message:
ORA-00257: archiver error. Connect internal only, until freed
How can I fix this problem? Apparently, this would be a storage issue! What space needs to be freed?? And how can I access it?
When I try to access my datamart on pl/sql, I get this message:
ORA-00257: archiver error. Connect internal only, until freed
How can I fix this problem? Apparently, this would be a storage issue! What space needs to be freed?? And how can I access it?
Configuration: Windows XP Internet Explorer 6.0
6 réponses
Hello
In theory, the folder where the redo logs are archived is available from Oracle; but since Oracle is not available for you, the easiest thing was to install a database to guide you. So I installed Oracle 10g Express Edition on Windows XP, and I then enabled archive log mode.
A little disappointment along the way: Oracle does not keep the log_archive_dest parameter up to date. Until Oracle 9.2, it was, but not anymore :-(
I threw a few alter system switch logfile; (that's my sync for me) and I went on the hunt for small recent files.
And I found in C:\oraclexe\app\oracle\flash_recovery_area\XE a folder called ARCHIVELOG. This folder contains a folder dated today (yyyy_mm_dd). And in this folder dated today, there are files O1_MF_1_n_xxxxxx_.ARC where n is a number (which for me starts at 4) and xxxxx is a sort of serial number certainly to verify that such archivelog is indeed intended for such instance.
So, if you also have an ARCHIVELOG folder that contains a folder for each day with .ARC files inside, I think you just need to delete them to be able to start your database without any issues. Just don't forget to disable this archivelog mode to avoid getting stuck again.
In theory, the folder where the redo logs are archived is available from Oracle; but since Oracle is not available for you, the easiest thing was to install a database to guide you. So I installed Oracle 10g Express Edition on Windows XP, and I then enabled archive log mode.
A little disappointment along the way: Oracle does not keep the log_archive_dest parameter up to date. Until Oracle 9.2, it was, but not anymore :-(
I threw a few alter system switch logfile; (that's my sync for me) and I went on the hunt for small recent files.
And I found in C:\oraclexe\app\oracle\flash_recovery_area\XE a folder called ARCHIVELOG. This folder contains a folder dated today (yyyy_mm_dd). And in this folder dated today, there are files O1_MF_1_n_xxxxxx_.ARC where n is a number (which for me starts at 4) and xxxxx is a sort of serial number certainly to verify that such archivelog is indeed intended for such instance.
So, if you also have an ARCHIVELOG folder that contains a folder for each day with .ARC files inside, I think you just need to delete them to be able to start your database without any issues. Just don't forget to disable this archivelog mode to avoid getting stuck again.
Hi
I don't have my manual on hand, but it smells like the volume is full.
Could it be that the volume where your archivelogs are stored is full? Since the archiver can no longer save its redologs, it blocks all activity and only allows internal connections (which, as we all know, does not trigger any activity).
I don't have my manual on hand, but it smells like the volume is full.
Could it be that the volume where your archivelogs are stored is full? Since the archiver can no longer save its redologs, it blocks all activity and only allows internal connections (which, as we all know, does not trigger any activity).
Hi, thanks for your response, but I have no idea where ARCHIVELOG is located. Is it in the software's folder?