系统掉电，ORACLE启动失败报错，紧急求助

davidli · 发表于 2010-10-26 05:18:55

本帖最后由 anhongkui 于 2010-10-03 16:05 编辑
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_arc1_6241.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 4294967296 bytes is 98.11% used, and has 81245696 remaining bytes available.
Sun Oct  3 14:54:16 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************************************
Sun Oct  3 14:54:16 2010
Errors in file /u01/app/oracle/admin/orcl/udump/orcl_ora_6159.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/opt/oracle/oradata/rundata/undotbs01.dbf'
Sun Oct  3 14:54:16 2010
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 6159
ORA-1092 signalled during: alter database open...
谢谢~~

拿钱发帖死全家 · 发表于 2010-10-26 05:36:05

注意看报错信息：
ORA-19815: WARNING: db_recovery_file_dest_size of 4294967296 bytes is 98.11% used, and has 81245696 remaining bytes available.
你的db_recovery_file_dest空间不够了

anhongkui · 发表于 2010-10-26 06:08:45

本人新手，应如何操作？谢谢

anhongkui · 发表于 2010-10-26 07:20:13

SQL> startup mount
ORACLE instance started.
Total System Global Area 2801795072 bytes
Fixed Size                2086576 bytes
Variable Size          587204944 bytes
Database Buffers       2197815296 bytes
Redo Buffers             14688256 bytes
Database mounted.
SQL> select * from v$recovery_file_dest;
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/opt/oracle/oradata/rundata/flashback_dest
4294967296 4213721600                0             16
SQL>

anhongkui · 发表于 2010-10-26 08:11:22

SQL> alter database noarchivelog;
alter database noarchivelog
*
ERROR at line 1:
ORA-01143: cannot disable media recovery - file 2 needs media recovery
ORA-01110: data file 2: '/opt/oracle/oradata/rundata/undotbs01.dbf'
SQL>
不知道怎么办才好了。

拿钱发帖死全家 · 发表于 2010-10-26 08:32:22

db_recovery_file_dest空间不够了：
SQL> select * from v$recovery_file_dest;
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
/opt/oracle/oradata/rundata/flashback_dest
4294967296 4213721600 0 16
在系统里df -h看看磁盘空间还够么？
要是够的话就扩一下

拿钱发帖死全家 · 发表于 2010-10-26 09:45:46

startup database mount;
recover database;
恢复一下数据库应该就好了

拿钱发帖死全家 · 发表于 2010-10-26 10:26:34

问题是你的系统非正常掉电，recover区数据有太多需要恢复

duolanshizhe · 发表于 2010-10-26 11:06:06

应该是有坏高兴

ly_nye · 发表于 2010-10-26 12:03:06

明显的回滚表空间坏掉了，不关flash_recovery_area什么事了。