恢复数据库的redo日志文件(由于异常关机引起)
需要事先进入sqlplus
select * from v$log
打印相关文件信息
1、recover database until cancel(recover database using backup controlfile until cancel)
2、cancel
3、alter database open resetlogs
需要事先进入sqlplus
select * from v$log
打印相关文件信息
1、recover database until cancel(recover database using backup controlfile until cancel)
2、cancel
3、alter database open resetlogs