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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 13:43:41 | 查看: 1252| 回复: 1
因其他人员误操作导致REDO丢失,ARCH丢失,控制文件丢失
控制文件我已手工建立,启动时报错

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/data/oracle/oradata/ALS/datafile/o1_mf_system_c70m7qxl_.dbf'


SQL> recover database using backup controlfile;
ORA-00279: change 85014328 generated at 05/27/2016 23:05:40 needed for thread 1
ORA-00289: suggestion :
/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912985538.dbf
ORA-00280: change 85014328 for thread 1 is in sequence #1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'/data/oracle/oradata/ALS/datafile/o1_mf_system_c70m7qxl_.dbf'

SQL> recover database using backup controlfile;
ORA-00279: change 85014328 generated at 05/27/2016 23:05:40 needed for thread 1
ORA-00289: suggestion :
/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912985538.dbf
ORA-00280: change 85014328 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912985538.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log
'/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912985538.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

SQL> recover database
;ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
2#
发表于 2017-4-13 13:45:04

pfile加了这3句还是不行
*._allow_resetlogs_corruption=TRUE
*._corrupted_rollback_segments= "_SYSSMU11_1017602384$"
*.undo_management=manual
==================================

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SQL> recover database until cancel;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.


SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode



SQL> startup nomount pfile=/home/oracle/newpfile.ora
ORACLE instance started.
。。。。。。  创建控制文件 ,此处省略
SQL> recover database using backup controlfile;
ORA-00279: change 85014336 generated at 05/28/2016 01:42:03 needed for thread 1
ORA-00289: suggestion :
/data/oracle/oracle/product/11.2.0/dbhome_1/dbs/arch1_1_912994922.dbf
ORA-00280: change 85014336 for thread 1 is in sequence #1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
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 11 with name
"_SYSSMU11_1017602384$" too small
Process ID: 18082
Session ID: 705 Serial number: 1

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-12-20 13:53 , Processed in 0.048295 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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