Sun Cluster and Oracle database Post: 302420522

Sponsored Content

Operating Systems Solaris Sun Cluster and Oracle database Post 302420522 by fahdmirza on Wednesday 12th of May 2010 01:38:00 AM

05-12-2010

Registered User

Sun Cluster and Oracle database

Hi, I am using Oracle 10gR2 on Solaris 10.

I have two machines which are part of sun cluster. This is active-passive cluster. Node 1 is active and the Node 2 is passive. Both Node 1 and Node 2 are connected to separate SANs. Both nodes have separate databases. On both nodes, the database datafiles, control files, redologs are on mount point /u01.

Now I have to move node 1 to some other location, and there it would be not be part of sun cluster. I will connect the node 1 to a new SAN.

If I move node1 to new location. Connect the SAN and create the mount point /u01, and then copy all the data files, control files, redo logs to /u01 and then start the database, then is this the ok strategy?

Does SUN cluster has any effect on the Oracle database or is it transparent to the Oracle database?

regards

fahdmirza

View Public Profile for fahdmirza

Find all posts by fahdmirza

3 More Discussions You Might Find Interesting

1. Solaris

sun cluster 3.2 + oracle 11g HA problem C748634 ,C135343

Dear Cluster Guru, I had installed sc 3.2 on 2 box sunfire 240 (solaris 10 update 7 ,each node 2 gb ram) and use scsi juke box as share storage . i had test cluster application : 1. apache HA 2 oracleHA (oracle 9i) all running well (switch over between...

2. Solaris

Sun cluster and Veritas cluster question.

Yesterday my customer told me to expect a vcs upgrade to happen in the future. He also plans to stop using HDS and move to EMC. Am thinking how to migrate to sun cluster setup instead. My plan as follows leave the existing vcs intact as a fallback plan. Then install and build suncluster on...

3. Solaris

Sun cluster 4.0 - zone cluster failover doubt

Hello experts - I am planning to install a Sun cluster 4.0 zone cluster fail-over. few basic doubts. (1) Where should i install the cluster s/w binaries ?. ( global zone or the container zone where i am planning to install the zone fail-over) (2) Or should i perform the installation on...

LEARN ABOUT LINUX

ndb_print_sys_file

NDB_PRINT_SYS_FIL(1)					       MySQL Database System					      NDB_PRINT_SYS_FIL(1)

NAME

       ndb_print_sys_file - print NDB system file contents

SYNOPSIS

       ndb_print_sys_file file_name

DESCRIPTION

       ndb_print_sys_file obtains diagnostic information from a MySQL Cluster system file.
	       Usage

	   ndb_print_sys_file file_name

       file_name is the name of a cluster system file (sysfile). Cluster system files are located in a data node's data directory (DataDir); the
       path under this directory to system files matches the pattern ndb_#_fs/D#/DBDIH/P#.sysfile. In each case, the # represents a number (not
       necessarily the same number). For more information, see MySQL Cluster Data Node FileSystemDir Files[1].

       Like ndb_print_backup_file and ndb_print_schema_file (and unlike most of the other NDB utilities that are intended to be run on a
       management server host or to connect to a management server) ndb_print_backup_file must be run on a cluster data node, since it accesses
       the data node file system directly. Because it does not make use of the management server, this utility can be used when the management
       server is not running, and even when the cluster has been completely shut down.
	       Additional Options

       None.

COPYRIGHT

       Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.

       This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
       published by the Free Software Foundation; version 2 of the License.

       This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
       MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

       You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
       Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.

NOTES

	1. MySQL Cluster Data Node FileSystemDir Files
	   http://dev.mysql.com/doc/ndbapi/en/ndb-internals-ndbd-filesystemdir-files.html

SEE ALSO

       For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
       at http://dev.mysql.com/doc/.

AUTHOR

       Oracle Corporation (http://dev.mysql.com/).

MySQL 5.5							    01/30/2014						      NDB_PRINT_SYS_FIL(1)