Hi,

Is it possible to create a new instance using RMAN Backups of an existing instance as follows:

Existing Instance's Oracle Release: 9.2.0.8
New Instance's Oracle Release: 9.0.1.1

The other option available is using export/import. But can RMAN help me achieve the same.

Also, please could you provide some realtime tips based on your experiences for Patch Upgrade & Rollback.

I have gone through the Oracle Documentation & Metalink notes, but just incase.

Thanks and Regards,
Zaffer Khan

no

Hi Zaffer,

>> But can RMAN help me achieve the same.

Never trird it, but I would guess no, because the data dictionary cataloag was updated between these releases.

It sounds like you want to clone the instance, why a different release?

Have you considered a fast clone instead?

http://www.dba-oracle.com/oracle_tips_db_copy.htm

*******************************************************
>> Patch Upgrade & Rollback

Huh? Do you mean CPU (Critical Patch Update)?

Thanks a lot for the clarification, Mr. Burleson.

Thanks a lot for re-directing me to the cloning tips.

One more query based ont the tip!

This cloning script is meant for the same Oracle Release (i.e. 9.2.0.8 to 9.2.0.8), right?


>>>>Huh? Do you mean CPU (Critical Patch Update)?
Yes CPUs!




Note: Thanks a lot for the last tip you gave me regarding SGA sizing strategy. It went in really well on the production.

Hi Zaffer,

>> Thanks a lot for the last tip you gave me regarding SGA sizing strategy

Thanks, we work hard on our tips. Tell your friends.

*******************************************************************

>> This cloning script is meant for the same Oracle Release (i.e. 9.2.0.8 to 9.2.0.8), right?

Yes, but it should work on almost any release.

*******************************************************************

>> some realtime tips based on your experiences for Patch Upgrade & Rollback.

Sure. Start here, from the book "Oracle Forensics":

http://www.dba-oracle.com/forensics/t_fore...ch_activity.htm

http://www.dba-oracle.com/forensics/t_forensics_output.htm

These links were quite helpful. Now I need to get hands on to the book "Oracle Forensics". Thanks once again for the references.


>>>> Yes, but it should work on almost any release.
That's precisely my point, 9.2.0.8 to higher is acceptable. But, can cloning be used for the lower releases (9i Release 1)?

Regards,
Zaffer Khan

If you want/need to downgrade from one version to another, you're pretty much stuck with export/import in 9i. Clone is just as the name implies - a replica of the original. A clone is not having 9.2 turned into 9.0. The "DNA" is different.

Thanks Steve for the clarification!

See http://download.oracle.com/docs/cd/B10501_...grad.htm#248202 for more details.