恢复2：
来源：互联网 发布：优学院软件下载 编辑：程序博客网 时间：2024/05/27 21:03
前提：
所有归档文件及日志文件正常，丢失所有数据文件和控制文件，但有以前老的控制文件和数据文件备份，但老的数据文件备份不包括新增加的数据文件，（即数据文件是不全的）
SQL> startup;
ORACLE instance started.
Total System Global Area
FixedSize
VariableSize
DatabaseBuffers
RedoBuffers
ORA-01991: ???????'d:\oracle\product\10.1.0\db_1\DATABASE\PWDmyoracle.ORA'
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-38760: ???????????????
SQL> alter session set nls_language=american;
Session altered.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-38760: This database instance failed to turn on flashbackdatabase
Alertlog中：
Errors in filed:\oracle\product\10.1.0\admin\myoracle\bdump\myoracle_rvwr_1228.trc:
ORA-38739: Flashback log file is more recentthan control file.
ORA-38701: Flashback database log 49 seq 125 thread 1:"D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\FLASHBACK\O1_MF_53LT4BBM_.FLB"
Tue Jul 14 14:26:37 2009
Database mounted in Exclusive Mode.
ORA-1991 signalled during: ALTERDATABASE
Tue Jul 14 14:32:18 2009
alter database open
Tue Jul 14 14:32:19 2009
ORA-38760 signalled during: alter database open...
Tue Jul 14 14:32:40 2009
alter database open
Tue Jul 14 14:32:40 2009
ORA-38760 signalled during: alter database open...
Tue Jul 14 14:34:05 2009
SQL> recover database usingbackup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-38760: This database instance failed to turn on flashbackdatabase
alertlog中：
ALTER DATABASE RECOVER
Tue Jul 14 14:34:05 2009
Media Recovery Start
Media Recovery failed with error38760
ORA-283 signalled during: ALTER DATABASE RECOVER
Tue Jul 14 14:35:23 2009
SQL> archive log list;
Database logmode
Automaticarchival
Archivedestination
Oldest online logsequence
Next log sequence to archive
Current logsequence
SQL> select flashback_on fromv$database;
FLA
---
YES
SQL> alter databaseflashback off;
Database altered.
alter database flashback off
Tue Jul 14 14:35:23 2009
Deleted Oracle managed fileD:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\FLASHBACK\O1_MF_53JZNV4B_.FLB
Deleted Oracle managed fileD:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\FLASHBACK\O1_MF_53L1MDGD_.FLB
。。。。。。。。。。。。。
Deleted Oracle managed fileD:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\FLASHBACK\O1_MF_53MGNS5F_.FLB
Deleted Oracle managed fileD:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\FLASHBACK\O1_MF_53MGYQB7_.FLB
Flashback Database Disabled
Starting control autobackup
db_recovery_file_dest_size of 6144 MB is 34.20% used. This isa
user-specified limit on the amount of space that will be used bythis
database for recovery-related files, and does not reflect theamount of
space available in the underlying filesystem or ASMdiskgroup.
Created Oracle managed fileD:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\AUTOBACKUP\2009_07_14\O1_MF_S_689945766_55R9SM2M_.BKP
Control autobackup written to DISK device
Completed: alter database flashback off
Tue Jul 14 14:35:42 2009
ALTER DATABASE RECOVER
Media Recovery Start
WARNING! Recovering data file 1 from a fuzzy file. If not thecurrent file
it might be an online backup taken without entering the beginbackup command.
WARNING! Recovering data file 2 from a fuzzy file. If not thecurrent file
it might be an online backup taken without entering the beginbackup command.
Starting datafile 1 with incarnation depth 0 in thread 1 sequence551
Datafile 1:'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF'
Starting datafile 2 with incarnation depth 0 in thread 1 sequence551
Datafile 2:'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\UNDOTBS01.DBF'
Starting datafile 3 with incarnation depth 0 in thread 1 sequence551
Datafile 3:'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSAUX01.DBF'
Starting datafile 4 with incarnation depth 0 in thread 1 sequence551
Datafile 4:'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\USERS01.DBF'
Starting datafile 5 with incarnation depth 0 in thread 1 sequence551
Datafile 5:'D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\DUREX.ORA'
Starting datafile 6 with incarnation depth 0 in thread 1 sequence551
Datafile 6: 'D:\TEST\TEST.DBF'
Starting datafile 7 with incarnation depth 0 in thread 1 sequence551
Datafile 7: 'D:\TEST\JERRY_UNDO.DBF'
Media Recovery Log
ORA-279 signalled during: ALTER DATABASE RECOVER
Tue Jul 14 14:36:34 2009
ALTER DATABASERECOVER
Tue Jul 14 14:36:34 2009
Media Recovery Log auto;
Errors with log auto;
ORA-308 signalled during: ALTER DATABASERECOVER
Tue Jul 14 14:36:53 2009
ALTER DATABASERECOVER
Tue Jul 14 14:36:54 2009
WARNING: Cannot delete Oracle managed fileD:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_05_28\O1_MF_1_2845_51V37T7S_.ARC
Tue Jul 14 14:36:54 2009
Errors in filed:\oracle\product\10.1.0\admin\myoracle\udump\myoracle_ora_1372.trc:
ORA-01265: Unable to delete ARCHIVED LOGD:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_05_28\O1_MF_1_2845_51V37T7S_.ARC
ORA-27056: could not delete file
OSD-04029: 无法获取文件属性
O/S-Error: (OS 3) 系统找不到指定的路径。
SQL> recover database usingbackup controlfile until cancel;--使用老的控制文件进行恢复
ORA-00279: change 14779437 generated at 06/19/2009 11:00:26 neededfor threa
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\
F_1_70_%U_.ARC
ORA-00280: change 14779437 for thread 1 is in sequence #70
Specify log: {<RET>=suggested |filename | AUTO | CANCEL}
auto;
ORA-00308: cannot open archived log 'auto;'
ORA-27041: unable to open file
OSD-04002: ????????????
O/S-Error: (OS 2) ??????????????????????
Specify log: {<RET>=suggested |filename | AUTO | CANCEL}
auto;
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1
F_1_303_%U_.ARC
ORA-00280: change 15789408 for thread 1 is in sequence #303
ORA-00278: log file
'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_06_30\O
MF_1_302_54M43C3B_.ARC' no longer needed for this recovery
ORA-00283: recovery session canceled due toerrors
ORA-01244: unnamed datafile(s) added to controlfile by mediarecovery
ORA-01110: data file 8: 'D:\TEST\TEST0630.DBF'
ORA-01112: media recovery not started
SQL> recover database usingbackup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 8 is unknown - rename to correctfile
ORA-01110: data file 8: 'C:\WINDOWS\SYSTEM32\UNNAMED00008'
ORA-01157: cannot identify/lock data file 8 - see DBWR tracefile
ORA-01111: name for data file 8 is unknown - rename to correctfile
ORA-01110: data file 8:'C:\WINDOWS\SYSTEM32\UNNAMED00008'
SQL> select name from v$datafile;
NAME
------------------------------------------------------------------------------
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\UNDOTBS01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSAUX01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\USERS01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\DUREX.ORA
D:\TEST\TEST.DBF
D:\TEST\JERRY_UNDO.DBF
C:\WINDOWS\SYSTEM32\UNNAMED00008
8 rows selected.
由于使用的是备份的控制文件进行恢复，该文件中不包含后增加的文件，恢复过程中会缺省的赋予一个文件名（本例子为UNNAMED00008)
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for databaseopen
SQL> alter database create datafile'C:\WINDOWS\SYSTEM32\UNNAMED00008' as 'd:\te
st\test0630.dbf'; --重新创建后来丢失的数据文件
Database altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\UNDOTBS01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSAUX01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\USERS01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\DUREX.ORA
D:\TEST\TEST.DBF
D:\TEST\JERRY_UNDO.DBF
D:\TEST\TEST0630.DBF
8 rows selected.
继续恢复
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_M
F_1_533_%U_.ARC
ORA-00280: change 16696992 for thread 1 is in sequence #533
ORA-00278: log file
'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_09\O1_
MF_1_532_55BNC0MQ_.ARC' no longer needed for this recovery
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to controlfile by mediarecovery
ORA-01110: data file 8: 'D:\TEST\BLOCK.DBF'
ORA-01112: media recovery not started
SQL> recover database using backup controlfile untilcancel;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 8 is unknown - rename to correctfile
ORA-01110: data file 8: 'C:\WINDOWS\SYSTEM32\UNNAMED00008'
ORA-01157: cannot identify/lock data file 8 - see DBWR tracefile
ORA-01111: name for data file 8 is unknown - rename to correctfile
ORA-01110: data file 8: 'C:\WINDOWS\SYSTEM32\UNNAMED00008'
SQL> alter database create datafile'C:\WINDOWS\SYSTEM32\UNNAMED00008' as 'd:\te
st\block.dbf';
Database altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSTEM01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\UNDOTBS01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\SYSAUX01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\USERS01.DBF
D:\ORACLE\PRODUCT\10.1.0\ORADATA\MYORACLE\DUREX.ORA
D:\TEST\TEST.DBF
D:\TEST\JERRY_UNDO.DBF
D:\TEST\BLOCK.DBF
8 rows selected.
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_M
F_1_551_%U_.ARC
ORA-00280: change 16802584 for thread 1 is in sequence #551
ORA-00278: log file
'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_10\O1_
MF_1_550_55F14JPL_.ARC' no longer needed for this recovery
ORA-00283: recovery session canceled due toerrors
ORA-01244: unnamed datafile(s) added to controlfile by mediarecovery
ORA-01110: data file 8: 'D:\TEST01.DBF'
ORA-01112: media recovery not started
SQL> recover database using backup controlfile untilcancel;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 8 is unknown - rename to correctfile
ORA-01110: data file 8: 'C:\WINDOWS\SYSTEM32\UNNAMED00008'
ORA-01157: cannot identify/lock data file 8 - see DBWR tracefile
ORA-01111: name for data file 8 is unknown - rename to correctfile
ORA-01110: data file 8: 'C:\WINDOWS\SYSTEM32\UNNAMED00008'
ORA-00279: change 17215679 generated at 07/14/2009 11:01:04 neededfor thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_M
F_1_659_%U_.ARC
ORA-00280: change 17215679 for thread 1 is in sequence #659
ORA-00278: log file
'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_
MF_1_658_55QX7LK8_.ARC' no longer needed for this recovery
ORA-00283: recovery session canceled due to errors
ORA-01244: unnamed datafile(s) added to controlfile by mediarecovery
ORA-01110: data file 9: 'D:\TEST\TEST02.DBF'
ORA-01112: media recovery not started
SQL> recover database using backup controlfile untilcancel;
ORA-00283: recovery session canceled due to errors
ORA-01111: name for data file 9 is unknown - rename to correctfile
ORA-01110: data file 9: 'C:\WINDOWS\SYSTEM32\UNNAMED00009'
ORA-01157: cannot identify/lock data file 9 - see DBWR tracefile
ORA-01111: name for data file 9 is unknown - rename to correctfile
ORA-01110: data file 9: 'C:\WINDOWS\SYSTEM32\UNNAMED00009'
SQL> alter database create datafile'C:\WINDOWS\SYSTEM32\UNNAMED00009' as 'd:\te
st\test02.dbf';
Database altered.
SQL> recover database using backup controlfileuntil cancel;
ORA-00279: change 17218050 generated at 07/14/2009 11:45:55 neededfor thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_M
F_1_659_%U_.ARC
ORA-00280: change 17218050 for thread 1 is in sequence #659
Specify log: {<RET>=suggested |filename | AUTO | CANCEL}
auto
ORA-00279: change 17218557 generated at 07/14/2009 11:52:16 neededfor thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_M
F_1_660_%U_.ARC
ORA-00280: change 17218557 for thread 1 is in sequence #660
ORA-00278: log file
'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_
MF_1_659_55R07L2D_.ARC' no longer needed for this recovery
ORA-00308: cannot open archived log
'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_
MF_1_660_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: ????????????
O/S-Error: (OS 2) ??????????????????????
SQL> recover database using backup controlfile untilcancel;
ORA-00279: change 17218557 generated at 07/14/2009 11:52:16 neededfor thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_M
F_1_660_%U_.ARC
ORA-00280: change 17218557 for thread 1 is in sequence #660
Specify log: {<RET>=suggested |filename | AUTO | CANCEL}
auto;
ORA-00308: cannot open archived log 'auto;'
ORA-27041: unable to open file
OSD-04002: ????????????
O/S-Error: (OS 2) ??????????????????????
SQL> Alter session set nls_language=american;
Session altered.
SQL> recover database using backup controlfileuntil cancel;
ORA-00279: change 17218557 generated at 07/14/2009 11:52:16 neededfor thread 1
ORA-00289: suggestion :
D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_M
F_1_660_%U_.ARC
ORA-00280: change 17218557 for thread 1 is in sequence #660
Specify log: {<RET>=suggested |filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'D:\ORACLE\PRODUCT\10.1.0\FLASH_RECOVERY_AREA\MYORACLE\ARCHIVELOG\2009_07_14\O1_
MF_1_660_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: ????????????
O/S-Error: (OS 2) ??????????????????????
SQL> alter databaseopen;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for databaseopen
SQL> alter database openresetlogs;
Database altered.
恢复完成。
- 恢复2：
- 数据恢复恢复（2）：硬盘恢复那些基本软件
- 实战rman恢复(2)恢复到异机
- 恢复一例(2)
- db2 备份恢复 2
- 数据恢复(2)
- 备份恢复2
- 数据恢复(2)- ibd
- RMAN的备份与恢复（2）-SPFILE恢复
- 备份恢复2——备份恢复结构*
- Oracle归档模式下恢复-数据库完全恢复方法2
- MySQL 备份和恢复2
- Oracle恢复内部原理 2
- oracle表数据恢复2
- Oracle备份与恢复2
- Git Day 2:恢复文档
- oracle备份/恢复原理（2）
- MySQL 数据库的备份和恢复(2)
- Linux (x86) Exploit 开发系列教程之九 使用 unlink 的堆溢出
- mount时,为什么数据文件可以脱机而…
- 第一章 个人认识
- Oracle 不同版本的数据间的导入导…
- 恢复1：有所有归档文件，后增加数…
- 恢复2：
- ORA-01991错误
- MySQL Workbench已停止工作
- 我的面试总结
- ORA-19907: 恢复时间或 SCN 不属于…
- 详细说明函数指针
- ORA-10388: parallel query server…
- 从自动备份中恢复控制文件和SPFILE…
- 降低逻辑读优化SQL（转）
