Home » RDBMS Server » Server Administration » Regarding ASM (Oracle 10g, Windows XP)
Regarding ASM [message #574870] Wed, 16 January 2013 07:41 Go to next message
morad_dba
Messages: 73
Registered: June 2008
Member
Dear all,

I Configured an ASM instance and a disk group with two disk for normal redundancy.

> Here .. each disk is 2gb

The disk group has two disks...


SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;

GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ------------------------------ ------ ---------- ----------
1 DATA NORMAL 4000 3898


Now my question is ... as the group has two way mirroring (Normal redundancy)

How much data (2 GB or 4 GB) can i keep in the disk group?

My conception is I can keep 2 GB data in the disk group... (as the disk group keeps every extent in another disk as mirror)

Is it right?

Regards,
Morad.

[Updated on: Wed, 16 January 2013 08:19]

Report message to a moderator

Re: Regarding ASM [message #574884 is a reply to message #574870] Wed, 16 January 2013 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topics:

Michel Cadot wrote on Wed, 08 August 2012 09:21
...
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
...


Michel Cadot wrote on Wed, 04 July 2012 13:03
...
2/ Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

3/ Also always post your Oracle version, with 4 decimals.
...


See v$asm_diskgroup.USABLE_FILE_MB
All views are described in Database Reference

Regards
Michel




Re: Regarding ASM [message #574885 is a reply to message #574884] Wed, 16 January 2013 09:08 Go to previous messageGo to next message
morad_dba
Messages: 73
Registered: June 2008
Member

Thanks Brother,

I created a tablespace as

SQL> create tablespace data2 datafile '+data' size 1800m;

Now available free space is only 146 m.

QL> select group_number, name, type, total_mb, free_mb
2 , USABLE_FILE_MB from v$asm_diskgroup;

GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB USABLE_FILE_MB
------------ ------- ------ ---------- ---------- --------------
1 DATA NORMAL 4000 292 146

I got my answer.

Thanks.

Re: Regarding ASM [message #574889 is a reply to message #574885] Wed, 16 January 2013 09:26 Go to previous message
Michel Cadot
Messages: 59748
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 16 January 2013 15:51
From your previous topics:

Michel Cadot wrote on Wed, 08 August 2012 09:21
...
Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
...


Michel Cadot wrote on Wed, 04 July 2012 13:03
...
2/ Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

3/ Also always post your Oracle version, with 4 decimals.
...

...

Previous Topic: Preventing database shutdown by a trigger
Next Topic: fresh installation with old oradata
Goto Forum:
  


Current Time: Sat Nov 22 21:48:28 CST 2014

Total time taken to generate the page: 0.07616 seconds