Re: 10 ASM question

And further question, if I replace the broken disk in a disk group, I have to do
SQL> alter diskgroup test_group1 drop disk disk1; replace it with a good disk
SQL> alter diskgroup test_group1 add disk 'dev/sdb' name disk1;

Am I right?

"joe bayer" <joebayerii(no-spam)@hotmail.com> wrote in message news:ZR8xe.14503$Q27.9634_at_trndny02...
> Does anybody here used Oracle 10G ASM? Is it reliable? Do you guys
> recommend it?
>
> I have two question here.
>
> 1) If there is a disk failed in one disk group, how could I tell which
> disk, in which disk group failed? Any dynamic view to tell this?
>
> 2) the create tablespace is like this:
> SQL> create teablespace test_tbsp2 datafile '+test_group1';
> there is not size specified, does it mean the tablespace will take the
> whole disk groups?
>
> Thanks very much for your help.
>
Received on Fri Jul 01 2005 - 05:37:26 CDT