RMAN Duplicate from lower patchset to higher patchsets

From: Vishal Gupta <vishal_at_vishalgupta.com>
Date: Wed, 22 Apr 2009 23:25:49 +0100
Message-ID: <787DD2F284E39D4FA3C2ABD2DAF1AB2D014EEB_at_MAIL.vishalgupta.co.uk>


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  


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 to  

Vishal Gupta    

Received on Wed Apr 22 2009 - 17:25:49 CDT

Original text of this message