Oracle 10g rac更换ASM磁盘组

最新推荐文章于 2024-04-17 21:43:07 发布
最新推荐文章于 2024-04-17 21:43:07 发布
阅读量562 收藏 1
点赞数
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/daf380/article/details/88395302
版权

一、环境介绍

Redhat 5.8+Oracle 10g rac (10.2.0.5)+ASM

二、需求：新建一个磁盘组hzdw2019，利用新的磁盘组（HZDW2019）替换原来的DATA磁盘组

三、步骤

3.1、为新磁盘组划分磁盘（略）

3.2、实施数据库全备

全备脚本如下：

run{ 
allocate channel c1 device type disk; 
allocate channel c2 device type disk; 
allocate channel c3 device type disk;  
crosscheck backup; 
sql 'alter system archive log current'; 
backup database format '+hzdw2019/db_%d_%T_%U'; 
sql 'alter system archive log current'; 
backup archivelog all format '+hzdw2019/arc_%t_%s' delete all input;  
backup current controlfile format '+hzdw2019/cntrl_%s_%p_%s'; 
crosscheck archivelog all; 
delete noprompt expired backup; 
delete noprompt obsolete; 
delete noprompt backup of database completed before 'sysdate - 7'; 
release channel c1; 
release channel c2; 
release channel c3; 
}

3.3、创建pfile文件

SQL> startup nomount pfile='/home/oracle/init_2019.ora';

3.4、各节点关闭数据库

3.5、节点一使用pfile启动数据库到nomount

SQL> startup nomount pfile='/home/oracle/init_2019.ora';
ORACLE instance started.

Total System Global Area  918552576 bytes
Fixed Size		    2100552 bytes
Variable Size		  255853240 bytes
Database Buffers	  654311424 bytes
Redo Buffers		    6287360 bytes
SQL>

3.6、还原控制文件

RMAN> restore controlfile from '+hzdw2019/cntrl_12_1_12';

Starting restore at 11-MAR-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=147 instance=rac1 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
output filename=+HZDW2019/rac/controlfile/current.272.1002622331
Finished restore at 11-MAR-19

RMAN>

3.7、修改数据库到mount

RMAN> sql 'alter database mount';

sql statement: alter database mount
released channel: ORA_DISK_1

RMAN>

3.8、注册备份集信息

RMAN> catalog start with '+hzdw2019';

searching for all files that match the pattern +hzdw2019

List of Files Unknown to the Database
=====================================
File Name: +hzdw2019/cntrl_12_1_12

Do you really want to catalog the above files (enter YES or NO)? no

RMAN>

不能发现备份片信息，所以采用手动注册的方式：

RMAN> catalog backuppiece '+hzdw2019/db_rac_20190311_03ts5i43_1_1';

cataloged backuppiece
backup piece handle=+HZDW2019/db_rac_20190311_03ts5i43_1_1 recid=11 stamp=1002639056

RMAN> catalog backuppiece '+hzdw2019/db_rac_20190311_04ts5i43_1_1';

cataloged backuppiece
backup piece handle=+HZDW2019/db_rac_20190311_04ts5i43_1_1 recid=12 stamp=1002639077

RMAN> catalog backuppiece '+hzdw2019/db_rac_20190311_05ts5i44_1_1';

cataloged backuppiece
backup piece handle=+HZDW2019/db_rac_20190311_05ts5i44_1_1 recid=13 stamp=1002639094

RMAN> catalog backuppiece '+hzdw2019/db_rac_20190311_07ts5i6k_1_1';

cataloged backuppiece
backup piece handle=+HZDW2019/db_rac_20190311_07ts5i6k_1_1 recid=14 stamp=1002639106

RMAN>

3.9、执行数据库还原

还原脚本如下：

run {
allocate channel c0 type disk;
allocate channel c1 type disk;
allocate channel c2 type disk;
set newname for datafile 1 to '+hzdw2019/rac/datafile/system';
set newname for datafile 2 to '+hzdw2019/rac/datafile/undotbs1';
set newname for datafile 3 to '+hzdw2019/rac/datafile/sysaux';
set newname for datafile 4 to '+hzdw2019/rac/datafile/users';
set newname for datafile 5 to '+hzdw2019/rac/datafile/example';
set newname for datafile 6 to '+hzdw2019/rac/datafile/undotbs2';
restore database;
switch datafile all;
release channel c0;
release channel c1;
release channel c2;
}

RMAN> run {
allocate channel c0 type disk;
allocate channel c1 type disk;
allocate channel c2 type disk;
set newname for datafile 1 to '+hzdw2019/rac/datafile/system';
set newname for datafile 2 to '+hzdw2019/rac/datafile/undotbs1';
set newname for datafile 3 to2> 3> 4> 5> 6> 7>  '+hzdw2019/rac/datafile/sysaux';
set newname for datafile 4 to '+hzdw2019/rac/datafile/users';
set newname for datafile 5 to '+hzdw2019/rac/datafile/example';
set newname for datafile 6 to '+hzdw2019/rac/datafile/undotbs2';
restore database;
switch datafile all;
release channel c0;
release channel c1;
release channel c2;
}8> 9> 10> 11> 12> 13> 14> 15> 16> 

allocated channel: c0
channel c0: sid=146 instance=rac1 devtype=DISK

allocated channel: c1
channel c1: sid=145 instance=rac1 devtype=DISK

allocated channel: c2
channel c2: sid=142 instance=rac1 devtype=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 11-MAR-19

channel c0: starting datafile backupset restore
channel c0: specifying datafile(s) to restore from backup set
restoring datafile 00002 to +HZDW2019/rac/datafile/undotbs1
restoring datafile 00003 to +HZDW2019/rac/datafile/sysaux
channel c0: reading from backup piece +HZDW2019/db_rac_20190311_03ts5i43_1_1
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00004 to +HZDW2019/rac/datafile/users
restoring datafile 00006 to +HZDW2019/rac/datafile/undotbs2
channel c1: reading from backup piece +HZDW2019/db_rac_20190311_05ts5i44_1_1
channel c2: starting datafile backupset restore
channel c2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to +HZDW2019/rac/datafile/system
restoring datafile 00005 to +HZDW2019/rac/datafile/example
channel c2: reading from backup piece +HZDW2019/db_rac_20190311_04ts5i43_1_1
channel c1: restored backup piece 1
piece handle=+HZDW2019/db_rac_20190311_05ts5i44_1_1 tag=TAG20190311T095059
channel c1: restore complete, elapsed time: 00:02:17
channel c2: restored backup piece 1
piece handle=+HZDW2019/db_rac_20190311_04ts5i43_1_1 tag=TAG20190311T095059
channel c2: restore complete, elapsed time: 00:02:43
channel c0: restored backup piece 1
piece handle=+HZDW2019/db_rac_20190311_03ts5i43_1_1 tag=TAG20190311T095059
channel c0: restore complete, elapsed time: 00:02:46
Finished restore at 11-MAR-19

datafile 1 switched to datafile copy
input datafile copy recid=8 stamp=1002639415 filename=+HZDW2019/rac/datafile/system
datafile 2 switched to datafile copy
input datafile copy recid=9 stamp=1002639415 filename=+HZDW2019/rac/datafile/undotbs1
datafile 3 switched to datafile copy
input datafile copy recid=10 stamp=1002639415 filename=+HZDW2019/rac/datafile/sysaux
datafile 4 switched to datafile copy
input datafile copy recid=11 stamp=1002639415 filename=+HZDW2019/rac/datafile/users
datafile 5 switched to datafile copy
input datafile copy recid=12 stamp=1002639416 filename=+HZDW2019/rac/datafile/example
datafile 6 switched to datafile copy
input datafile copy recid=13 stamp=1002639416 filename=+HZDW2019/rac/datafile/undotbs2

released channel: c0

released channel: c1

released channel: c2

RMAN>

3.10、注册归档备份片信息并执行恢复数据库操作

RMAN> catalog backuppiece '+hzdw2019/arc_1002621154_10';

cataloged backuppiece
backup piece handle=+HZDW2019/arc_1002621154_10 recid=15 stamp=1002639588

RMAN> catalog backuppiece '+hzdw2019/arc_1002621156_11';

cataloged backuppiece
backup piece handle=+HZDW2019/arc_1002621156_11 recid=16 stamp=1002639605

RMAN> 

RMAN> recover database;

Starting recover at 11-MAR-19
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=146 instance=rac1 devtype=DISK

starting media recovery

archive log thread 1 sequence 91 is already on disk as file +DATA/rac/onlinelog/group_2.262.979404775
archive log thread 1 sequence 92 is already on disk as file +DATA/rac/onlinelog/group_1.261.979404773
archive log thread 2 sequence 70 is already on disk as file +DATA/rac/onlinelog/group_4.267.979404883
archive log thread 2 sequence 71 is already on disk as file +DATA/rac/onlinelog/group_3.266.979404883
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=90
channel ORA_DISK_1: reading from backup piece +HZDW2019/arc_1002621154_10
channel ORA_DISK_1: restored backup piece 1
piece handle=+HZDW2019/arc_1002621154_10 tag=TAG20190311T095233
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=+HZDW2019/rac/archivelog/2019_03_11/thread_1_seq_90.261.1002639629 thread=1 sequence=90
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=2 sequence=69
channel ORA_DISK_1: reading from backup piece +HZDW2019/arc_1002621156_11
channel ORA_DISK_1: restored backup piece 1
piece handle=+HZDW2019/arc_1002621156_11 tag=TAG20190311T095233
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=+HZDW2019/rac/archivelog/2019_03_11/thread_2_seq_69.259.1002639631 thread=2 sequence=69
archive log filename=+DATA/rac/onlinelog/group_2.262.979404775 thread=1 sequence=91
archive log filename=+DATA/rac/onlinelog/group_4.267.979404883 thread=2 sequence=70
archive log filename=+DATA/rac/onlinelog/group_3.266.979404883 thread=2 sequence=71
archive log filename=+DATA/rac/onlinelog/group_1.261.979404773 thread=1 sequence=92
media recovery complete, elapsed time: 00:00:07
Finished recover at 11-MAR-19

RMAN>

3.11、恢复完成后打开数据库

SQL> alter database open resetlogs;

Database altered.

SQL> select status from v$instance;

STATUS
------------
OPEN

SQL>

3.12、更换redo路径

3.12.1、查看当前数据库的redo信息

SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 2	    1	       4 +DATA/rac/onlinelog/group_2.262.979404775		      NO  CURRENT			  50
	 1	    1	       3 +DATA/rac/onlinelog/group_1.261.979404773		      YES ACTIVE			  50
	 3	    2	       1 +DATA/rac/onlinelog/group_3.266.979404883		      YES INACTIVE			  50
	 4	    2	       2 +DATA/rac/onlinelog/group_4.267.979404883		      NO  CURRENT			  50

SQL>

3.12.2、添加新的redo文件

alter database add logfile thread 1 group 5  size 50m;
alter database add logfile thread 1 group 6  size 50m;
alter database add logfile thread 2 group 7  size 50m;
alter database add logfile thread 2 group 8  size 50m;
SQL> alter database add logfile thread 1 group 5  size 50m;

Database altered.

SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 2	    1	       4 +DATA/rac/onlinelog/group_2.262.979404775		      NO  CURRENT			  50
	 1	    1	       3 +DATA/rac/onlinelog/group_1.261.979404773		      YES INACTIVE			  50
	 3	    2	       1 +DATA/rac/onlinelog/group_3.266.979404883		      YES INACTIVE			  50
	 4	    2	       2 +DATA/rac/onlinelog/group_4.267.979404883		      NO  CURRENT			  50
	 5	    1	       0 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      YES UNUSED			  50

SQL> alter database add logfile thread 1 group 6  size 50m;

Database altered.

SQL> alter database add logfile thread 2 group 7  size 50m;

Database altered.

SQL> alter database add logfile thread 2 group 8  size 50m;

Database altered.

SQL>

3.12.3、手动执行数据库redo切换

SQL> alter system switch logfile;

System altered.

SQL>
SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 2	    1	       8 +DATA/rac/onlinelog/group_2.262.979404775		      YES INACTIVE			  50
	 1	    1	       7 +DATA/rac/onlinelog/group_1.261.979404773		      YES INACTIVE			  50
	 3	    2	       5 +DATA/rac/onlinelog/group_3.266.979404883		      NO  CURRENT			  50
	 4	    2	       2 +DATA/rac/onlinelog/group_4.267.979404883		      YES INACTIVE			  50
	 5	    1	       9 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      YES INACTIVE			  50
	 6	    1	      10 +HZDW2019/rac/onlinelog/group_6.281.1002641273 	      NO  CURRENT			  50
	 7	    2	       3 +HZDW2019/rac/onlinelog/group_7.282.1002641301 	      YES INACTIVE			  50
	 8	    2	       4 +HZDW2019/rac/onlinelog/group_8.283.1002641311 	      YES INACTIVE			  50

8 rows selected.

SQL>

3.12.4、删除老的redo文件

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01623: log 3 is current log for instance rac2 (thread 2) - cannot drop
ORA-00312: online log 3 thread 2: '+DATA/rac/onlinelog/group_3.266.979404883'


SQL> 
SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 3	    2	       5 +DATA/rac/onlinelog/group_3.266.979404883		      NO  CURRENT			  50
	 4	    2	       2 +DATA/rac/onlinelog/group_4.267.979404883		      YES INACTIVE			  50
	 5	    1	       9 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      YES INACTIVE			  50
	 6	    1	      10 +HZDW2019/rac/onlinelog/group_6.281.1002641273 	      NO  CURRENT			  50
	 7	    2	       3 +HZDW2019/rac/onlinelog/group_7.282.1002641301 	      YES INACTIVE			  50
	 8	    2	       4 +HZDW2019/rac/onlinelog/group_8.283.1002641311 	      YES INACTIVE			  50

6 rows selected.

SQL> alter system switch logfile;

System altered.

SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 3	    2	       5 +DATA/rac/onlinelog/group_3.266.979404883		      NO  CURRENT			  50
	 4	    2	       2 +DATA/rac/onlinelog/group_4.267.979404883		      YES INACTIVE			  50
	 5	    1	      11 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      NO  CURRENT			  50
	 6	    1	      10 +HZDW2019/rac/onlinelog/group_6.281.1002641273 	      YES ACTIVE			  50
	 7	    2	       3 +HZDW2019/rac/onlinelog/group_7.282.1002641301 	      YES INACTIVE			  50
	 8	    2	       4 +HZDW2019/rac/onlinelog/group_8.283.1002641311 	      YES INACTIVE			  50

6 rows selected.

SQL> alter system switch logfile;

System altered.

SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 3	    2	       5 +DATA/rac/onlinelog/group_3.266.979404883		      YES INACTIVE			  50
	 4	    2	       6 +DATA/rac/onlinelog/group_4.267.979404883		      NO  CURRENT			  50
	 5	    1	      11 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      YES ACTIVE			  50
	 6	    1	      12 +HZDW2019/rac/onlinelog/group_6.281.1002641273 	      NO  CURRENT			  50
	 7	    2	       3 +HZDW2019/rac/onlinelog/group_7.282.1002641301 	      YES INACTIVE			  50
	 8	    2	       4 +HZDW2019/rac/onlinelog/group_8.283.1002641311 	      YES INACTIVE			  50

6 rows selected.

SQL> alter database drop logfile group 3;

Database altered.

SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 4	    2	       6 +DATA/rac/onlinelog/group_4.267.979404883		      NO  CURRENT			  50
	 5	    1	      11 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      YES ACTIVE			  50
	 6	    1	      12 +HZDW2019/rac/onlinelog/group_6.281.1002641273 	      NO  CURRENT			  50
	 7	    2	       3 +HZDW2019/rac/onlinelog/group_7.282.1002641301 	      YES INACTIVE			  50
	 8	    2	       4 +HZDW2019/rac/onlinelog/group_8.283.1002641311 	      YES INACTIVE			  50

SQL> alter system switch logfile;

System altered.

SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 4	    2	       6 +DATA/rac/onlinelog/group_4.267.979404883		      NO  CURRENT			  50
	 5	    1	      13 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      NO  CURRENT			  50
	 6	    1	      12 +HZDW2019/rac/onlinelog/group_6.281.1002641273 	      YES ACTIVE			  50
	 7	    2	       3 +HZDW2019/rac/onlinelog/group_7.282.1002641301 	      YES INACTIVE			  50
	 8	    2	       4 +HZDW2019/rac/onlinelog/group_8.283.1002641311 	      YES INACTIVE			  50

SQL> alter system switch logfile;

System altered.

SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 4	    2	       6 +DATA/rac/onlinelog/group_4.267.979404883		      YES INACTIVE			  50
	 5	    1	      13 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      YES ACTIVE			  50
	 6	    1	      14 +HZDW2019/rac/onlinelog/group_6.281.1002641273 	      NO  CURRENT			  50
	 7	    2	       7 +HZDW2019/rac/onlinelog/group_7.282.1002641301 	      NO  CURRENT			  50
	 8	    2	       4 +HZDW2019/rac/onlinelog/group_8.283.1002641311 	      YES INACTIVE			  50

SQL> alter database drop logfile group 4;

Database altered.

SQL> select a.GROUP#,a.THREAD#,a.SEQUENCE#,b.MEMBER,a.ARCHIVED,a.STATUS,a.bytes/1024/1024 from v$log a,v$logfile b where a.GROUP#=b.GROUP#;

    GROUP#    THREAD#  SEQUENCE# MEMBER 						      ARC STATUS	   A.BYTES/1024/1024
---------- ---------- ---------- ------------------------------------------------------------ --- ---------------- -----------------
	 5	    1	      13 +HZDW2019/rac/onlinelog/group_5.280.1002641221 	      YES ACTIVE			  50
	 6	    1	      14 +HZDW2019/rac/onlinelog/group_6.281.1002641273 	      NO  CURRENT			  50
	 7	    2	       7 +HZDW2019/rac/onlinelog/group_7.282.1002641301 	      NO  CURRENT			  50
	 8	    2	       4 +HZDW2019/rac/onlinelog/group_8.283.1002641311 	      YES INACTIVE			  50

SQL>

需要注意的是：

1、每个实例必须至少有两个日志组；

2、当一个日志组处于ACTIVE或者CURRENT的状态时不可删除；

3、删除日志组的操作只对数据库进行更改，操作系统的文件尚未删除；

4、当删除时适用DROP LOGFILE GROUP N语句时，此时GROUP N内的所有成员都将被删除。

daf380
关注
专栏目录
Oracle 11g RAC 更换磁盘组
阿九的宅基地
01-06 1476
作者 阿九【转载时请务必以超链接形式标明文章原始出处和作者信息】 新安装的ORACLE 11G R2 RAC 由于创建ASM磁盘的时候，选择了Normal模式，导致磁盘大小只有原来的一半。 因此需要删除建好的磁盘组后重建为使用External模式的磁盘组。具体过程如下： 原有磁盘组名：DATA 过渡磁盘组名：GZPJ 1、添加一个新的磁盘或将原有磁盘组中的磁盘删一个，用来
Oracle 10g rac 迁移存储ASM过程
大碗刀削面的博客
12-18 230
一、迁移ocfs [root@rac1 u01]# cd /u01/app/oracle/product/10.2.0/crs_1/bin/ [root@rac1 bin]# ./crsctl stop crs Stopping resources. This could take several minutes. Successfully stopped CRS resources. Stopping CSSD. Shutting down CSS daemon. Shutdown requ
oracle asm之添加和修改asm磁盘组
weixin_33716557的博客
07-01 177
1、添加磁盘组： 相信很多人都会使用dbca创建磁盘组了，这里介绍使用SQL*PLUS创建磁盘组。主要是使用CREATE DISKGROUP语句，该语句的语法如下： CREATE DISKGROUP diskgroup_name [ { HIGH | NORMAL | EXTERNAL } REDUNDANCY ] [ FAILGROUP failgroup_name ] DISK [ ...
Oracle 11G-RAC-ASM磁盘组更换
最新发布
gaoda00136的博客
04-17 1074
数据库：ORACLE Version:11.2.0.4.0 RAC。由于共享存储需进行存储更换升级，故需对所有ASM磁盘进行在线更换。操作系统：RED-HAT LINUX 6.9。标记框内是老的存储磁盘。至此，RAC集群ASM磁盘存储替换成功。重启UDEV服务:Start_udev。
oracle RAC 更换存储迁移数据(在线迁移ASM磁盘组）测试
热门推荐
雨花石
03-10 1万+
oracle RAC 更换存储迁移数据 在线迁移ASM磁盘组 迁移ocr 迁移votedisk 添加磁盘组
Windows Server 2012 R2 X64环境下搭建Oracle 11G R2 RAC+ASM.doc
06-12
Windows Server 2012 R2 X64环境下搭建Oracle 11G R2 RAC+ASM，文档目录清晰，需要的拿去。
asm冗余 oracle_ORACLE 11G RAC ASM磁盘的三种冗余模式
weixin_39560924的博客
12-24 465
在安装ASM磁盘时采用了high、normal、extenrnal的三种冗余模式。三种冗余模式EXTERNAL模式External redundancy(1OCR and no copies)An external redundancy disk group requires a minimum of one disk device.The effective disk space in an e...
oracle 19c rac替换asm磁盘组
hbhe0316的专栏
04-05 1065
1、添加新磁盘： 两个节点都操作,使用root用户 for i in j k; do echo "KERNEL==\"sd*\",ENV{DEVTYPE}==\"disk\",SUBSYSTEM==\"block\",PROGRAM==\"/usr/lib/udev/scsi_id -g -u -d \$devnode\",RESULT==\"`/usr/lib/udev/scsi_id -g -u /dev/sd$i`\", RUN+=\"/bin/sh -c 'mknod /dev/asm-dis.
oracle 10g中ASM概念以及管理
weixin_34021089的博客
06-30 143
一、关于oracle ASM实例的概念：       ASM 实例与 ORACLE 实例差不多，都是 由 sga 和一堆后台进程组成，从功能上来看，区别在于oracle实例管理的是数据库，而asm实例只是管理asm盘阵。 通过Oracle EM或DBCA都可以对asm进行一些配置，不过三思觉着管理asm括弧实例的最佳工具仍是sql*plus，在进入sql*plus前也需要设置ORACLE_SI...
ORACLE 10G asm
09-04
ORACLE 10G ASM 安装包 ORACLE 10G ASM 安装包
ORACLE RAC ASM 很实用
03-20
ORACLE数据库中的RAC、SAM概述。 对了解相关概念的初学者而言还是挺有价值的！
Oracle 更换asm磁盘
gsforget321的博客
11-30 1321
背景介绍 公司的数据库存储老化，需要新的存储进行替换，为了减少对业务的影响，采用添加、删除磁盘的方式进行替换，这个方式可以参考我的另一篇uuid方式替换数据库存储； 本文是在存储替换的时候，发现很久之前使用afd安装的磁盘组有些问题，就想将afd格式的挂载方式改成普通的裸磁盘方式，才有了本文测试步骤： 卸载afd磁盘的准备工作 查看磁盘组中磁盘的状态，以及确认我要卸载AFD格式的盘，现在有一个标签为arch的磁盘在ocr的磁盘组（根据group_number对应到asm_diskgroup 从而确认磁盘组
Oracle 10g rac + ASM数据迁移（替换ASM中的磁盘，用新存储替换旧存储）
daf380的专栏
09-26 1656
一、环境介绍 Redhat 5.8 Oracle 10g rac + ASM  目前数据库是一套Oracle 10g rac环境，使用的是ASM，ASM的存储空间来自多台存储设备，包括：XP12000、HDS等；由于XP12000存储已十分之老旧了，因此需要用新添加的HDS存储替换XP12000存储。 二、本地搭建测试环境（生产环境和测试环境中的ASM都是采用绑定裸设备的方式实现） 管理...
Oracle10g的Asm应用于数据存储管理
wanglihuhappy的专栏
01-07 161
摘要 随着数据库的持续运行，数据库的大小不断扩大，要求不断增大系统的存储容量，对于普通的文件系统，增加存储的过程非常复杂。Oracle10g的自动存储管理系统（automatic storage management asm）就是针对该问题而产生的，它大大简化了数据库存储系统的管理。   1 前言   如今，大型数据库系统要求尽量减少有计划的停机时间,同时随着数据库运行时间的持续增加，数据库的大小...
oracle rac11g更换存储,oracle 11gR2 RAC存储迁移
weixin_36102010的博客
04-04 433
1、关闭节点1服务，挂载裸设备并创建ASM磁盘，由于是RAC，节点2服务并没有停止，所以业务能正常运行；关闭节点1上的CRS服务查看服务状态，目前只有节点2正常运行，scanIP与vip迁移至节点2；裸设备映射，并重启udev,查看裸设备映射情况；创建ASM磁盘查看创建好的ASM磁盘启动节点1的CRS服务；查看CRS运行状态，此时CRS服务在两个节点同时运行，2、使用同节点1同样的方法在节点2上将...
oracle 10g rac ASM存储迁移数据
我的Oracle DBA之路
06-20 2239
oracle 10g rac ASM存储迁移数据 （上）http://blog.sina.com.cn/s/blog_6f1123420100r8wm.htmloracle 10g rac ASM存储迁移数据 （下）http://blog.sina.com.cn/s/blog_6f1123420100r8z1.html
实战Oracle RAC迁移项目第3篇：RAC替换存储
huiyangxu blog
12-31 1550
实战RAC迁移项目第3篇：RAC替换存储
oracle11G ASM文件磁盘组更换
hzcyhujw的博客
06-22 1553
概述：最近公司的一台存储磁盘两块磁盘同时损失导致有一套数据库存在坏块，还有其他相关数据库存在风险；在修复完受损严重的数据库后，需要对存储进行更换维修时，需要将未受损的数据库存在风险数据进行迁移，主要涉及到的问题是rac 存储数据如何迁移至新的存储？现在还未实施，我先依照现存的环境在虚拟机中进行模拟实验：1、环境：我这边相关损坏的存储没有底层复制镜像等功能（存储较老旧，领导反馈客户准备全部更换后利久...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值