- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 15:23:14
|
查看: 1289 |
回复: 0
刚刚,我把备份集跟归档都删除了,然后我用init.ora创建了SPFILE,控制文件有备份,就用RMAN恢复了,然后我打开数据库时提示:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/primary/system01.dbf'
--------------------------------------------------------------------------------------------------------
另外,我原本的DBF还都存在,这时我该如何恢复?
这个问题解决了,但又出现个新问题,
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 10 with name
"_SYSSMU10_3550978943$" too small
Process ID: 16586
Session ID: 1 Serial number: 7
无法打开数据库,还不能修改回滚段。这可如何是好
——————————————————————————
alter_xxx.log
ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10_3550978943$" too small
Error 704 happened during db open, shutting down database
USER (ospid: 16935): terminating the instance due to error 704
Instance terminated by USER, pid = 16935
ORA-1092 signalled during: ALTER DATABASE OPEN...
opiodr aborting process unknown ospid (16935) as a result of ORA-1092
Mon Jan 26 03:03:53 2015
ORA-1092 : opitsk aborting process
————————————————————————
|
|