Sunday 28 July 2013

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

Our Informatica load got failed with the below error.. Request you to please check and let us know the status of the and we are getting below error.
========

DB.

Database driver error...
CMN_1022 [
Database driver error...
Function Name : Logon
ORA-00257: archiver error. Connect internal only, until freed.

Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [SCOTT_SCH] and connection string [erpoltp].


CAUSE: Archive mount point got filled up.

[oraoltp ctssp] $ df -h /u01/data/arch
Filesystem size used avail capacity Mounted on
/dev/vx/dsk/u01dg/arch_vol
84G 84G 63M 100% /u01/data/arch


Alert logfile contain
=================
ORA-19502: write error on file "/u01/data/arch/log_812720774_1_78454.log", blockno 131073 (blocksize=512)
ORA-27063: number of bytes read/written is incorrect
Additional information: 65024
Additional information: 1048576
ORA-19502: write error on file "/u01/data/arch/log_812720774_1_78454.log", blockno 153601 (blocksize=512)
Sun Jul 21 05:02:18 EDT 2013
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/u01/data/arch/log_812720774_1_78454.log' (err
or 19502)
(erpoltp)


=======

Solution: Connect to database and change archive destination location.


[oraoltp ctssp] $ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.5.0 - Production on Sun Jul 21 05:03:12 2013

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> alter system set log_archive_dest='/u02/data/data2/arch_21july2013';

System altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/data/data2/arch_21july2013
Oldest online log sequence 78454
Next log sequence to archive 78454
Current log sequence 78457

SQL> !df -h /u02/data/data2/arch_21july2013
Filesystem size used avail capacity Mounted on
/dev/vx/dsk/erpoltpdbdg/data2_vol
452G 412G 38G 92% /u02/data/data2/arch_21july2013

Once archive backup completed change archive destination to old one.

SQL> !df -h /u01/data/arch
Filesystem size used avail capacity Mounted on
/dev/vx/dsk/erpoltpdg/arch_vol
84G 44G 38G 54% /u01/data/arch

SQL>

1 comment: