OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Regarding ASM (Oracle 10g, Windows XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Regarding ASM [message #574870]

Wed, 16 January 2013 07:41

morad_dba
Messages: 93
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

Michel Cadot
Messages: 68634
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

Report message to a moderator

Re: Regarding ASM [message #574885 is a reply to message #574884]

Wed, 16 January 2013 09:08

morad_dba
Messages: 93
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.

Report message to a moderator

Re: Regarding ASM [message #574889 is a reply to message #574885]

Wed, 16 January 2013 09:26

Michel Cadot
Messages: 68634
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.
...

...

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 07:28:06 CDT 2024