RE: RMAN Duplicate from lower patchset to higher patchsets

I know this is a hassle and a pain but if you're stuck with that:

1.  what would you do if the patch was no good and you needed to resort to 
previous version(i'm assuming you took 10.2.0.3 and patched in place to 
10.2.0.4)

2.  why not keep the 10.2.0.3 and add a 10.2.0.4 tree, realizing 2 oracle 
homes BUT it takes care of #1 above and doing the clone of production, 
startup the db in production version and do the upgrade to 10.2.0.4.

Or am I missing something here?

joe

_______________________________________
Joe Testa, Oracle Certified Professional 
Senior Consultant
Data Engineering and Administration
Nationwide Investments

(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.




From:
"Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
To:
<oracle-l@xxxxxxxxxxxxx>
Date:
04/23/2009 11:06 AM
Subject:
RE: RMAN Duplicate from lower patchset to higher patchsets
Sent by:
oracle-l-bounce@xxxxxxxxxxxxx



Anyone got any ideas ?
 
Regards,
Vishal Gupta
http://www.vishalgupta.com 

From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Vishal Gupta
Sent: Wed 22/04/2009 23:25
To: oracle-l@xxxxxxxxxxxxx
Subject: RMAN Duplicate from lower patchset to higher patchsets

Hi,
 
I am sure lot of people might have faced this problem. From what i have 
researched so far, RMAN does not support duplication (i am not talking 
restore here, but duplicate clone) between different version of oracle. 
 
So if you have a very critical system, then obvious thing to do would be 
upgrade dev, then test , then production. But let's throw another 
complication into the picture, if lot of your dev and test instances are 
refreshed from production RMAN backup on a daily basis. Then you can't 
really upgrade dev/test  first and leave production, until your testing is 
finished. RMAN does not allow duplicating a database from older version to 
newer version.
 
 
Though there is a procedure to restore database and then upgrade/downgrade
 
eg.
restore database;
recover database;
alter database open resetlogs upgrade/downgrade;
now follow the downgrade/upgrade steps;
 
 
As anyone found any way of duplicating database using RMAN from say 
10.2.0.3 to 10.2.0.4?
 
Regards,
Vishal Gupta

Other related posts: