1.If all the nodes in the cluster are needed in order to perform adequately, then it is not HA ( High Availability) 2.RAC only makes up one piece of the MAA(Maximum Availability Architecture); it does not account for all possible problems.

Pages

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.