Re: RAC & RAW Question

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@ebaysha2**ora10g]$sqlplus=20

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

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

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@xxxxxxxxx> 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@xxxxxxxxx>
> Date: 22-abr-2005 14:40
> Subject: RAC & RAW Question
> To: oracle-l@xxxxxxxxxxxxx
>=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

Other related posts: