Home > Database > Mysql Tutorial > 使用旧的控制文件恢复

使用旧的控制文件恢复

WBOY
Release: 2016-06-07 17:19:36
Original
1103 people have browsed it

在做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

数据库检测控制文件和数据文件的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>

linux

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template