Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the method of unmounting and deleting Oracle ASM disk groups". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn "what is the method of unmounting and deleting Oracle ASM disk groups"?

Create a disk group:

Use Oracle user connection

[oracle @ rac1 ~] $sqlplus / as sysdba

SQL > create diskgroup arch external redundancy disk'/ dev/asm-disk5'

Oracle manages disk groups through ASM instances, which are created by using Gird users to connect to ASM instances.

[grid @ rac1 ~] $sqlplus / as sysasm

SQL > create diskgroup arch external redundancy disk'/ dev/asm-disk5'

Diskgroup created.

SQL > select name,state from v$asm_diskgroup

NAME STATE

DATA MOUNTED

OCR MOUNTED

ARCH MOUNTED

Unmount the disk group:

SQL > alter diskgroup arch dismount

Diskgroup altered.

Try to uninstall DATA:

SQL > alter diskgroup data dismount

Alter diskgroup data dismount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15027: active use of diskgroup "DATA" precludes its dismount

Try to uninstall OCR:

SQL > alter diskgroup ocr dismount

Alter diskgroup ocr dismount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15027: active use of diskgroup "OCR" precludes its dismount

Close the database instance and try to uninstall DATA. (uninstall only when both nodes are closed)

[grid @ rac1 ~] $srvctl stop database-d racdb

Ora.racdb.db

1 OFFLINE OFFLINE Instance Shutdown

2 OFFLINE OFFLINE Instance Shutdown

SQL > alter diskgroup data dismount

Diskgroup altered.

The OCR disk group cannot be uninstalled, and the CRSD process and the CTSS process use the OCR/VF disk group. If the cluster is closed, the ASM instance will also be shut down, and the ASM instance cannot be connected to execute the disk group unmount command, nor can the asmcmd command be executed to pull up the graphical interface.

Delete a disk group:

View the current disk group status:

SQL > select name,state from v$asm_diskgroup

NAME STATE

DATA MOUNTED

OCR MOUNTED

ARCH DISMOUNTED

Delete ARCH:

SQL > drop diskgroup arch

Drop diskgroup arch

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15001: diskgroup "ARCH" does not exist or is not mounted

Mount ARCH to drop again

SQL > alter diskgroup arch mount

Diskgroup altered.

SQL > drop diskgroup arch

Diskgroup dropped.

Does the disk group of dismount have to be mounted by mount before it can be deleted by drop?

Try a graphical drop unmounted disk group:

Current diskgroup information:

Disk groups in the dismount state can be deleted using a graphical interface

Delete DATA:

SQL > drop diskgroup DATA

Drop diskgroup DATA

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15053: diskgroup "DATA" contains existing files

Delete OCR:

SQL > drop diskgroup OCR

Drop diskgroup OCR

*

ERROR at line 1:

ORA-15039: diskgroup not dropped

ORA-15276: ASM diskgroup OCR has cluster voting files

Conclusion:

1. The meaning of mounting and using is different.

two。 When the disk group is used by the database, it cannot be unmounted and deleted, and the following error occurs:

If the 3.ASM instance goes down, the database instance using ASM will also be down.

Question:

Why the diskgroup dismount state cannot be deleted by drop on the command line? it still needs to be deleted on mount before it can be deleted using the graphical interface asmca. When the diskgroup dismount state, it can be deleted by drop. At this point, I believe you have a deeper understanding of "what is the method of unloading and deleting Oracle ASM disk groups". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.