1. Manual (Using RMAN)
2. Enterprise Manager
3. DBCA
4. RCONFIG (from 10gR2)
Duplicating RAC database is very simple, first duplicate RAC Database to a single instance using RMAN and convert the single instance into a RAC cluster. Please note that straight RAC to RAC duplicate is not possible.
Follow the simple steps to duplicate RAC Database using ASM or other filesystem.

Step1: Create a parameter file for duplicate database(auxiliary)
The easy ways is copy Init.ora parameter from Target database, replace the Target database name with Auxiliary database name and comment all RAC related parameters for ex:- cluster_database, cluster_instances, thread ...Etc
Set CONTROL_FILES to two copies of the control file to +DISKGRP or file system
Step 2: Set DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT to convert the datafile and redo log file names from +DISKGRP1 to +DISKGRP2 or /dbs1 to /dbs2 (For Non-ASM file systems)
Also Set DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_DEST_n to ‘+DISKGRP2’ or /dbs2
Step 3: set _no_recovery_through_resetlogs=TRUE parameter to avoid internal Bug 4355382 ORA-38856: FAILED TO OPEN DATABASE WITH RESETLOGS WHEN USING RAC BACKUP
Step 4: Create a password file for auxiliary database using below command.
$ orapwd file=orapwdupDB password=xxxxxxxx
Step 5: Create a static listener for auxiliary database and reload, because auxiliary database will not register itself with the listener.
(SID_DESC =
(GLOBAL_DBNAME =dupDB.oracleracexpert.com)
(ORACLE_HOME = /oracle/product/db/10202)
(SID_NAME = dupDB)
)
Step 6: Take Full database backup of Target database
RMAN > backup database plus archivelog;
Copy the backup dumps from Target to Auxiliary host. If backup directory structure is different then update the RMAN configuration of the target database to reflect the new backup location
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/rman/dupDB';
Step7: Set ORACLE_SID and start auxiliary database in NO MOUNT state
$ export ORACLE_SID=dupDB
SQL> startup nomount
Step 8: Duplicate Target Database using RMAN Duplicate command
RMAN> CONNECT TARGET /;
RMAN> CONNECT CATALOG rman/*****@catadb;
RMAN> CONNECT AUXILIARY sys/*****@dupDB;
RMAN> DUPLICATE TARGET DATABASE TO dupDB;
Step 9: Add second thread of online redo logs and enable that thread:
SQL> alter database add logfile thread 2
group 3 ('+DISKGRP1','+DISKGRP2') size 50m reuse;
SQL> alter database add logfile thread 2
group 4 ('+DISKGRP1','+DISKGRP2') size 50m reuse;
SQL> alter database enable public thread 2;
For Non-ASM file systems replace ‘+DISKGRP1’, ‘+DISKGRP2' with actual file systems path
Step 10: Uncomment or add all RAC related parameters, shutdown the instance and startup both Instances.
Step 11: create spfile on the shared storage, because all instances must use the same server parameter file. See the link to “Create spfile from pfile”.
Step12: Register RAC instances with CRS
$ srvctl add database -d dupDB -o /oracle/product/db/10202
$ srvctl add instance -d dupDB -i dupDB1 -n testrac01
$ srvctl add instance -d dupDB -i dupDB2 -n testrac02
Step13: Shutdown and startup instances using srvctl
$ srvctl start database –d dupDB
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/
Nice documentation for the clone in RAc. make the life easy. Thanks Gagan
ReplyDeleteGreat Article android based projects
DeleteJava Training in Chennai
Project Center in Chennai
Java Training in Chennai
projects for cse
The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
great post
ReplyDeleteregards
Alex
CONNECT AUXILIARY sys/*****@dupDB; Fails if the database is in nomount as the listener status is shown as "Blocked"
ReplyDelete.
When the database is in nomount stage, the listener shows status "BLOCKED" and disables all the connections with @ORACLE_SID
this is another way of doing the connections:
ReplyDelete.
[oracle@host dbs]$ rman target sys/*******@PROD auxiliary /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 4 13:33:16 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: PROD (DBID=1850275178)
connected to auxiliary database: dupDB (not mounted)
RMAN>
The auxiliary instance does not yet have a control file, you can only start the instance in NOMOUNT mode. Do not create a control file or try to mount or open the auxiliary instance.
ReplyDeletePlease note that we have created a static listener for auxiliary database, because it will not register itself with the listener.
Follow the steps and you will not see any issue.
Great post, thanks
ReplyDeleteRaju
Thank you so much for your precious information.
ReplyDeletewww.rmanbackup.com
Dear satishbabu,
ReplyDeleteI am Khalid,I am new for RAC, Really your post are lot help full. plz keep it up.
Your making DBA easy for new DBAs. Thank you very much for your valuable post.
Satish plz could you suggest me how can I come good In RAC.
Thanks:
Syed Khalid Ali
email: khalid_dba@yahoo.com
Understanding the architecture is very important in RAC. I would advice to read Oracle doc first before going to any books. Also make sure you create a test environment and do practice, just reading the books/documentation is not enough.
ReplyDeleteThis is an Excellent blog and i did the same duplicating database on stand alone for 11gr2 :
ReplyDeletehttp://chandu208.blogspot.com/2011/12/11g-rman-cloning-using-duplicate.html
thank, it's very useful
ReplyDeleteKhanhND
if i dont have recovery catalog ; will these steps work ?
ReplyDeleteyes, these steps works with out recovery catalog.
ReplyDeleteRegards
http://www.oracleracexpert.com
This particular weblog is seriously interesting, keep blogging good info.
ReplyDeletegagan enterprises
Hi, I was simply checking out this blog and I really admire the premise of the articlegagan enterprises
ReplyDeleteIts nice to hear that my website is helpful to you.
DeleteRegards
Satishbabu Gunukula
http://www.oracleracexpert.com
I would like more information about this, because it is very nice. Thanks for sharing!
ReplyDeletehappy wheels | friv | girlsgogames | games2girls | happy wheels
baixar facebook é um rede social maior no tudo mundo. O desenvolvimento de Facebook no celular é realizado e desenvolvido pelo Mark Zuckerberg. Foi conhecido como um aplicativo gratuito de mensagens mais famoso e popular no mundo, baixar whatsapp é um metodo perfeito para segurá-los contatos com os seus amigos que não tem de pagar mais nenhuma taxa.
ReplyDeleteSign in to skype on your device. Sign in to skype on the web. Set up skype and install skype...
ReplyDeleteGreat! Many thanks!
ReplyDeleteDescargar Facebook Gratis| Entrar no Hotmail Drag Racer V3| baixar whatsapp | descargar whatsapp| happywheels | Stick RPG 2 | Mutilate A Doll 2 | Sushi Cat 2 |
This is a very good article material and it is very useful for us all. thank you . cara menggugurkan kandungan
ReplyDeleteشركة نقل اثاث بالرياض
ReplyDeleteشركة نقل اثاث بالدمام
شركة نقل عفش | شركة نقل اثاث بجدة | شركة نقل عفش بالرياض | شركة نقل عفش بالمدينة المنورة | شركة نقل عفش بالدمام
Most kids like to play games online at school.Thousand of students had access to computers at school and want to play single or 2 player unblocked games.
ReplyDeleteThis website has more than twenty categories to discover.Ofcourse you can play offline a lot of quality video mario games.
I prefer online as these are free and most of them can be played in full screen.
Many businesses and schools had restricted access to malicious or otherwise inappropriate websites on their networks. Anyway, a variety of proxy sites offer access to hard websites like flash or unity games.
Many of these sites advertise specifically to children as a free and fun way to play kizi games at school.
Although these games are normally blocked on the network by the operating system, the proxy server acts as an intermediary in that, to the network, it appears that the user is simply browsing the proxy site when he or she is actually playing games or are surfing on i8napropiate websites for adults or other.
So using our proxy server you are able to play at work or at school and nobody know.
No matter what you play puzzle, action, dressup,skill or solitaire card you can load all at any time.
The website offer the oportunity to discover new or popular many flash, unity or html5 math games.If you like bookworm popcap game you can play it here on pc, tablet or ipad.
To play it on smartphone you will be redirected to the mobile version where you play also unic games in single or 2 player and in full screen.
Still there are available brain games who will help your brain to stay young and healthy keeping you away of disease.
Most played are 2 player where you can chose to play it even in single player vs computer.
No need to remember the mobile version adress ,just remember only the top domain and based on your device dimensions you will be redirected by browser.
More links:Math playground games Pogo games
happy wheels is a ragdoll physics-based platform browser game developed and published by Fancy Force. Created by video game designer Jim Bonacci in 2010, the game features several player characters, who use different, sometimes atypical, vehicles to traverse the game's many levels. The happy wheels game is best known for its graphic and the amount of user-generated content its players produce on a regular basis, with game maps shared on a public server.I used to play Happy Wheels 2 game online Happy Weels
ReplyDeletesome demo versions include Happy wheels demo & happy wheels game
Play Free Games Play fireboy and watergirl Fireboy & Watergirl unblocked
thanks, loving the post. amazing. Best 72nd Independence Day 2018 Slogans And Quotes in Malayalam
ReplyDeleteYou are doing a great job. Now we are sharing with you all the Tresurebox store products which you will be buy online in a single click. Garden shed nz online in a single click,
ReplyDeleteNice Information Your first-class knowledge of this great job can become a suitable foundation for these people. I did some research on the subject and found that almost everyone will agree with your blog.
ReplyDeleteCyber Security Course in Bangalore
Writing in style and getting good compliments on the article is hard enough, to be honest, but you did it so calmly and with such a great feeling and got the job done. This item is owned with style and I give it a nice compliment. Better!
ReplyDeleteCyber Security Training in Bangalore
Đặt vé máy bay tại đại lý Aivivu, tham khảo
ReplyDeleteve may bay di my gia re
vé máy bay từ mỹ về việt nam bao nhiêu
vé hà nội nha trang
giá vé máy bay vietjet hải phòng phú quốc
ve may bay di Hue bao nhieu tien
Смотрите каждый день Русское порно онлайн бесплатно а также Порно азиатки и Русское порно онлайн
ReplyDeleteТолько лучшее Любительское порно видео онлайн
ReplyDeleteI am impressed by the information that you have on this blog. It shows how well you understand this subject.
ReplyDeletedigital marketing courses in hyderabad with placement
Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing. data scientist course in delhi
ReplyDeleteافضل شركات منطقة مكة المكرمة ومنطقة المدينة المنورة التي تعمل في مجال نقل العفش مع الفك والتركيب والنقل والتغليف تلك الشركات التي تستخدم سيارات مجهزة ومبطنة من الداخل لكي يتم نقل العفش في امان تام بدون خدوش او تكسير مثل الشركات التالية
ReplyDeleteنقل عفش بجده
شركه نقل عفش بمكه
شركه نقل عفش بالطائف
وفي منطقة المدينة المنورة تجدنا نمتلك افضل شركات نقل الاثاث مع الفك والتركيب وكذلك في ينبع وينبع البحر مثال عن تلك الشركات
شركه نقل عفش بالمدينه المنوره
شركه نقل اثاث بينبع
من افضل شركات منطقة مكة المكرمة التي تعمل في مجال تنظيف وتعقيم المنازل تلك الشركة الجيدة التي تقدم خدمات جيدة في تنظيف المنازل من الداخل ومن الخارج في ارخص شركة تنظيف بجدة تختص بأعمال التنظيف للمنازل الجديدة والمفروشة في مدينة جدة وقد تقوم تلك الشركات في جدة ايضا بتقديم خدمات غسيل المفروشات والكنب والسجاد تحت اسم افضل شركة غسيل موكيت بجدة تلك الشركات بتقديم تلك الخدمات بأسعار جيدة وخدمات مقبولة
ReplyDeleteوالتي تقوم بها افضل شركه تنظيف شقق بجده لها خبرة طويلة بالمجال
وقد عملت افضل شركة تنظيف منازل بجدة علي تقديم خدمات التنظيف داخل المنازل والفلل بمنتهى الاحترافية والدقة
في العاصمة المقدسة التي هي مكة المكرمة توجد لدينا امكانيات كبيرة في مجال تنظيف المنازل والشقق والفلل كما في شركة تنظيف بمكة المكرمة فلو تريد تنظيف بيتك او منزلك وانت في مكة تواصل معنا في حالة ان كان المنزل جديد
اما في حال ان كان المنزل مفروش واصاب الفرش من الأوساخ والأتربة مثل الكنب والمجالس والسجاد وتريد التنظيف بالبخار تواصل مع شركة تنظيف موكيت بمكة المكرمة وهي شركة متميزة في أعمال الغسيل والتنظيف بالبخار في نفس الموقع
a fantastic read <a hre
ReplyDeleted8v78u1t17 s5c38h5y47 h1a32s2i24 a4z61s5t87 y3t05y4o38 e2q86a3p98
ReplyDelete