Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3230
  • Last Modified:

How to drop ASM diskgroup

Hi,
I am new to ASM and am trying to drop a BACKUP diskgroup in a RAC env. I have dropped the diskgroup but still see iin ASM_DISKGROUP and ASM_DISK.

What is the full process as these files are raw devices on a SAN as well and I'd like to tidy it all up.

drop diskgroup backup;

SQL> select * from v$asm_diskgroup;
GROUP_NUMBER NAME                           SECTOR_SIZE BLOCK_SIZE
------------ ------------------------------ ----------- ----------
ALLOCATION_UNIT_SIZE STATE       TYPE     TOTAL_MB    FREE_MB
-------------------- ----------- ------ ---------- ----------
REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB OFFLINE_DISKS U
----------------------- -------------- ------------- -
COMPATIBILITY
------------------------------------------------------------
DATABASE_COMPATIBILITY
------------------------------------------------------------
           1 ARCH                                   512       4096
             1048576 MOUNTED     EXTERN     767692     766438
                      0         766438             0 N
10.1.0.0.0
10.1.0.0.0
           0 BACKUP                                 512       4096
             1048576 DISMOUNTED                  0          0
                      0              0             0 N
0.0.0.0.0
0.0.0.0.0
           3 DATA                                   512       4096
             1048576 MOUNTED     EXTERN    1048576    1046934
                      0        1046934             0 N
10.1.0.0.0
10.1.0.0.0

SQL>

SQL> select * from v$asm_disk;
GROUP_NUMBER DISK_NUMBER COMPOUND_INDEX INCARNATION MOUNT_S HEADER_STATU MODE_ST
------------ ----------- -------------- ----------- ------- ------------ -------
STATE    REDUNDA
-------- -------
LIBRARY                                                            TOTAL_MB
---------------------------------------------------------------- ----------
   FREE_MB NAME                           FAILGROUP
---------- ------------------------------ ------------------------------
LABEL
-------------------------------
PATH
--------------------------------------------------------------------------------
UDID
----------------------------------------------------------------
PRODUCT                          CREATE_DA MOUNT_DAT REPAIR_TIMER      READS
-------------------------------- --------- --------- ------------ ----------
    WRITES  READ_ERRS WRITE_ERRS  READ_TIME WRITE_TIME BYTES_READ BYTES_WRITTEN
---------- ---------- ---------- ---------- ---------- ---------- -------------
           0           0              0           0 CLOSED  FOREIGN      ONLINE
NORMAL   UNKNOWN
System                                                                  256
         0
/dev/rdsk/asmdisk/voting
                                                                0

           0           1              1           0 CLOSED  MEMBER       ONLINE
NORMAL   UNKNOWN
System                                                               139739
         0
/dev/rdsk/asmdisk/backup2
                                 07-NOV-08 07-NOV-08            0

           0           3              3           0 CLOSED  FORMER       ONLINE
NORMAL   UNKNOWN
System                                                               139739
         0
/dev/rdsk/asmdisk/backup1
                                 07-NOV-08 12-NOV-08            0

           3           0       50331648  4081152436 CACHED  MEMBER       ONLINE
NORMAL   UNKNOWN
System                                                              1048576
   1046934 DATA_0000                      DATA_0000
/dev/rdsk/asmdisk/data
                                 31-OCT-08 13-NOV-08            0         14
         1          0          0          0        .01      61440          4096
           1           0       16777216  4081152437 CACHED  MEMBER       ONLINE
NORMAL   UNKNOWN
System                                                               767692
    766438 ARCH_0000                      ARCH_0000
/dev/rdsk/asmdisk/arch
                                 04-NOV-08 13-NOV-08            0         14
         1          0          0        .02          0      61440          4096

SQL>
0
Incabus
Asked:
Incabus
1 Solution
 
HoggZillaCommented:
This is probably not the correct zone for this question. This is SQL Server Integration Services. Are you trying to write this job into an SSIS package to run agains an Oracle db?
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now