Re: How to resize Oracle9i tablespace in RAC environment ?

there should be no diffrent to increase the tablespace in rac as compared to
normal db as here only diffrence is that you are using two instances instead
of one .
Tell me if i am wrong .

On Nov 20, 2007 4:23 PM, Jurijs Velikanovs <j.velikanovs@xxxxxxxxx> wrote:

> Checking volume is something specific to OS.
> I guess you can use dd command to copy files back and force to check
> consistency.
> To add file "alter tablespace add datafile ....." RTFM.
>
> J.
>
> On Nov 20, 2007 12:35 PM, Nelabhotla Durga Charan
>  <charan.durga@xxxxxxxxx> wrote:
> > Hi,
> >
> > Resize is fine and  how to increse TBS ( by adding new datafile )  if
> > everything is ready from Unix side  like  how to check free logical
> > volumes..etc
> >
> >
> >
> > Regards
> > Durga
> >
> >
> > On 11/20/07, Jurijs Velikanovs <j.velikanovs@xxxxxxxxx> wrote:
> > > >> Please advice if anyone help me to increase/resize  the tablespace
> > > in RAC environment ?
> > > Ask you Sys Admin to increase size of RAW device to expected size +
> > 10/100MB
> > > Issue alter database .... file resize command to expected size.
> > > Nothing Apps specific, just regular RDBMS staff.
> > >
> > > J.
> > >
> > > On Nov 20, 2007 12:14 PM, Nelabhotla Durga Charan
> > > < charan.durga@xxxxxxxxx> wrote:
> > > > Hi,Thanks for quick response.
> > > >
> > > > My Oracle FS solution is RAW and we are using HP Cluster guard
> software.
> > > >
> > > > Regards
> > > > Durga
> > > >
> > > >
> > > >
> > > >
> > > > On 11/20/07, Jurijs Velikanovs <j.velikanovs@xxxxxxxxx> wrote:
> > > > > What is your FS solution?
> > > > > - RAW
> > > > > - OCFS
> > > > > - GFS
> > > > >
> > > > > Advice you are looking for depends from the answer.
> > > > >
> > > > > J
> > > > >
> > > > > On Nov 20, 2007 11:20 AM, Nelabhotla Durga Charan
> > > > > < charan.durga@xxxxxxxxx> wrote:
> > > > > > Hello Team,
> > > > > >
> > > > > > Good afternoon .
> > > > > >
> > > > > > Please advice if anyone help me to increase/resize  the
> tablespace
> > in
> > > > RAC
> > > > > > environment ?
> > > > > >
> > > > > > My environment is HP Itanium 11.11 Database 9.2.0.7 and we are
> using
> > HP
> > > > > > Cluster software and 2 Node Database setup.
> > > > > >
> > > > > >
> > > > > > Thanks in Advance.
> > > > > >
> > > > > > --
> > > > > > Best Regards
> > > > > > N.Durga Charan
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > Yury
> > > > > +371 29268222 (+2 GMT)
> > > > > ============================================
> > > > > http://otn.oracle.com/ocm/jvelikanovs.html
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > >
> > > >
> > > > Best Regards
> > > > N.Durga Charan
> > >
> > >
> > >
> > > --
> > > Yury
> > > +371 29268222 (+2 GMT)
> > > ============================================
> > > http://otn.oracle.com/ocm/jvelikanovs.html
> > >
> > >
> >
> >
> >
> > --
> >
> >
> > Best Regards
> > N.Durga Charan
>
>
>
> --
> Yury
> +371 29268222 (+2 GMT)
> ============================================
> http://otn.oracle.com/ocm/jvelikanovs.html
>
>

Other related posts: