如果当前正在使用的日志损坏,一般按照以下步骤解决:[@more@]
1、冷备份(保留现场)
2、startup mount
3、alter system set "_allow_resetlogs_corruption"=true scope=spfile;
4、recover database using backup controlfile until cancel
选择cancel
5、alter database open resetlogs
6、shutdown immediate
7、startup 好的话可以顺利启动
8、export
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8007125/viewspace-942000/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
周末了,大家周末愉快!
下一篇：
需要重建索引的情况
请登录后发表评论
登录
全部评论
-
博文量105
-
访问量101550
最新文章
- 两表关联实验
- 没有硝烟的战场
- 终于又盼到周末了
- What is the first thing you will do in the morning?
- it is too hot of beijing today
- can i see the solar total eclipse tomorrow morning?
- It is the time to do exercise.
- What is the feeling of love?
- what will you do when you are bored?
- several colleague come here from changchun today
