Shulou(Shulou.com)06/01 Report--

Environment: oracle 11.2.0.4 rac

Problem description: after adding a node 3 on node 1, when starting three nodes later, it is found that the instance startup on the newly added node 3 takes up undotbs1, resulting in the following error in the instance startup time on node 1:

ORA-30013: undo tablespace 'UNDOTBS1' is currently in use

Then, if you do the following manually, the three nodes can start normally

Srvctl stop database-d satdb

Srvctl start database-d satdb

Later, after restarting the server on three nodes, node 1 will have the situation that UNDOTBS1 is occupied.

Solution:

If the database of the three nodes is open, close it normally. Start a node, where I am the startup node 1, do the following

Backup parameter file

Create pfile from spfile

Set the undo tablespace used by the instance on node 3

Alter system set undo_tablespace 'UNDOTBS3' sid='db3'.

Then use the following command to start the other two nodes

Srvctl start instance-d db-I db2,db3

After starting the two instances, restart the server where the three nodes are located directly to see if the three instances can be started normally.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.