Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
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
————————————————————————
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 16:36 , Processed in 0.047245 second(s), 22 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569