Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ ASM Management - How to Rename diskgroup     - Linux scheduling summary (Linux)

- Ubuntu 12.04 installation OpenCV2.4.1 and compile test (Linux)

- CentOS7 virtual machine settings, and bridging problems (Linux)

- Talk about Java in the collection (Programming)

- MySQL uses mysqld_multi to deploy stand-alone multi-instance detail procedures (Database)

- MariaDB database storage path modify configuration issues (Database)

- MySQL innodb_table_stats table does not exist solution (Database)

- Analysis of MySQL High Availability (Database)

- Can not empty the Recycle Bin to repair problems in Ubuntu 14.04 (Linux)

- Postgres-X2 deployment steps (Database)

- Eclipse improve the efficiency of good habits (Programming)

- Delegate in C # (Programming)

- Linux batch copy data script (Linux)

- expdp / impdp use version parameter data migration across versions (Database)

- Apache Linux firewall reverse proxy configuration (Linux)

- Nginx1.8 version upgrade method AMH4.2 Free manually compile (Server)

- Generic mechanism C11 standard (Programming)

- Understand ASP.NET 5 running the command: DNVM, DNX, and DNU (Server)

- Python image processing library (PIL) to install and simple to use (Linux)

- OpenWrt modify flash size (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:      
 
- JavaScript property of checkbox.disabled (Programming)
- Java objects are taking up much space (Programming)
- Hadoop safe hftp (Server)
- After VMware CentOS full VM clone the network card is unavailable Solutions (Linux)
- Ubuntu Learning Advanced article - to teach you to further enhance system security (Linux)
- Redis is installed and set up Ubuntu 14.04 from the environment under the main ssdb (Server)
- How to use Android Studio to play more package names APK (Programming)
- Browser caching mechanism on the analysis (Linux)
- Virtual Judge structures under Ubuntu 14.04 (Server)
- Install Ruby on Rails in Ubuntu 15.04 in (Linux)
- tespeed - test speed of Python tools (Linux)
- Features and prevention methods elaborate network security grayware (Linux)
- Linux Shell introduces (Linux)
- Linux data redirection (Linux)
- Difference in MySQL VARCHAR and CHAR data format (Database)
- Java MD5 encryption implementation (Programming)
- To install JDK1.7 and compiler Hadoop-2.7.1 under CentOS7 (Server)
- How dependent on Fedora, CentOS, RHEL check RPM packages (Linux)
- Deploy Mono 4 and Jexus 5.6 on CentOS7 (Server)
- Analysis of native Java keywords (Programming)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.