RAC环境重命名diskgroup name

最新推荐文章于 2021-04-09 02:52:16 发布

cuizhi4718

最新推荐文章于 2021-04-09 02:52:16 发布

阅读量247

点赞数

1、检查ASM磁盘组名称
[grid@jzh1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 14 09:16:09 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select group_number,name,state from v$asm_diskgroup;

GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 ARCH MOUNTED
2 DATA MOUNTED
3 VOTE MOUNTED
2、检查数据库当前(spfile/controlfile/datafile/redo logfile)
[oracle@jzh1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 14 09:17:48 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/jzh/spfilejzh.ora
SQL> show parameter control

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string +DATA/jzh/controlfile/current.
270.880001913, +ARCH/jzh/contr
olfile/current.321.880001913
control_management_pack_access string DIAGNOSTIC+TUNING

SQL> select name,status from v$datafile;

NAME STATUS
-------------------------------------------------- -------
+DATA/jzh/datafile/system.261.880001919 SYSTEM
+DATA/jzh/datafile/sysaux.265.880001965 ONLINE
+DATA/jzh/datafile/undotbs1.272.880001991 ONLINE
+DATA/jzh/datafile/undotbs2.269.880002027 ONLINE
+DATA/jzh/datafile/users.262.880002029 ONLINE

SQL> select member from v$logfile;

MEMBER
------------------------------------------------------------
+DATA/jzh/onlinelog/group_4.264.880005761
+ARCH/jzh/onlinelog/group_4.259.880005763
+DATA/jzh/onlinelog/group_3.260.880005747
+ARCH/jzh/onlinelog/group_3.260.880005753
+DATA/jzh/onlinelog/group_1.271.880001913
+ARCH/jzh/onlinelog/group_1.261.880001915
+DATA/jzh/onlinelog/group_2.268.880001917
+ARCH/jzh/onlinelog/group_2.271.880001919

8 rows selected.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------
+DATA/jzh/tempfile/temp.267.880001997

3、关闭数据库
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

4、将磁盘组data umount
[oracle@jzh1 ~]$ su - grid
Password:
[grid@jzh1 ~]$ asmcmd umount data
[grid@jzh2 ~]$ asmcmd umount data

5、通过renamedg重命名磁盘组data
[grid@jzh1 ~]$ renamedg phase=both dgname=DATA newdgname=DATA_NEW confirm=true config=/tmp/renamedg verbose=true

asm_diskstring='/dev/asm-disk*'
NOTE: No asm libraries found in the system

Parsing parameters..

Parameters in effect:

Old DG name : DATA
New DG name : DATA_NEW
Phases :
Phase 1
Phase 2
Discovery str : /dev/asm-disk*
Confirm : TRUE
Clean : TRUE
Raw only : TRUE
renamedg operation: phase=both dgname=DATA newdgname=DATA_NEW confirm=true config=/tmp/renamedg verbose=true

asm_diskstring=/dev/asm-disk*
Executing phase 1
Discovering the group
Performing discovery with string:/dev/asm-disk*
Identified disk UFS:/dev/asm-diskd with disk number:0 and timestamp (33017221 -1013020672)
Identified disk UFS:/dev/asm-diskg with disk number:3 and timestamp (33017221 -1013020672)
Identified disk UFS:/dev/asm-diskf with disk number:2 and timestamp (33017221 -1013020672)
Identified disk UFS:/dev/asm-diske with disk number:1 and timestamp (33017221 -1013020672)
Checking for hearbeat...
Re-discovering the group
Performing discovery with string:/dev/asm-disk*
Identified disk UFS:/dev/asm-diskd with disk number:0 and timestamp (33017221 -1013020672)
Identified disk UFS:/dev/asm-diskg with disk number:3 and timestamp (33017221 -1013020672)
Identified disk UFS:/dev/asm-diskf with disk number:2 and timestamp (33017221 -1013020672)
Identified disk UFS:/dev/asm-diske with disk number:1 and timestamp (33017221 -1013020672)
Checking if the diskgroup is mounted or used by CSS
Checking disk number:0
Checking disk number:3
Checking disk number:2
Checking disk number:1
Generating configuration file..
Completed phase 1
Executing phase 2
Looking for /dev/asm-diskd
Modifying the header
Looking for /dev/asm-diskg
Modifying the header
Looking for /dev/asm-diskf
Modifying the header
Looking for /dev/asm-diske
Modifying the header
Completed phase 2
Terminating kgfd context 0x7f63b02520a0

6、所有节点mount新磁盘组
[grid@jzh1 ~]$ asmcmd mount data_new

7、确认新diskgroup信息
[grid@jzh2 ~]$ asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks

Voting_files Name
MOUNTED EXTERN N 512 4096 1048576 10240 9858 0 9858 0

N ARCH/
MOUNTED EXTERN N 512 4096 1048576 20480 17922 0 17922 0

N DATA_NEW/
MOUNTED EXTERN N 512 4096 1048576 4096 3698 0 3698 0

Y VOTE/

[grid@jzh1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 14 09:53:46 2015

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> select group_number,name,state from v$asm_diskgroup;

GROUP_NUMBER NAME STATE
------------ ------------------------------ -----------
1 ARCH MOUNTED
3 VOTE MOUNTED
2 DATA_NEW MOUNTED
8、修改两节点初始化参数
修改前：+DATA/jzh/spfilejzh.ora
修改后：+DATA_NEW/jzh/spfilejzh.ora

9、启动数据库至nomoun状态
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1436389376 bytes
Fixed Size 2228384 bytes
Variable Size 905973600 bytes
Database Buffers 520093696 bytes
Redo Buffers 8093696 bytes

10、修改control_files参数
SQL> alter system set control_files='+DATA_NEW/jzh/controlfile/current.270.880001913’,

‘+ARCH/jzh/controlfile/current.321.880001913' scope=spfile;

System altered.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1436389376 bytes
Fixed Size 2228384 bytes
Variable Size 905973600 bytes
Database Buffers 520093696 bytes
Redo Buffers 8093696 bytes
Database mounted.
SQL> show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string +DATA_NEW/jzh/controlfile/curr
ent.270.880001913, +ARCH/jzh/c
ontrolfile/current.321.8800019
13
11、修改datafile/tempfile/redo文件位置
SQL> alter database rename file'+DATA/jzh/datafile/system.261.880001919' to

'+DATA_NEW/jzh/datafile/system.261.880001919';

Database altered.

SQL> alter database rename file'+DATA/jzh/datafile/sysaux.265.880001965' to

'+DATA_NEW/jzh/datafile/sysaux.265.880001965';

Database altered.

SQL> alter database rename file'+DATA/jzh/datafile/undotbs1.272.880001991' to

'+DATA_NEW/jzh/datafile/undotbs1.272.880001991';

Database altered.

SQL> alter database rename file'+DATA/jzh/datafile/undotbs2.269.880002027' to

'+DATA_NEW/jzh/datafile/undotbs2.269.880002027';

Database altered.

SQL> alter database rename file'+DATA/jzh/datafile/users.262.880002029' to

'+DATA_NEW/jzh/datafile/users.262.880002029';

Database altered.

SQL> alter database rename file'+DATA/jzh/onlinelog/group_4.264.880005761' to

'+DATA_NEW/jzh/onlinelog/group_4.264.880005761';

Database altered.

SQL> alter database rename file'+DATA/jzh/onlinelog/group_3.260.880005747' to

'+DATA_NEW/jzh/onlinelog/group_3.260.880005747';

Database altered.

SQL> alter database rename file'+DATA/jzh/onlinelog/group_1.271.880001913' to

'+DATA_NEW/jzh/onlinelog/group_1.271.880001913';

Database altered.

SQL> alter database rename file'+DATA/jzh/onlinelog/group_2.268.880001917' to

'+DATA_NEW/jzh/onlinelog/group_2.268.880001917';

Database altered.

SQL> alter database rename file'+DATA/jzh/tempfile/temp.267.880001997' to '+DATA_NEW/jzh/tempfile/temp.267.880001997';

Database altered.

12、修改后确认：
SQL> select name,status from v$datafile;

NAME STATUS
-------------------------------------------------- -------
+DATA_NEW/jzh/datafile/system.261.880001919 SYSTEM
+DATA_NEW/jzh/datafile/sysaux.265.880001965 ONLINE
+DATA_NEW/jzh/datafile/undotbs1.272.880001991 ONLINE
+DATA_NEW/jzh/datafile/undotbs2.269.880002027 ONLINE
+DATA_NEW/jzh/datafile/users.262.880002029 ONLINE

SQL> select member from v$logfile;

MEMBER
------------------------------------------------------------
+DATA_NEW/jzh/onlinelog/group_4.264.880005761
+ARCH/jzh/onlinelog/group_4.259.880005763
+DATA_NEW/jzh/onlinelog/group_3.260.880005747
+ARCH/jzh/onlinelog/group_3.260.880005753
+DATA_NEW/jzh/onlinelog/group_1.271.880001913
+ARCH/jzh/onlinelog/group_1.261.880001915
+DATA_NEW/jzh/onlinelog/group_2.268.880001917
+ARCH/jzh/onlinelog/group_2.271.880001919

8 rows selected.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------
+DATA_NEW/jzh/tempfile/temp.267.880001997

13、启动数据库
SQL> alter database open;

Database altered.

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

转载于:http://blog.itpub.net/10271187/viewspace-1733203/