由于机房突然掉电，发现有一台开发用数据库无法正常启动，看来是文件损坏了，没有备份，55555555
SQL> startupORACLE instance started.
Total System Global Area 901775360 bytesFixed Size 2024944 bytesVariable Size 155191824 bytesDatabase Buffers 742391808 bytesRedo Buffers 2166784 bytesDatabase mounted.ORA-01115: IO error reading block from file 3 (block # 28760)ORA-01110: data file 3: '/u02/oradata/devdb/sysaux01.dbf'ORA-27072: File I/O errorLinux-x86_64 Error: 2: No such file or directoryAdditional information: 4Additional information: 28758Additional information: 8192ORA-01115: IO error reading block from file 3 (block # 28759)ORA-01110: data file 3: '/u02/oradata/devdb/sysaux01.dbf'ORA-27072: File I/O errorLinux-x86_64 Error: 2: No such file or directoryAdditional information: 4Additional information: 28758Additional information: 8192
辅助表空间坏了，看来是硬盘了问题了，文档上说辅助表空间不可用时，oracle的核心功能是可用的，于是将破坏的文件去掉试试。SQL> startup mountORACLE instance started.
Total System Global Area 901775360 bytesFixed Size 2024944 bytesVariable Size 155191824 bytesDatabase Buffers 742391808 bytesRedo Buffers 2166784 bytesDatabase mounted.SQL> alter database datafile '/u02/oradata/devdb/sysaux01.dbf' offline drop;
Database altered.
SQL> alter database open;
Database altered.
果然可以，试试一般功能是可用的，但全文索引，exp users等是不可用的，还好exp tables是可用的，可以重新装一台，将数据导过去。
转载于:https://www.cnblogs.com/seawwh/archive/2011/11/04/2235878.html
