使用旧的控制文件恢复
来源:互联网 发布:武汉完美网络 编辑:程序博客网 时间:2024/06/14 17:15
备份控制文件
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
在做resetlogs启数据库也会因为数据文件内部一致而中止,需要恢复
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recoveryto 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
数据库检测控制文件和数据文件的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: {<RET>=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
这个文件还没归档因为是current组还没来得及切换日志(切换日志才能归档)提供redo给它一组组尝试
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: {<RET>=suggested | filename |AUTO | CANCEL}
/u01/tiger/oradata/orcl2/redo01.log
Log applied.
Media recovery complete.
SQL> alter database openresetlogs;
Database altered.
SQL>
- 使用旧的控制文件恢复
- 使用旧的控制文件恢复数据库
- 使用旧的控制文件恢复数据库
- 数据库恢复起点判定(使用旧控制文件)
- 旧控制文件恢复新数据库结构
- 旧控制文件,新日志,怎样恢复?
- 旧数据文件,旧控制文件,新日志,怎样恢复?
- 用备份控制文件做不完全恢复下的完全恢复(数据文件备份<旧>--新建表空间--控制文件备份<次新>--日志归档文件<新>)
- 控制文件的恢复
- 控制文件的恢复
- oracle用控制文件旧备份恢复后数据库恢复总结
- oracle用控制文件旧备份恢复后数据库恢复总结
- 使用rman恢复控制文件
- 使用rman恢复控制文件
- 如何使用备份的控制文件做完全恢复
- 丢失控制文件的恢复
- 控制文件的恢复(二进制)
- 关于控制文件的恢复
- android系统学习笔记二
- Linux的inode的理解
- uboot在2440上的移植
- Qt 触摸屏校准
- 时间工具类[DateUtil] 2
- 使用旧的控制文件恢复
- 修改Tomcat内存大小
- Android Bitmap和Canvas学习笔记
- uva993 - Product of digits-------------水题 1A
- sql 2005 与 SQL2008共存 SQL2008连接不上,2005可以连接上
- android系统学习笔记三
- 山区行
- Android图像处理之Bitmap类
- 婴儿补钙汤-骨头汤加醋汤