Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ASM Management - How to Rename diskgroup     - How to configure security services under Linux (Linux)

- To compile install and test Swift under Linux (Linux)

- Linux network monitoring strategy (Linux)

- Configuring Haproxy log support (syslog logging support) (Server)

- Set up MySQL master and slave servers under Ubuntu 14.04 (Server)

- Linux system performance and usage activity monitoring tools -Sysstat (Linux)

- Linux System Getting Started Tutorial: How to automatically set the JAVA_HOME environment variable on Linux (Linux)

- 64-bit Oracle Linux recompiled Hadoop-2.2.0 (Server)

- OpenSUSE GPG Comments (Linux)

- MySQL 5.6 Open full query log (Database)

- Sort search algorithm Java - application examples with recursive dichotomy (Programming)

- Oracle set and remove columns unavailable (Database)

- 7 JavaScript interview questions (Programming)

- hexdump Linux command (Linux)

- Use Spring cache and ehcache (Programming)

- Use IP address spoofing Intrusion Prevention Firewall (Linux)

- Install Ruby on Rails in Ubuntu 15.04 in (Linux)

- Using the Linux folder wc statistics number of lines of code for all files (including subdirectories) (Linux)

- Android Action Compendium (Programming)

- Management Linux Container with Docker in Ubuntu (Linux)

 
         
  ASM Management - How to Rename diskgroup
     
  Add Date : 2018-11-21      
         
         
         
  ASM 11.2.0.1 version began to increase diskgroup rename the new features by renamedg diskgroup rename command has been created, you need to rename the former dismount diskgroup.

If you rename the diskgroup has been used to store the database data files, then you need to manually synchronize the location of the data file.

- Check the current ASM diskgroup named DGASMDB

$ Su - grid

$ Sqlplus / as sysasm

SQL> select GROUP_NUMBER, name, state, type, offline_disks, ALLOCATION_UNIT_SIZE, BLOCK_SIZE, TOTAL_MB, FREE_MB from v $ asm_diskgroup;

GROUP_NUMBER NAME STATE TYPE OFFLINE_DISKS ALLOCATION_UNIT_SIZE BLOCK_SIZE TOTAL_MB FREE_MB

------------ ---------- -------------- ------------- - ------------------- ---------- ---------- ----------

1 DGASMDB MOUNTED EXTERN 0 1048576 4096 3992 1879

- Check database current information (spfile / controlfile / datafile / redo)

su - Oracle

$ Sqlplus / as sysdba

SQL> show parameter spfile;

NAME TYPE VALUE

------------------------------------ ----------- --- ---------------------------

spfile string + DGASMDB / asmdb / spfileasmdb.ora

SQL> show parameter control

NAME TYPE VALUE

------------------------------------ ----------- --- ---------------------------

control_files string + DGASMDB / asmdb / controlfile / current.256.856653049

SQL> select name from v $ datafile;

NAME

-------------------------------------------------- ------------------------------

+ DGASMDB / asmdb / datafile / system.260.856653053

+ DGASMDB / asmdb / datafile / sysaux.261.856653059

+ DGASMDB / asmdb / datafile / undotbs1.262.856653061

+ DGASMDB / asmdb / datafile / users.264.856653075

+ DGASMDB / asmdb / datafile / asm_test.dbf

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

--dismount diskgroup dgasmdb

$ Su - grid

$ Asmcmd umount dgasmdb

- Rename command diskgroup, new diskgroup named dgasmdb_new

$ Renamedg phase = both dgname = dgasmdb newdgname = dgasmdb_new verbose = true

Parsing parameters ..

Parameters in effect:

Old DG name: DGASMDB

New DG name: DGASMDB_NEW

Phases:

Phase 1

Phase 2

Discovery str: (null)

Clean: TRUE

Raw only: TRUE

renamedg operation: phase = both dgname = dgasmdb newdgname = dgasmdb_new verbose = true

Executing phase 1

Discovering the group

Performing discovery with string:

Identified disk ASM: /opt/oracle/extapi/64/asm/orcl/1/libasm.so: ORCL: ASMDISK4G1 with disk number: 0 and timestamp (33006423 142494720)

Checking for hearbeat ...

Re-discovering the group

Performing discovery with string:

Identified disk ASM: /opt/oracle/extapi/64/asm/orcl/1/libasm.so: ORCL: ASMDISK4G1 with disk number: 0 and timestamp (33006423 142494720)

Checking if the diskgroup is mounted or used by CSS

Checking disk number: 0

Generating configuration file ..

Completed phase 1

Executing phase 2

Looking for ORCL: ASMDISK4G1

Modifying the header

Completed phase 2

Terminating kgfd context 0x7fa6c2bee0a0

--mount new diksgroup dgasmdb_new

$ Asmcmd mount dgasmdb_new

- Check out the new diskgroup information

SQL> select GROUP_NUMBER, name, state, type, offline_disks, ALLOCATION_UNIT_SIZE, BLOCK_SIZE, TOTAL_MB, FREE_MB from v $ asm_diskgroup;

GROUP_NUMBER NAME STATE TYPE OFFLINE_DISKS ALLOCATION_UNIT_SIZE BLOCK_SIZE TOTAL_MB FREE_MB

------------ ----------- -------- ------ ------------- -------------------- ---------- ---------- ----------

1 DGASMDB_NEW MOUNTED EXTERN 0 1048576 4096 3992 1879

- Modify DB initialization parameters (/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initasmdb.ora) configuration information

The original: SPFILE = '+ DGASMDB / asmdb / spfileasmdb.ora'

After modification: SPFILE = '+ DGASMDB_NEW / asmdb / spfileasmdb.ora'

- Start the database nomount

su - oracle

sqlplus / as sysdba

startup nomount;

- Modify control_files parameters:

SQL> alter system set control_files = '+ DGASMDB_NEW / asmdb / controlfile / current.256.856653049' scope = spfile;

SQL> shutdown immediate;

SQL> startup mount;

SQL> show parameter control_files

NAME TYPE VALUE

------------------------------------ ----------- --- ---------------------------

control_files string + DGASMDB_NEW / asmdb / controlfile

/current.256.856653049

- Confirm the current record or datafile located in the original diskgroup DGASMDB

SQL> select FILE #, name from v $ datafile;

FILE # NAME

---------- ---------------------------------------- -------------------------------------------------- ----------

1 + DGASMDB / asmdb / datafile / system.260.856653053

2 + DGASMDB / asmdb / datafile / sysaux.261.856653059

3 + DGASMDB / asmdb / datafile / undotbs1.262.856653061

4 + DGASMDB / asmdb / datafile / users.264.856653075

5 + DGASMDB / asmdb / datafile / asm_test.dbf

SQL> select file #, name from v $ tempfile;

FILE # NAME

---------- ---------------------------------------- ----------------------------------------

1 + DGASMDB / asmdb / tempfile / temp.263.856653061

- Modify datafile / tempfile Location:

SQL> conn / as sysdba

SQL> ALTER DATABASE RENAME FILE '+ DGASMDB / asmdb / datafile / system.260.856653053' TO '+ DGASMDB_NEW / asmdb / datafile / system.260.856653053';

SQL> ALTER DATABASE RENAME FILE '+ DGASMDB / asmdb / datafile / sysaux.261.856653059' TO '+ DGASMDB_NEW / asmdb / datafile / sysaux.261.856653059';

SQL> ALTER DATABASE RENAME FILE '+ DGASMDB / asmdb / datafile / undotbs1.262.856653061' TO '+ DGASMDB_NEW / asmdb / datafile / undotbs1.262.856653061';

SQL> ALTER DATABASE RENAME FILE '+ DGASMDB / asmdb / datafile / users.264.856653075' TO '+ DGASMDB_NEW / asmdb / datafile / users.264.856653075';

SQL> ALTER DATABASE RENAME FILE '+ DGASMDB / asmdb / datafile / asm_test.dbf' TO '+ DGASMDB_NEW / asmdb / datafile / asm_test.dbf';

SQL> ALTER DATABASE RENAME FILE '+ DGASMDB / asmdb / tempfile / temp.263.856653061' TO '+ DGASMDB_NEW / asmdb / tempfile / temp.263.856653061';

- Modified confirmation:

SQL> select FILE #, name from v $ datafile;

FILE # NAME

---------- ---------------------------------------- -------------------------------------------------- ----------

1 + DGASMDB_NEW / asmdb / datafile / system.260.856653053

2 + DGASMDB_NEW / asmdb / datafile / sysaux.261.856653059

3 + DGASMDB_NEW / asmdb / datafile / undotbs1.262.856653061

4 + DGASMDB_NEW / asmdb / datafile / users.264.856653075

5 + DGASMDB_NEW / asmdb / datafile / asm_test.dbf

- Modify the redo log location

alter database rename file '+ DGASMDB / asmdb / onlinelog / group_1.257.856653049' to '+ DGASMDB_NEW / asmdb / onlinelog / group_1.257.856653049';

alter database rename file '+ DGASMDB / asmdb / onlinelog / group_2.258.856653051' to '+ DGASMDB_NEW / asmdb / onlinelog / group_2.258.856653051';

alter database rename file '+ DGASMDB / asmdb / onlinelog / group_3.259.856653051' to '+ DGASMDB_NEW / asmdb / onlinelog / group_3.259.856653051';

select * from v $ logfile;

- Start the database

SQL> alter database open;

After renaming diskgroup, have any effect on the database? How to synchronize data?

Before renaming diskgroup, you need to manually dismount the disk group, renaming process does not have the data to be modified, so no additional synchronization.
     
         
         
         
  More:      
 
- Compile and install the latest version of Redis Stable (Database)
- Disk Management LVM (Linux)
- C language binary tree (Programming)
- On the design of Oracle database backup (Database)
- Install VMware Tools in Debian (Linux)
- Linux Shell Understanding and Learning (Linux)
- Physical backup and recovery SYSTEM table space (Database)
- Through the source code to install MySQL 5.6.26 under CentOS6 (Database)
- How to understand the difference between synchronous and asynchronous non-blocking blocking (Programming)
- The user of fedora is not in the sudoers file method to solve (Linux)
- ORA-04031 Error Resolution (Database)
- Using IntelliJ IDEA 13 integrated development environment to build Android (Linux)
- Grub2: Save Your bootloader (Linux)
- Ubuntu 14.10 users to install Audio Recorder 1.5.7 (Linux)
- Manage SQL Server services login (start) account and password (Database)
- Ubuntu 12.04 installation OpenCV2.4.1 and compile test (Linux)
- How to create a secure and easy to remember password (Linux)
- CentOS 6.5 three ways to configure the IP address (Linux)
- Android start automatically and add and delete a desktop shortcut (Programming)
- Nginx load balancing configuration (TCP proxy) (Server)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.