ORACLE 跪求技术问题求大神帮助

最新推荐文章于 2024-02-17 14:35:54 发布

daijianjun1986

最新推荐文章于 2024-02-17 14:35:54 发布

阅读量370

点赞数

本文链接：https://blog.csdn.net/daijianjun1986/article/details/52461046

版权

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

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: '/oradata/sscq/raw7'

SQL> recover database using backup controlfile;
ORA-00279: change 223442728 generated at 08/28/2016 03:55:02 needed for thread
1
ORA-00289: suggestion : /arlog/1_8267_766015154.arc
ORA-00280: change 223442728 for thread 1 is in sequence #8267

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 15993 change 223446680 time 08/28/2016
05:28:10
ORA-00334: archived log: '/arlog/1_8267_766015154.arc'

ORA-01112: media recovery not started