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

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

Hi,
We at Disaster recovery site are having RAC on 9.2.0.7 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.
0
RahulKatiyar
Asked:
RahulKatiyar
1 Solution
 
MikeOM_DBACommented:

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.
0

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