ASM file numbering

ASM instance does not have any physical storage component associated with it. All the metadata is stored as disk header. The data is stored in files, which are numbered < 256, with an exception of (asmparameterfile & ocrfile)

So first database related file created, would starts with 256

SQL> select group_kffxp, min (number_kffxp), 
max (number_kffxp) from x$kffxp group by group_kffxp;
GROUP_KFFXP MIN(NUMBER_KFFXP) MAX(NUMBER_KFFXP)
----------- ----------------- -----------------
 1          1                  308
 2          1                  551
 3          1                  256
 4          1                  277

SQL> select group_number, min(file_number), 
max(file_number) from v$asm_file group by group_number;
GROUP_NUMBER MIN(FILE_NUMBER) MAX(FILE_NUMBER)
------------ ---------------- ----------------
 1           256              308
 2           256              551
 3           253              256
 4           256              277

So what are the files in GROUP_NUMBER 3?

SQL> select file_number, type from v$asm_file 
where group_number=3 and FILE_NUMBER < 256;
FILE_NUMBER TYPE
----------- ------------
 253 ASMPARAMETERFILE
 255 OCRFILE

 

 

Advertisements
This entry was posted in Oracle Automatic Storage Management and tagged . Bookmark the permalink.

One Response to ASM file numbering

  1. udayjampani says:

    Your blog is outstanding , you are dealing with the items in Oracle that people are not very familiar with . Please resume your writing for the sake of oracle enthusiasts

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s