clone one of rac nodes for development through RMAN [message #407736] |
Thu, 11 June 2009 06:14 |
kumarrajnishgupta
Messages: 43 Registered: October 2008 Location: noida
|
Member |
|
|
Dear all,
I have to clone one of my rac nodes for my development people. i am explainng my scenario
1. 192.168.1.37 is my rman catalog database
2. 192.168.1.100 is my one of rac nodes named node1
3. 192.168.1.195 is my auxiliary database meas this is the system which i have to going to give my development people. obvisiouly directory structue will have to change bcz i am not using ASM in development database
I am using ASM for for datafile,online logfile, controlfile and spfile.
but my development database does not contains asm or any shared storage storage even i dont's want to keep that.
please tell me steps how to do that
with regds
rajnish
[Updated on: Thu, 11 June 2009 06:16] Report message to a moderator
|
|
|
|
|
|
|
Re: clone one of rac nodes for development through RMAN [message #408583 is a reply to message #407736] |
Wed, 17 June 2009 00:13 |
trantuananh24hg
Messages: 744 Registered: January 2007 Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
Mash!
May you correct me if I am wrong?
If kumarrajnishgupta copy all of backup files (backupset) into the new_host, and he did not use catalog, in this case, he used control_file, then, he did not use command catalog in his rman's script. Why did he complete those task? I really do not understand.
Steps:
1. Use command "Backup full (or incremental level 0)" in target DB, including archive_logfile,control_file,spfile.
2. Use RMAN to complete these tasks in destination DB:
2.1: Restore controlfiles
2.2: NoMount DB
2.3: Restore spfile
2.4: Mount DB
2.5: Catalog backup files with new path in destination DB
2.6: Set newname for datafiles
2.7: Rename REDO log files
2.8: Restore Database
2.9: Switch all datafiles
2.10: Recover database
2.11: Open DB resetlogs.
Thank you!
|
|
|
Re: clone one of rac nodes for development through RMAN [message #408610 is a reply to message #408583] |
Wed, 17 June 2009 01:22 |
kumarrajnishgupta
Messages: 43 Registered: October 2008 Location: noida
|
Member |
|
|
Dear Tran
When you restore RAC Database controlfile at Development Database ( or clone Database ) like this
RMAN>restore controlfile from '/u01/oracle/oradata/c-610677177-20070212-00';
then it stores all info whatever in control file at RAC Database even RMAN backup Path.
and when you run "show all" at Development Database it shows like same as Rac Database "show all"
RMAN>show all
|
|
|