close
Welcome! Wikis are websites that everyone can build together. It's easy!

Location: The Official Oracle Wiki

Discussion: RMAN Duplicate command

Keyword tags: ACBS content management DBA Certitification ibr idc middleware oracle oracle applications Oracle eAM site studio stellent ucm

Watch

Anonymous  (Get credit for your thread)
smitha.pamujula

smitha.pamujula		 RMAN Duplicate command
Mar 17 2008, 7:30 PM EDT
Hello All

I have used RMAN "Duplicate target database..." command a few times before and all the times I was duplicating to a different new DB_NAME than the target. This time i need to duplicate to the same DB_NAME as target. The target happens to be our Primary production database. The Target database is on a different host than the duplicate database. By specifying the same DB_NAME, would i be impacting the primary production database at all?

Thanks in advance 4  out of 12 found this valuable. Do you?    
nick_01

nick_01		 RE: RMAN Duplicate command
Apr 17 2008, 7:05 PM EDT
whether it is standby database.. or a standalone database with same name.. 1  out of 3 found this valuable. Do you?    
monowar94ru

monowar94ru		 RE: RMAN Duplicate command
Apr 22 2008, 2:02 AM EDT
Yes you can by using (set dbid <production dbid>). I did that few weeks ago. I used production dbid and scn to recover some point in time.

EX:
rman <<!
connect catalog user/pass@recman
connect target /
set dbid xxx; ##xxx is db_name dbid
run {
set command id to 'mms_dp_rman';
allocate channel c1 type 'sbt';
allocate channel c2 type 'sbt';
allocate channel c3 type 'sbt';
allocate channel c4 type 'sbt';
set until scn XXXX; ## xxxx --scn number
restore ..
recover ..

Thanks
Monowar 1  out of 3 found this valuable. Do you?    
monowar94ru

monowar94ru		 RE: RMAN Duplicate command
Apr 22 2008, 2:07 AM EDT
Added: if you do that on other server then the production then definitely it will not impact the primary production database.

Thanks
Monowar 2  out of 4 found this valuable. Do you?    
smitha.pamujula

smitha.pamujula		 RE: RMAN Duplicate command
Apr 22 2008, 2:06 PM EDT
Thanks Monowar, that helped. 0  out of 2 found this valuable. Do you?    
emocat
emocat		 RE: RMAN Duplicate command
Apr 22 2008, 4:37 PM EDT
Post this question in the official RMAN Discussion Forum: http://forums.oracle.com/forums/forum.jspa?forumID=74 2  out of 4 found this valuable. Do you?