免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12下一页
最近访问板块 发新帖
查看: 4107 | 回复: 10

系统掉电,ORACLE启动失败报错,紧急求助 [复制链接]

论坛徽章:
0
发表于 2010-10-03 14:57 |显示全部楼层
本帖最后由 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...



谢谢~~

论坛徽章:
0
发表于 2010-10-03 15:03 |显示全部楼层
注意看报错信息:
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空间不够了

论坛徽章:
0
发表于 2010-10-03 15:06 |显示全部楼层
本人新手,应如何操作?  谢谢

论坛徽章:
0
发表于 2010-10-03 15:11 |显示全部楼层
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>

论坛徽章:
0
发表于 2010-10-03 16:04 |显示全部楼层
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>



不知道怎么办才好了。

论坛徽章:
0
发表于 2010-10-03 23:39 |显示全部楼层
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看看磁盘空间还够么?
要是够的话就扩一下

论坛徽章:
0
发表于 2010-10-03 23:58 |显示全部楼层
startup database mount;
recover database;
恢复一下数据库应该就好了

论坛徽章:
0
发表于 2010-10-04 00:04 |显示全部楼层
问题是你的系统非正常掉电,recover区数据有太多需要恢复

论坛徽章:
3
CU大牛徽章
日期:2013-09-18 15:16:55CU大牛徽章
日期:2013-09-18 15:18:22CU大牛徽章
日期:2013-09-18 15:18:43
发表于 2010-10-04 16:58 |显示全部楼层
应该是有坏快乐

论坛徽章:
0
发表于 2010-10-05 09:55 |显示全部楼层
明显的回滚表空间坏掉了,不关flash_recovery_area什么事了。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP