- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-12 23:10:40
|
查看: 1227 |
回复: 0
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR> Connected.
SVRMGR> start oracle
ORACLE instance started.
Total System Global Area 3362189776 bytes
Fixed Size 86480 bytes
Variable Size 1125343232 bytes
Database Buffers 2215772160 bytes
Redo Buffers 20987904 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/oracle/oradata/qqhryb/system01.dbf'
因为没有作过数据库恢复,还请大家帮忙~~~,谢谢!
恢复后报错如下:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/oracle/oradata/qqhryb/system01.dbf'
我是按照metalink 的 Note:183367.1
Common Causes and Solutions on ORA-1113 Error Found in Backup & Recovery 来做的,结果就是我上面贴的那个
已经依次(全部)输入在线日志,恢复后,并且在init*.ora中加入参数
_ALLOW_RESETLOGS_CORRUPTION = TRUE 后,启动数据库,但报错如下:
ORA-00603 ORACLE server session terminated by fatal error
之后只能用internal进入,并且只能取到用户的部分数据,咋办呢?
|
|