系统环境
OS WINDOWS 2003
Oracle版本 10g
1 背景
5月5号中午的时候，突然Oracle所在的服务器蓝屏无法修复。PE进去拷贝Oracle目录下的所有文件
2 恢复流程
这台服务器正好有一台镜像主机 最后同步时间是4/30号
于是拷贝Oracle目录覆盖镜像主机的Oracle然后启动数据库
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> shutdown immediate;
ORA-01109: 数据库未打开
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。
Total System Global Area 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 125832068 bytes
Database Buffers 478150656 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
SQL> recover database until time '2014.5.5 11:33:29'
ORA-00283: 恢复会话因错误而取消
ORA-00314: 日志 3 (用于线程 1) 要求的序号 1366 与 1363 不匹配
ORA-00312: 联机日志 3 线程 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\REDO03.LOG'
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 1364 52428800 1 NO INACTIVE
47637675 04-5月 -14
3 1 1366 52428800 1 NO CURRENT
47711411 05-5月 -14
2 1 1365 52428800 1 NO INACTIVE
47662427 04-5月 -14
想恢复到5月5号之前的数据 是什么原因？
下面是alert_log
Mon May 12 14:58:40 2014
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 117440512
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
spfile = D:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEINTERLIB.ORA
sga_target = 612368384
control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\INTERLIB\CONTROL03.CTL
db_block_size = 8192
__db_cache_size = 478150656
compatible = 10.2.0.1.0
db_file_multiblock_read_count= 16
db_recovery_file_dest = d:\oracle\product\10.2.0/flash_recovery_area
db_recovery_file_dest_size= 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =