Re: RAC & RAW Question
- From: zhu chao <zhuchao@xxxxxxxxx>
- To: andert@xxxxxxxxx
- Date: Sat, 23 Apr 2005 15:28:17 +0800
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
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Regards
Zhu Chao
www.cnoug.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
