• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 618
  • Last Modified:

How to change 2 instance RAC database in to single instance.

We at Disaster recovery site are having RAC on on AIX. Currently we are having two instance physical standby databases.
Now we need to change the 2 instance setup into single instance environment how should I proceed.
1 Solution

Stop all services.
Create pfile from spfile.
Shutdown database.
remove "*.cluster_database_instances" and set "*.cluster_database=FALSE" in the init{SID}.ora file.
startup pfile=init{SID}.ora
and done.

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now