[Translated from mos] mosasm

[Translated from mos] mosasm

How to reclaim the asm disk space

Reference Original:
How To Reclaim Asm Disk Space? (Docid 351866.1)

Applicable:
Oracle Database-Enterprise Edition-Version 10.2.0.1 and later
Information in this document applies to any platform.
* ** Checked for relevance on 12-Jan-2010 ***

Objectives:
You have a set of 2-node rac.
To test the backup policy, you use the asm storage to create a backup, and archive is also in the asm.

You notice that after the archive log is deleted, the asm space is not released (release)

You deleted the test database, but the asm space was not released.
Now you need to delete the backup file and archive logs. All these files are stored in asm.

How?

Solution:

In versions earlier than 11.2:
You can use the asmcmd command:
$ Asmcm
ASMCMD> cd RECOVERYDEST -- change to the diskgroup
ASMCMD> pwd -- current directory
ASMCMD> find.-t BACKUPSET. * -- will list the backupset files stored in the diskgroup
-- The-t flag can have values like DATAFILE, ARCHIVELOG, CONTROLFILE, ONLINELOG

Once files are found, you can use the rm command to delete them.

11.2 and later versions:
You need to use the -- type option (instead of the-t option)
Usage: find [-- type] dir pattern

Eg:

ASMCMD> find -- type BACKUPSET .*