ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 磁盘损坏,system及部分数据文件丢失

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

原创 Linux操作系统 作者:tolywang 时间:2011-05-01 14:40:26 0 删除 编辑

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

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-694203/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13475462