XMD RAC(Oracle 9i) 存儲修復處理(二)
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博客 ” ，链接：https://blog.itpub.net/25198367/viewspace-694303/ ，如需转载，请注明出处，否则将追究法律责任。
