OraFAQ Forum: RAC & Failsafe » clone one of rac nodes for development through RMAN

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

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 #407742 is a reply to message #407736]

Thu, 11 June 2009 06:35

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: clone one of rac nodes for development through RMAN [message #407905 is a reply to message #407742]

Fri, 12 June 2009 05:08

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

Report message to a moderator

Re: clone one of rac nodes for development through RMAN [message #407908 is a reply to message #407905]

Fri, 12 June 2009 05:19

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Re: clone one of rac nodes for development through RMAN [message #408054 is a reply to message #407908]

Sat, 13 June 2009 06:53

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

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!

Report message to a moderator

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

Report message to a moderator

Previous Topic:	ONS service Offline after Reboot
Next Topic:	oracle rac and jdbc

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 20:30:37 CDT 2025