Re: How to resize Oracle9i tablespace in RAC environment ?
- From: "Harmeet Luthra" <harmeetluthra@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Fri, 14 Dec 2007 06:28:25 +0530
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:
