Oracle shutdown steps in a failover cluster

[former_member199632]

Hi all,

The PRD setup is as follows

One single oracle 10.2.0.4 Database, with two physical Servers (DBServ-1, DBServ-2)

Oracle is in a SUSE Linux cluster . (Not RAC environment. Just an OS level cluster to maintain fail over);

Currently DBServ-1 node is active, and DBServ-2 is standby

We needs to shutdown this entire setup and restart again.

What is the correct set of sequence to shutdown oracle DB?

Since DBServ-2 is standby, without any issue we can shutdown DBServ-2 as normal server shutdown. (ex: init 0)

But, oracle is up and running on DBServ-1 Node.

From where should i stop this?

Is it from the SuSE Cluster or from inside the DB? (login as / and issue shutdown immediate)

Your views, comments are welcome

Thx & Regards,

Zerandib

[sunny_pahuja2]

Hi,

As you mentioned that clustering is OS level, then you can simply stop the DB from command line.

Thanks

Sunny

[former_member199632]

Sunny,

Will that make any impact , when starting the cluster and DB back.

Starting of the DB, should perform by cluster options or via commandline?

thx

[sunny_pahuja2]

Hi,

It depends upon your cluster configuration. If you have made cluster script in such a way that while starting cluster, it will automatically start SAP system then you need not to do anything while starting the cluster again and it will start your SAP system automatically.

Thanks

Sunny