Home » Server Options » RAC & Failsafe » clone one of rac nodes for development through RMAN (Oracle 10g Enterprise Edition Release 10.2.0.1.0, Oracle Enterprise Linux 4)  () 2 Votes
clone one of rac nodes for development through RMAN [message #407736] Thu, 11 June 2009 06:14 Go to next message
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 #407742 is a reply to message #407736] Thu, 11 June 2009 06:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
If I understand you correctly, you are trying to
clone a RAC datababase on ASM to a single instance database.
Right?
Use RMAN.
http://www.orafaq.com/forum/t/145769/42800/

Edit the init.ora of auxillary and do appropriate changes.
Re: clone one of rac nodes for development through RMAN [message #407905 is a reply to message #407742] Fri, 12 June 2009 05:08 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

I have Taken appropriate RMAN backup of the production RAC database
RMAN> run{
2> allocate channel c1 type disk format '/oracle/backup/%U';
3> backup database;
4> backup archivelog all;
5> }
now i have copy all rman backup on development database.
startup the development database with rac database pfile with removeing some rac parameter.
now start rman at development database
rman target / nocatalog
estore controlfile from '/u01/oracle/oradata/c-610677177-20070212-00';
Finished restore.
RMAN> alter database mount;
rman>run {
set until sequence 278 thread 1;
set newname for datafile 1 to '/u01/app/oracle/oradata/orcl/system01.dbf';
set newname for datafile 2 to '/u01/app/oracle/oradata/orcl/undotbs01.dbf';
set newname for datafile 3 to '/u01/app/oracle/oradata/orcl/sysaux01.dbf';
set newname for datafile 4 to '/u01/app/oracle/oradata/orcl/users01.dbf';
set newname for datafile 6 to '/u01/app/oracle/oradata/orcl/bms01.dbf';
set newname for datafile 7 to '/u01/app/oracle/oradata/orcl/newton01.dbf';
restore database;
switch datafile all;
recover database;
}
using target database control file instead of recovery catalog

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 12-JUN-09
Starting implicit crosscheck backup at 12-JUN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=155 devtype=DISK
Crosschecked 2 objects
Finished implicit crosscheck backup at 12-JUN-09

Starting implicit crosscheck copy at 12-JUN-09
using channel ORA_DISK_1
using channel ORA_DISK_2
Finished implicit crosscheck copy at 12-JUN-09

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1
using channel ORA_DISK_2

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/orcl/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/orcl/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/orcl/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbf
restoring datafile 00005 to +ORCL_DATA1/orcl/datafile/undotbs2.264.688648515
restoring datafile 00006 to /u01/app/oracle/oradata/orcl/bms01.dbf
restoring datafile 00007 to /u01/app/oracle/oradata/orcl/newton01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/auxl_backup/1tkhd2p2_1_1
ORA-19870: error reading backup piece /home/oracle/auxl_backup/1tkhd2p2_1_1
ORA-19504: failed to create file "+ORCL_DATA1"
ORA-17502: ksfdcre:4 Failed to create file +ORCL_DATA1
ORA-15001: diskgroup "ORCL_DATA1" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
ORA-29701: unable to connect to Cluster Manager
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/12/2009 14:02:51
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

please suggest me what should i do because in development database i don't have ASM.
with regds
rajnish
Re: clone one of rac nodes for development through RMAN [message #407908 is a reply to message #407905] Fri, 12 June 2009 05:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>restoring datafile 00005 to +ORCL_DATA1/orcl/datafile/undotbs2.264.688648515
Entry for undotbs is missing in your set newname.
Re: clone one of rac nodes for development through RMAN [message #408054 is a reply to message #407908] Sat, 13 June 2009 06:53 Go to previous messageGo to next message
kumarrajnishgupta
Messages: 43
Registered: October 2008
Location: noida
Member

Now it's successfully restored at my non ASM system.
During operation i found error "ORA-00600" when i restart databse in openreset log mode. basically there is a bug, which you have to patched and again restart the database in open resetlog mode. now logs file has been created and works fine.
Doc ID: 742289.1
bug 7207932
with regds
rajnish
Re: clone one of rac nodes for development through RMAN [message #408583 is a reply to message #407736] Wed, 17 June 2009 00:13 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: ONS service Offline after Reboot
Next Topic: oracle rac and jdbc
Goto Forum:
  


Current Time: Thu Mar 28 11:18:16 CDT 2024