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>
========
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>
This comment has been removed by the author.
ReplyDelete