在做resetlogs启数据库也会因为数据文件内部一致而中止,需要恢复
备份控制文件
alter database backup controlfileto ‘/bk/ctl.bk’;
SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
Oracle instance started.
Total System Global Area 314572800 bytes
Fixed Size 1219136 bytes
Variable Size 100664768 bytes
Database Buffers 205520896 bytes
Redo Buffers 7168000 bytes
ORA-00205: error in identifying control file, checkalert log for more info
SQL> ! /bk/ctl.bk/u01/tiger/oradata/orcl2/control02.ctl
/bin/bash: /bk/ctl.bk: ????
SQL> ! cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control02.ctl
SQL> ! cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control03.ctl
SQL> ! cp /bk/ctl.bk/u01/tiger/oradata/orcl2/control01.ctl
SQL> alter database mount;
Database altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option fordatabase open
需要恢复
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to beconsistent
ORA-01110: data file 1: ‘/u01/tiger/oradata/orcl2/system01.dbf’
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option mustbe done
SVN搭建及使用教学视频(布尔教育)
《SVN视频教程》，SVN:全称Subversion，是代码版本管理软件，管理着随时间改变的数据。这些数据放置在一个中央资料档案库 (repository) 中。这个档案库很像一个普通的文件服务器,不过它会记住每一次文件的变动。这样你就可以把档案恢复到旧的版本, 或是浏览文件的变动历史。许多人会把版本控制系統想像成某种“时光机器”。
709 查看详情
数据库检测控制文件和数据文件的SCN的对比，，发现控制文件是老的
SQL> recover database using backupcontrolfile;
ORA-00279: change 458762 generated at 09/03/201214:28:45 needed for thread 1
ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_2_%u_.arc
ORA-00280: change 458762 for thread 1 is insequence #2
Specify log: {=suggested | filename |AUTO | CANCEL}
auto
ORA-00279: change 458780 generated at 09/03/201214:50:27 needed for thread 1
ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_3_%u_.arc
ORA-00280: change 458780 for thread 1 is insequence #3
ORA-00278: log file’/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_2_848nst62_.arc’no longer
needed for this recovery
ORA-00279: change 458785 generated at 09/03/201214:50:35 needed for thread 1
ORA-00289: suggestion : /u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_4_%u_.arc
ORA-00280: change 458785 for thread 1 is insequence #4
ORA-00278: log file’/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_3_848nsvk0_.arc’no longer
needed for this recovery
ORA-00279: change 458791 generated at 09/03/201214:50:42 needed for thread 1
ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_5_%u_.arc
ORA-00280: change 458791 for thread 1 is insequence #5
ORA-00278: log file’/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_4_848nt295_.arc’no longer
needed for this recovery
ORA-00308: cannot open archived log’/u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_5_%u_.arc’
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
给它一组组尝试
SQL> recover database using backupcontrolfile;
ORA-00279: change 458791 generated at 09/03/201214:50:42 needed for thread 1
ORA-00289: suggestion : /u01/tiger/flash_recovery_area/ORCL2/archivelog/2012_09_03/o1_mf_1_5_%u_.arc
ORA-00280: change 458791 for thread 1 is insequence #5
Specify log: {=suggested | filename |AUTO | CANCEL}
/u01/tiger/oradata/orcl2/redo01.log
Log applied.
Media recovery complete.
SQL> alter database openresetlogs;
Database altered.
SQL>
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。
如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 chuangxiangniao@163.com 举报，一经查实，本站将立刻删除。
发布者：程序猿，转转请注明出处：https://www.chuangxiangniao.com/p/947483.html
微信扫一扫 
支付宝扫一扫 
