本帖最后由 strayeagle 于 2010-12-24 19:40 编辑
外包公司的制度---悲哀
发现步骤 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. 查看数据库日志运行模式,发现是在归档模式下,上述错误码信息显示是out of space to store the redo log file.存储空间不足。 查看文件系统 oracle@mmsg:~> df Filesystem
1K-blocks
Used Available Use% Mounted on /dev/sda2
30969600
3364888
26031548
12% / udev
8218880
176
8218704
1% /dev /dev/sda5
50150072
29613880
17988688
63% /home /dev/sda6
41286796
39191128
0 100% /opt opt空间已满! 解决方法 1、停止数据录和监听,清除oracle目录下相关文件,包括告警、trace日志文件,以及在归档模式下产生的归档日志文件(dbs目录下的.dbf文件); 2、查看文件系统空间信息 oracle@mmsg:/opt/oraInventory> df Filesystem
1K-blocks
Used Available Use% Mounted on /dev/sda2
30969600
3364888
26031548
12% / udev
8218880
176
8218704
1% /dev /dev/sda5
50150072
29615732
17986836
63% /home /dev/sda6
41286796
35579632
3609880
91% /opt |