Re: Moving a database to clustered enviroment.

Brian Peasland wrote:
> nirav wrote:
> > Hi,
> >
> > I have one database that is in non clustered environment- a solaris
> > server. From there, I need to move it to veritas clustered enviroment.
> > there are 2 other solaris servers and there is VCS (veritas cluster
> > software set up betn these 2 servers.)
> >
> > How how has to go about doing this? is it simply creating the database
> > and the VCS will take care of itself , and the new database created
> > will be automatically clustered?
> >
> > I am new to clustered set ups and shall be thankful for help.
> >
> > Nirav
> >
>
> In order for you to use Oracle on multiple nodes to access the same
> database datafiles in a clustered environment, you will also need to use
> Oracle's Real Application Clusters (RAC) software. RAC incurs an
> additional charge. Have a look at the RAC documentation
> (http://tahiti.oracle.com) for instructions.
>
> HTH,
> Brian
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_nospam.peasland.net
> http://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown

I doubt this is the situation in which he finds himself. Using a Veritas Cluster filesystem does not automatically imply RAC; it may simply indicate a desire for automatic failover should the primary server in the cluster 'die', allowing for Oracle to continue to function when hardware failures occur. This is not the same as RAC, as only one instance is running at any given time.

This does, however, provide additional tasks for the DBA when database maintenance is required, such as software patches and parameter changes requiring the shutdown and restart of the instance. The cluster will need to be taken offline (and more than one cluster service may be affected as one service may depend upon another). In *basic* terms (and I stress the term 'basic') the strategy would be:

Build and test the Veritas cluster.

Offline the relevant/dependent services the database is using, dependent services first.

Install the Oracle software.

Patch the installation.

Build the database.

Load the data.

Verify the data.

Online the cluster services in the reverse order in which they were taken offline.

Generally speaking you now have an Oracle database running in a Veritas clustered environment. Of course all of this is dependent upon how your cluster is built/configured. I state again this is a *general* description of the tasks involved; it is by no means a detailed 'how-to' document.

When you have specific questions post them here. More detailed answers should be forthcoming once the specifics are known.

David Fitzjarrell Received on Mon Jul 03 2006 - 14:44:54 CDT