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

The main content of this article is "how to expand ASM disk groups". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to expand the ASM disk group.

Log in to EM (virtual machine practice environment) today, prompt EM to shut down, check the database, and find that the instance is not started.

Prompt ORA-03113 for startup: end-of-file on communication channel

The following error was found in the production alter log

-

ARC0: Error 19504 Creating archive log file to'+ DATA'

Errors in file / u01/app/oracle/diag/rdbms/ocpasm1/OCPASM1/trace/OCPASM1_arc1_11472.trc:

ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.

ORA-17502: ksfdcre:4 Failed to create file + DATA

ORA-15041: diskgroup "DATA" space exhausted

Confirm that there is not enough space left in DATA group after startup mount:

SQL > select group_number,name,state,total_mb,free_mb from v$asm_diskgroup

GROUP_NUMBER NAME STATE TOTAL_MB FREE_MB

-

1 DATA MOUNTED 4000 6

2 FRA MOUNTED 3000 2946

3 OCR MOUNTED 3000 1880

So the query asm vg found that there was still room left, which was great to expand.

[root@OCPLHR ~] # vgdisplay

-Volume group

VG Name vg_oraasm

System ID

Format lvm2

Metadata Areas 1

Metadata Sequence No 2

VG Access read/write

VG Status resizable

MAX LV 0

Cur LV 1

Open LV 1

Max PV 0

Cur PV 1

Act PV 1

VG Size 15.00 GB

PE Size 4.00 MB

Total PE 3839

Alloc PE / Size 3584 / 14.00 GB

Free PE / Size 1020 / 1020.00 MB

VG UUID QHMkJt-XJfQ-gL9a-antn-6jfJ-OOdH-3vSll1

-

So add disks and extend DATA group:

Dd if=/dev/zero of=/asmdisk/disk9 bs=1024k count=1000

/ sbin/losetup / dev/loop9 / asmdisk/disk9

Raw/ dev/raw/raw9 / dev/loop9

Chmod 660 / dev/raw/raw9

Chown oracle:dba / dev/raw/raw9

Grid > sqlplus / as sysasm

Alter diskgroup DATA add disk'/ dev/raw/raw9'

Select operation,est_minutes from vault operations; # confirm that the redundancy balance is complete

After restarting the database, the database returns to normal.

SQL > select name,group_number,state,redundancy,total_mb,free_mb,path from v$asm_disk

NAME GROUP_NUMBER STATE REDUNDANCY TOTAL_MB FREE_MB PATH

FRA_0002 2 NORMAL UNKNOWN 1000 981 / dev/raw/raw8

FRA_0001 2 NORMAL UNKNOWN 1000 983 / dev/raw/raw7

FRA_0000 2 NORMAL UNKNOWN 1000 982 / dev/raw/raw6

DATA_0002 1 NORMAL UNKNOWN 1000 223 / dev/raw/raw5

DATA_0001 1 NORMAL UNKNOWN 1000 214 / dev/raw/raw4

DATA_0000 1 NORMAL UNKNOWN 1000 220 / dev/raw/raw3

OCR_0001 3 NORMAL UNKNOWN 1000 940 / dev/raw/raw2

OCR_0000 3 NORMAL UNKNOWN 1000 940 / dev/raw/raw1

DATA_0003 1 NORMAL UNKNOWN 1000 248 / dev/raw/raw9

Finally, it was found that EM did not start.

Emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0

Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.

Https://OCPLHR:1158/em/console/aboutApplication

Oracle Enterprise Manager 11g is not running.

Start EM manually:

Emctl start dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0

Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.

Https://OCPLHR:1158/em/console/aboutApplication

Starting Oracle Enterprise Manager 11g Database Control. Started.

Logs are generated in directory / u01/app/oracle/product/11.2.0/dbhome_1/OCPLHR_OCPASM1/sysman/log .

At this point, I believe you have a deeper understanding of "how to expand 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.