磁盘损坏，system及部分数据文件丢失

最新推荐文章于 2024-06-28 15:35:16 发布

转载最新推荐文章于 2024-06-28 15:35:16 发布 · 166 阅读

本文介绍如何在Oracle 9.2.0.7 RAC环境中，通过关闭数据库、修复损坏磁盘区并恢复datafile文件来完成数据库的恢复过程。在确保controlfile完好的情况下，首先将一个实例启动至mount状态，并进行介质恢复；随后开启实例1的数据库，再在节点2上启动另一个实例。

Oracle 9.2.0.7 RAC 2 NODES .

将rac production数据库关闭，修复损坏磁盘区，将备份的datafile 文件(这里我们使用standby datafiles) restore 到修复后的磁盘中，然后将rac数据库中一个实例开启为mount 状态 (当然前提是controlfile是没有损坏的)，在这个节点上做恢复， recover automatic database , 介质恢复完成后， alter database open ; 开启实例1的库。然后直接在节点2上 startup 开启库，开启过程需要较长时间。

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1679366908 bytes
Fixed Size                   453372 bytes
Variable Size             620756992 bytes
Database Buffers         1056964608 bytes
Redo Buffers                1191936 bytes
Database mounted.

SQL> recover automatic database ;
Media recovery complete.

SQL>

节点1上在恢复的时候的log :

DELL-RAC01$tail -f alert_orcl1.log
This instance was first to mount
LCK0 started with pid=19
Sun May 1 14:25:49 2011
Successful mount of redo thread 1, with mount id 1277774953
Sun May 1 14:25:49 2011
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE).
Completed: ALTER DATABASE   MOUNT
Sun May 1 14:25:57 2011
ALTER DATABASE RECOVER automatic database
Media Recovery Start
Sun May 1 14:29:22 2011
Recovery of Online Redo Log: Thread 2 Group 7 Seq 16023 Reading mem 0
Mem# 0 errs 0: /ocfs_ctrl_redo/orcl/redo07.log
Mem# 1 errs 0: /ocfs_data/orcl/redo07b.log
Sun May 1 14:29:22 2011
Recovery of Online Redo Log: Thread 1 Group 1 Seq 38430 Reading mem 0
Mem# 0 errs 0: /ocfs_ctrl_redo/orcl/redo01.log
Mem# 1 errs 0: /ocfs_data/orcl/redo01b.log
Sun May 1 14:29:23 2011
Recovery of Online Redo Log: Thread 1 Group 4 Seq 38431 Reading mem 0
Mem# 0 errs 0: /ocfs_ctrl_redo/orcl/redo04.log
Mem# 1 errs 0: /ocfs_data/orcl/redo04b.log
Media Recovery Complete
Completed: ALTER DATABASE RECOVER automatic database

startup 开启节点2上的库时的 alert log ：

DELL-RAC02$tail -f alert_orcl2.log
Reconfiguration complete
LCK0 started with pid=19
Sun May 1 14:32:04 2011
Successful mount of redo thread 2, with mount id 1277774953
Sun May 1 14:32:04 2011
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE).
Completed: ALTER DATABASE MOUNT
Sun May 1 14:32:05 2011
ALTER DATABASE OPEN
Picked Lamport scheme to generate SCNs
Sun May 1 14:38:02 2011
LGWR: Primary database is in CLUSTER CONSISTENT mode
Sun May 1 14:38:17 2011
Thread 2 opened at log sequence 16023
Current log# 7 seq# 16023 mem# 0: /ocfs_ctrl_redo/orcl/redo07.log
Current log# 7 seq# 16023 mem# 1: /ocfs_data/orcl/redo07b.log
Successful open of redo thread 2
Sun May 1 14:38:17 2011
SMON: enabling cache recovery
Sun May 1 14:38:19 2011
Successfully onlined Undo Tablespace 10.
Sun May 1 14:38:19 2011
SMON: enabling tx recovery
Sun May 1 14:38:19 2011
Database Characterset is AL32UTF8
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN