Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle 12c RAC/ASM - creating standby db

Posted on 2016-10-20
4
Medium Priority
?
72 Views
Last Modified: 2016-11-09
I've already duplicated the target db, using rman duplicate ... from active database

and standby is mounted and looks good, now I need to add my other 2 instances and change the cluster_database parameter too

kind of lost in the steps ... please assist/guide here.

Thanks in advance.
0
Comment
Question by:Mushfique Khan
  • 2
  • 2
4 Comments
 
LVL 23

Expert Comment

by:David
ID: 41853937
Platform, DB version number, total number of hot instances, and what had you tried? IOW what resource or instruction set were you following? I ask that because part of the solution may be in identifying what worked before you got lost.
0
 

Accepted Solution

by:
Mushfique Khan earned 0 total points
ID: 41856029
thanks David ... much appreciated :)

I was able to fix it myself, but for the info: Oracle: 12.1.0.2 - RH 7.2 - 3 nodes RAC cluster

My cloning was done ok, but totally forgot how to enable cluster_database and add my other 2 nodes to it too.

Corrected myself ... after searching and looking around.

Thanks again.
0
 
LVL 23

Expert Comment

by:David
ID: 41856077
Nicely done. When I ask someone what they've already tried, oh say my teenager as an example, then "how to diagnose a problem" gets reinforced. And when that person goes back and discovers their oversight, as you did, you've got the satisfaction of success.

Please remember to award yourself the points and to close this ticket.

Regards,
dvz
1
 

Author Closing Comment

by:Mushfique Khan
ID: 41880255
figured it out myself  :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question