Oracle RAC 1-node system redo Problem

In the Oracl RAC 10.2.0.4 environment where the operating system is Linux, the local hard disk of a node server is suddenly damaged and stops running. The remaining node still works normally and continues to provide external database services.

The problem is clear. After the operating system retries, how can I add a server with damaged hard disk to the RAC cluster?

I checked it on Google and METALINK, but there are exactly the same questions, but there is no desired answer.

This post is posted in the discussion area on the Oracle official website, which is basically the same as what I described.

Hello all. I have a two-node 10g R2 RAC with ASM patched to 10.2.0.4 running on RedHat AS4 x86_64. we recently had an accidental release of an Inergen fire suppression system at or collocation facility. this release caused release of our disks to fail causing issues for some of our systems. for the most part, we were very lucky having built-in redundancy limit SS LUNs; however, we lost all 4 disks of local storage on Node1 of our two-node RAC.

...............

I appreciate any help, and I'm greatful for your time.

(Foreigners are a little better at it. In the end, I would like to thank you .)

Someone provides the following solution:

[Root @ webrac1 crs_1] # more root. sh

#! /Bin/sh

/U01/app/oracle/product/10.2.0/crs_1/install/rootinstall

/U01/app/oracle/product/10.2.0/crs_1/install/rootconfig

 

[Root @ webrac1 crs_1] #./root. sh

WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root

WARNING: directory '/u01/app/oracle/product' is not owned by root

WARNING: directory '/u01/app/oracle' is not owned by root

Checking to see if Oracle CRS stack is already configured

/Etc/oracle does not exist. Creating it now.

 

Setting the permissions on OCR backup directory

Setting up NS directories

Oracle Cluster Registry configuration upgraded successfully

WARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by root

WARNING: directory '/u01/app/oracle/product' is not owned by root

WARNING: directory '/u01/app/oracle' is not owned by root

Clscfg: EXISTING configuration version 3 detected.

Clscfg: version 3 is 10G Release 2.

Successfully accumulated necessary OCR keys.

Using ports: CSS = 49895 CRS = 49896 EVMC = 49898 and EVMR = 49897.

Node <nodenumber>: <nodename> <private interconnect name>

Node 1: webrac1 webrac1-priv webrac1

Node 2: webrac2 webrac2-priv webrac2

Clscfg: Arguments check out successfully.

 

No keys were written. Supply-force parameter to override.

-Force is destructive and will destroy any previous cluster

Configuration.

Oracle Cluster Registry for cluster has already been initialized

Startup will be queued to init within 30 seconds.

Adding daemons to inittab

Expecting the CRS daemons to be up within 600 seconds.

CSS is active on these nodes.

Webrac1

Webrac2

CSS is active on all nodes.

Waiting for the Oracle CRSD and EVMD to start

Oracle CRS stack installed and running under init (1 M)

Running vipca (silent) for processing nodeapps

 

Create VIP application resources on the (0) node.

Create GSD application resources on the (0) node.

Create ONS application resources on the (0) node.

Start (2) VIP application resources on the node...

Start GSD application resources on (2) nodes...

Start ONS application resources on (2) nodes...

 

Done.

 

Step 6: modify the configuration file/etc/oratab

Copy the file from the surviving node and modify the attributes and content.

[Root @ webrac2 archivelog] # scp/etc/oratab webrac1:/etc/

Root @ webrac1's password:

Oratab

100% 766 0.8KB/s

[Root @ webrac2 archivelog] #

 

 

[Root @ webrac1 etc] # chown-R oracle: root oratab

[Root @ webrac1 etc] # ls-ltr oratab

-Rw-r -- 1 oracle root 766 05-08 oratab

[Root @ webrac1 etc] # vi oratab

#

+ ASM1:/u01/app/oracle/product/10.2.0/db_1: N

Webdb:/u01/app/oracle/product/10.2.0/db_1: N

~

 

Step 7: run the "root. sh" command under RDBMS.

[Root @ webrac1 db_1] #./root. sh

Running Oracle10 root. sh script...

 

The following environment variables are set:

ORACLE_OWNER = oracle

ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1

 

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to/usr/local/bin...

Copying oraenv to/usr/local/bin...

Copying coraenv to/usr/local/bin...

 

Entries will be added to the/etc/oratab file as needed

Database Configuration Assistant when a database is created

Finished running generic part of root. sh script.

Now product-specific root actions will be saved med.

 

Step 8: modify the configuration file $ ORACLE_HOME/network/admin/listener. ora

The configuration of the original listener file is based on node 2. All settings are modified to conform to node 1. This modification is easy.

LISTENER_WEBRAC1 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = webrac1-vip) (PORT = 1521) (IP = FIRST ))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.42) (PORT = 1521) (IP = FIRST ))

)

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC ))

)

)

)

 

Step 9: Modify the spfile and password files under the configuration file $ ORACLE_HOME/dbs. The objects are ASM instances and database instances.

You only need to modify the file name, for example:

Cp orapw + ASM2 orapw + ASM1

Cp spfile + ASM2.ora spfile + ASM1.ora

 

Step 10: Use crs_start-all to start all resources.

After these 10 steps, the new system is quickly added to RAC. The Database Service does not need to be stopped throughout the process.

 

[Oracle @ webrac1 ~] $ Crs_stat-t

Name Type Target status host

------------------------------------------------------------

Ora. webdb. db application ONLINE webrac2

Ora... ebdb. cs application ONLINE webrac2

Ora... db1.srv application ONLINE webrac2

Ora... b1.inst application ONLINE webrac1

Ora... b2.inst application ONLINE webrac2

Ora... SM1.asm application ONLINE webrac1

Ora... C1.lsnr application ONLINE webrac1

Ora... ac1.gsd application ONLINE webrac1

Ora... ac1.ons application ONLINE webrac1

Ora... ac1.vip application ONLINE webrac1

Ora... SM2.asm application ONLINE webrac2

Ora... C2.lsnr application ONLINE webrac2

Ora... ac2.gsd application ONLINE webrac2

Ora... ac2.ons application ONLINE webrac2

Ora... ac2.vip application ONLINE webrac2

[Oracle @ webrac1 ~] $

2. Summary
The key to this problem is the root. sh file in the $ CRS Directory, which creates some files in the/etc directory. If you are clear about these files, you can also create them manually.

The entire RAC environment is normal, and the OCR configuration can be accessed normally on the storage, so the problem is essentially configuring the access link.

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12