ITPub博客

首页 > Linux操作系统 > Linux操作系统 > XMD RAC(Oracle 9i) 存儲修復處理(二)

XMD RAC(Oracle 9i) 存儲修復處理(二)

原创 Linux操作系统 作者:golden_zhou 时间:2011-05-03 10:57:29 0 删除 编辑

R710 Standby :


[root@emd2rac orcl]# ls
ict_data27.dbf  log_data40.dbf  perfstat01.dbf  sn_data113.dbf  sn_data116.dbf  sn_data119.dbf
ict_data28.dbf  log_data41.dbf  sn_data111.dbf  sn_data114.dbf  sn_data117.dbf  track_data10.dbf
log_data39.dbf  log_data42.dbf  sn_data112.dbf  sn_data115.dbf  sn_data118.dbf  track_data11.dbf
[root@emd2rac orcl]# pwd

/ocfs_data3/orcl    /u01/ocfs_data3/orcl


SQL> alter system set standby_file_management=manual ;

alter database rename file '/ocfs_data3/orcl/ict_data27.dbf'  to  '/u01/ocfs_data3/orcl/ict_data27.dbf' ;
alter database rename file '/ocfs_data3/orcl/ict_data28.dbf'  to  '/u01/ocfs_data3/orcl/ict_data28.dbf' ;
alter database rename file '/ocfs_data3/orcl/log_data39.dbf'  to  '/u01/ocfs_data3/orcl/log_data39.dbf' ;

alter database rename file '/ocfs_data3/orcl/log_data40.dbf'  to  '/u01/ocfs_data3/orcl/log_data40.dbf' ;
alter database rename file '/ocfs_data3/orcl/log_data41.dbf'  to  '/u01/ocfs_data3/orcl/log_data41.dbf' ;
alter database rename file '/ocfs_data3/orcl/log_data42.dbf'  to  '/u01/ocfs_data3/orcl/log_data42.dbf' ;

alter database rename file '/ocfs_data3/orcl/perfstat01.dbf'  to  '/u01/ocfs_data3/orcl/perfstat01.dbf' ;
alter database rename file '/ocfs_data3/orcl/sn_data111.dbf'  to  '/u01/ocfs_data3/orcl/sn_data111.dbf' ;
alter database rename file '/ocfs_data3/orcl/sn_data112.dbf'  to  '/u01/ocfs_data3/orcl/sn_data112.dbf' ;

alter database rename file '/ocfs_data3/orcl/sn_data113.dbf'  to  '/u01/ocfs_data3/orcl/sn_data113.dbf' ;
alter database rename file '/ocfs_data3/orcl/sn_data114.dbf'  to  '/u01/ocfs_data3/orcl/sn_data114.dbf' ;
alter database rename file '/ocfs_data3/orcl/sn_data115.dbf'  to  '/u01/ocfs_data3/orcl/sn_data115.dbf' ;

alter database rename file '/ocfs_data3/orcl/sn_data116.dbf'  to  '/u01/ocfs_data3/orcl/sn_data116.dbf' ;
alter database rename file '/ocfs_data3/orcl/sn_data117.dbf'  to  '/u01/ocfs_data3/orcl/sn_data117.dbf' ;
alter database rename file '/ocfs_data3/orcl/sn_data118.dbf'  to  '/u01/ocfs_data3/orcl/sn_data118.dbf' ;

alter database rename file '/ocfs_data3/orcl/sn_data119.dbf'  to  '/u01/ocfs_data3/orcl/sn_data119.dbf' ;
alter database rename file '/ocfs_data3/orcl/track_data10.dbf'  to  '/u01/ocfs_data3/orcl/track_data10.dbf' ;
alter database rename file '/ocfs_data3/orcl/track_data11.dbf'  to  '/u01/ocfs_data3/orcl/track_data11.dbf' ;

 

 

 

[root@emd2rac orcl]# ls
log_index44.dbf  log_index49.dbf  sn_idx111.dbf  sn_idx116.dbf  sn_idx121.dbf  sn_idx126.dbf  sn_idx131.dbf
log_index45.dbf  log_index50.dbf  sn_idx112.dbf  sn_idx117.dbf  sn_idx122.dbf  sn_idx127.dbf  sn_idx132.dbf
log_index46.dbf  log_index51.dbf  sn_idx113.dbf  sn_idx118.dbf  sn_idx123.dbf  sn_idx128.dbf  sn_idx133.dbf
log_index47.dbf  log_index52.dbf  sn_idx114.dbf  sn_idx119.dbf  sn_idx124.dbf  sn_idx129.dbf  sn_idx134.dbf
log_index48.dbf  sn_idx110.dbf    sn_idx115.dbf  sn_idx120.dbf  sn_idx125.dbf  sn_idx130.dbf
[root@emd2rac orcl]# pwd

/ocfs_index2/orcl   /u01/ocfs_index2/orcl

 

alter database rename file '/ocfs_index2/orcl/log_index44.dbf'  to  '/u01/ocfs_index2/orcl/log_index44.dbf' ;
alter database rename file '/ocfs_index2/orcl/log_index45.dbf'  to  '/u01/ocfs_index2/orcl/log_index45.dbf' ;
alter database rename file '/ocfs_index2/orcl/log_index46.dbf'  to  '/u01/ocfs_index2/orcl/log_index46.dbf' ;
alter database rename file '/ocfs_index2/orcl/log_index47.dbf'  to  '/u01/ocfs_index2/orcl/log_index47.dbf' ;
alter database rename file '/ocfs_index2/orcl/log_index48.dbf'  to  '/u01/ocfs_index2/orcl/log_index48.dbf' ;

alter database rename file '/ocfs_index2/orcl/log_index49.dbf'  to  '/u01/ocfs_index2/orcl/log_index49.dbf' ;
alter database rename file '/ocfs_index2/orcl/log_index50.dbf'  to  '/u01/ocfs_index2/orcl/log_index50.dbf' ;
alter database rename file '/ocfs_index2/orcl/log_index51.dbf'  to  '/u01/ocfs_index2/orcl/log_index51.dbf' ;
alter database rename file '/ocfs_index2/orcl/log_index52.dbf'  to  '/u01/ocfs_index2/orcl/log_index52.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx110.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx110.dbf' ;

alter database rename file '/ocfs_index2/orcl/sn_idx111.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx111.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx112.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx112.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx113.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx113.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx114.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx114.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx115.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx115.dbf' ;

alter database rename file '/ocfs_index2/orcl/sn_idx116.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx116.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx117.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx117.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx118.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx118.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx119.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx119.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx120.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx120.dbf' ;

alter database rename file '/ocfs_index2/orcl/sn_idx121.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx121.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx122.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx122.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx123.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx123.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx124.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx124.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx125.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx125.dbf' ;

alter database rename file '/ocfs_index2/orcl/sn_idx126.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx126.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx127.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx127.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx128.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx128.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx129.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx129.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx130.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx130.dbf' ;

alter database rename file '/ocfs_index2/orcl/sn_idx131.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx131.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx132.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx132.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx133.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx133.dbf' ;
alter database rename file '/ocfs_index2/orcl/sn_idx134.dbf'  to  '/u01/ocfs_index2/orcl/sn_idx134.dbf' ; 


SQL> alter system set standby_file_management=auto ;

 

 

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>

 

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  

 

 

 

 

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/25198367/viewspace-694303/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-09

  • 博文量
    238
  • 访问量
    308303