You might have enough space now, but if error is from yesterday and someone in the mean time freed the arh. Hi Lauri, two things to consider: 1) are you sure you checked the right directory for free space 2) are you sure you didn't find in alert.log some error that happened in the past? Check timestamp in alert.log. Delete expired archivelog all Thanks, Ragu. Take the backup of all the archivelog files and delete it. There should be enough free space available on the filesystem where archivelog files stored. Check the available space in destination directory using df -k (UNIX). SQL>show parameter log_archive Output shows your archivelog destination. Login as sysdba and then execute the below command to find archivelog file location. Re: Re-ORA-00257: archiver error when a database job is executed This configuration is not set in my situation. Re-ORA-00257: archiver error when a database job is executed Re: ORA-00257: archiver error when a database job is executedĬheck the archivelog space used using the below query, select space_limit/1048576,space_used/1048576 from v$recovery_file_dest Delete the archivelog files using the below query (RMAN) crosscheck archivelog all Delete expired archivelog all Thanks, Ragu. If you think this item violates copyrights, please click here Any idea where I should investigate further? Kind Regards. ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851 ORA-06512: at "SYS.DBMS_IREFRESH", line 683 ORA-06512: at "SYS.DBMS_REFRESH", line 195 ORA-06512: at line 1 Yes, there is sufficient disk space for the archiving location. ![]() Hi, In one database I have a scheduled job that generate the following message in the alert log ORA-12012: error on auto execute of job 185 ORA-00257: archiver error. ORA-00257: archiver error when a database job is executed
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |