机房的存储链路出现问题,重新启动服务器后,数据库可以成功加载,但是在应用提示oracle中的一个文件不能读。
sqlplus进入
sql>select file_id,online_status from dba_data_files order by 1;
发现其中的一个数据文件是recover状态
SQL> select file#, status, fuzzy, checkpoint_time, checkpoint_change#, resetlogs_change#, resetlogs_time from v$datafile_header where file#=148;
发现这个scn号比较小,看来还需要其他归档文件才能恢复数据
SQL> alter database recover datafile 148;
alter database recover datafile 148
*
ERROR at line 1:
ORA-00279: change 5608119792 generated at 01/12/2017 16:21:12 needed for thread
1
ORA-00289: suggestion : S:\ORACLE\PRDARCHARC59426_0845400201.001
ORA-00280: change 5608119792 for thread 1 is in sequence #259426
SQL> recover database;
ORA-00275: media recovery has already been started
SQL> alter database recover cancel;
Database altered.
SQL