Help - Search - Members - Calendar
Full Version: RMAN Backups to create new instance
Oracle DBA Forums > Oracle > Oracle Forum
dba_zk_08
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
dave
no
burleson
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)?
dba_zk_08
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.



QUOTE (burleson @ Jul 27 2008, 03:28 PM) *
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)?
burleson
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
dba_zk_08
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
SteveC
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.
dba_zk_08
QUOTE (SteveC @ Jul 28 2008, 03:45 PM) *
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!
SteveC
See http://download.oracle.com/docs/cd/B10501_...grad.htm#248202 for more details.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.