ORA-01589

SQL> startup
ORACLE instance started.

Total System Global Area 3.4340E+10 bytes
Fixed Size 2262088 bytes
Variable Size 2.8454E+10 bytes
Database Buffers 5771362304 bytes
Redo Buffers 112168960 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open.

 

解决方法：

SQL> recover database using backup controlfile;
ORA-00279: change 10236875878 generated at 09/20/2015 15:37:15 needed for
thread 1
ORA-00289: suggestion :
E:\ORACLE\ORADATA\FAST_RECOVERY_AREA\SEINESCM\ARCHIVELOG\2015_09_20\O1_MF_1_5502

2_%U_.ARC
ORA-00280: change 10236875878 for thread 1 is in sequence #55022

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
D:\oracledb\seinescm\O1_MF_4_B1SW3H6D_.LOG
Log applied.
Media recovery complete.
SQL>alter database open resetlogs;

 

 

http://blog.sina.com.cn/s/blog_95b5eb8c0100wz3f.html