Modifying the oracle Instance name in the middle of the night

I just came back from Huilongguan, and now it's am. The miserable itrip man started to work. A two-node rac made by oracle11g. The host names are rac1 and rac2, respectively. The instance names are db4qg_1 and db4qg_2. The expected effect is rac1.

I just came back from Huilongguan, and now it's am. The miserable itrip man started to work. A two-node rac made by oracle11g. The host names are rac1 and rac2, respectively. The instance names are db4qg_1 and db4qg_2. The expected effect is rac1.

Back from return to longguan, the virtual host is now am, and the miserable it man started to work.

A two-node oracle 11g rac with the host names rac1 and rac2 respectively. The instance names are db4qg_1, db4qg_2, and Hong Kong servers. The effect required is that the rac1 node starts the instance db4qg_1, the rac2 node starts db4qg_2, but the actual operation is reversed. Now, we recommend that you correct this rac's replica uard.

The procedure is as follows:
1. Back up the database and control files. I asked others to export one copy, and I used rman for another one.
2. Check the running status of the current instance. The output result is:
Instance DB4QG_1 is running on node rac2

Instance DB4QG_2 is running on node rac1
3. Disable two instances:
Srvctl stop instance-d DB4QG-I DB4QG_2
Srvctl stop instance-d DB4QG-I DB4QG_1
4. Check whether the oracle process is normally shot in the system of the two nodes. ps aux | grep ora
5. Modify the Instance name:
Srvctl modify instance-d DB4QG-I DB4QG_1-n rac1
Srvctl modify instance-d DB4QG-I DB4QG_2-n rac2
6. start two instances and replace stop in step 3 with start.
7. Check the operation status of the modified instance. Copy Step 1. Hey, you have moved it like a contractor.

Record this and forget it.

This article is from the "sery" blog. Please keep this source