Re: RAC & RAW Question

From: zhu chao <zhuchao_at_gmail.com>
Date: Sat, 23 Apr 2005 15:28:17 +0800
Message-ID: <962cf44b0504230028196cf53a@mail.gmail.com>

Hi,=20

If your underlying OS supports it, of course you can grow the raw device( in most modern OS, it is raw Volumns).

Here is an example:
-bash-3.00# vxassist -g testdg make testrawvol 100m=20 -bash-3.00# vxedit -g testdg set user=3Doracle testrawvol [oracle_at_ebaysha2**ora10g]$sqlplus=20

SQL*Plus: Release 10.1.0.3.0 - Production on Sat Apr 23 00:25:36 2005

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Productio= n
With the Partitioning, OLAP and Data Mining options

SQL> create tablespace rawts datafile '/dev/vx/rdsk/testdg/testrawvol' reus= e;=20

Tablespace created.
SQL> select name,status,bytes from v$datafile where name like '/dev/%';

NAME                                                         STATUS  =20
                 BYTES
------------------------------------------------------------
--------------------- ----------
/dev/vx/rdsk/testdg/testrawvol                               ONLINE  =20
             104849408

-bash-3.00# vxassist -g testdg growto testrawvol 200m

SQL> alter database datafile '/dev/vx/rdsk/testdg/testrawvol' resize 199m;= =20

Database altered.

SQL> select name,status,bytes from v$datafile where name like '/dev/%';

NAME                                                         STATUS  =20
                 BYTES
------------------------------------------------------------
--------------------- ----------
/dev/vx/rdsk/testdg/testrawvol                               ONLINE  =20
             208666624

to convert a database on filesystem to raw volume, you can use either rman copy command , or unix dd to do this, Not difficult. Consult metalink note for detail.

On 4/23/05, Stephen Andert <andert_at_gmail.com> wrote:
> Additional information:

>=20

> AIX 5L

>=20

> Oracle 9.2.0.6 (They wanted me to use 9.2.0.4, but I think I convinced
> them that the 78 bugs for RAC fixed in .5 and .6 make it a good idea
> to go with .6)

>=20

> With AIX, the only clustered file system that is currently available
> (to our knowledge) is GPFS and we have been told by some who have
> implemented it that they would not recommend it for production use.
> (bugs and other "features").

>=20

> Thanks
> Stephen
> ---------- Forwarded message ----------
> From: Stephen Andert <andert_at_gmail.com>
> Date: 22-abr-2005 14:40
> Subject: RAC & RAW Question
> To: oracle-l_at_freelists.org

>=20

> Hi all,

>=20

> I am working on getting RAC set up. It is sr mgmt's idea and I'm not
> sure that it will provide what they think it will.

>=20

> I have a question about growing with RAW.

>=20

> I read in a book that RAW partitions cannot be extended. After
> discussing this with my friendly neighborhood SysAdmin team, they have
> told me that growing a RAW partition/device is not a problem. They
> don't even think I need to bring down the database.

>=20

> My questions are:

>=20

> Q1. Is it possible that the author was speaking in general terms and
> that in my environment, we have an OS, etc that allows this (AIX,
> EMC)?

>=20

> Q2. Is it that the OS can do it, but the database cannot recognize
> it? (I thought a alter database datafile ... RESIZE would work)

>=20

> Q3. Can anyone point me towards a best practices with RAW white paper?

>=20

> Q4. Does anyone have any pointers towards converting a cooked
> database to RAW? It is large enough that export/import will take more
> time that I think we will get approved for. We are theorizing that if
> we "reshape" the database to tablespaces with single files that match
> the sizes of the RAW devices we will be getting, that an RMAN
> alternate node restore with file rename will work. Thoughts or
> comments on this?

>=20

> Thanks
> Stephen
> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Regards
Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Apr 23 2005 - 03:32:33 CDT