Wednesday, April 9, 2008

ORA-00257

If archive destination is out of space this messgae is thrown by Oracle.

Check the available space on the filesystem where archive destination is, if it is full then try to get some more free space there by either deleting the old archives or adding more disks. Here is from oracle:
oerr ora 257
00257, 00000, "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.

SQL> show parameters DB_RECOVERY

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

db_recovery_file_dest string /home/oracle/db/flash_recovery

_area

db_recovery_file_dest_size big integer 6399400M

#>bdf

Filesystem kbytes used avail %used Mounted on

/dev/vg00/lvol3 41074688 12137576 28711160 30% /

/dev/vg00/lvol1 1835008 155872 1666112 9% /stand

/dev/vg01/lvol1 958332928 958284976 44982 100% /home

DevFS 9 9 0 100% /dev/deviceFileSystem

#>cd archivelog/

oracle@test161(rp3440):/home/oracle/db/flash_recovery_area/ARCDB/archivelog

#>ll

total 736

drwxr-x--- 2 oracle oinstall 96 Mar 18 16:16 2008_03_18

drwxr-x--- 2 oracle oinstall 96 Mar 19 12:00 2008_03_19

drwxrwx--- 2 oracle oinstall 1024 Mar 20 16:30 2008_03_20

drwxrwx--- 2 oracle oinstall 102400 Mar 21 20:00 2008_03_21

drwxrwx--- 2 oracle oinstall 96 Mar 22 18:26 2008_03_22

drwxrwx--- 2 oracle oinstall 11264 Mar 23 23:56 2008_03_23

drwxrwx--- 2 oracle oinstall 129024 Mar 24 16:40 2008_03_24

drwxrwx--- 2 oracle oinstall 2048 Mar 25 23:29 2008_03_25

drwxrwx--- 2 oracle oinstall 1024 Mar 26 23:16 2008_03_26

drwxrwx--- 2 oracle oinstall 27648 Mar 27 20:57 2008_03_27

drwxrwx--- 2 oracle oinstall 16384 Mar 28 23:00 2008_03_28

drwxrwx--- 2 oracle oinstall 1024 Mar 29 15:00 2008_03_29

drwxrwx--- 2 oracle oinstall 96 Mar 30 02:10 2008_03_30

drwxrwx--- 2 oracle oinstall 24576 Mar 31 22:59 2008_03_31

drwxrwx--- 2 oracle oinstall 2048 Apr 1 23:00 2008_04_01

drwxrwx--- 2 oracle oinstall 10240 Apr 2 23:00 2008_04_02

drwxrwx--- 2 oracle oinstall 1024 Apr 3 10:33 2008_04_03

drwxrwx--- 2 oracle oinstall 1024 Apr 4 10:51 2008_04_04

drwxrwx--- 2 oracle oinstall 20480 Apr 8 17:36 2008_04_08

drwxrwx--- 2 oracle oinstall 9216 Apr 9 11:58 2008_04_09

After removing some old arc files:

#>bdf

Filesystem kbytes used avail %used Mounted on

/dev/vg00/lvol3 41074688 12137608 28711128 30% /

/dev/vg00/lvol1 1835008 155872 1666112 9% /stand

/dev/vg01/lvol1 958332928 616855429 320137182 66% /home

DevFS 9 9 0 100% /dev/deviceFileSystem

No comments:

Post a Comment