RE: RMAN Duplicate from lower patchset to higher patchsets
Date: Fri, 24 Apr 2009 14:06:33 +0100
Message-ID: <OF9BA6D6F2.32C8A4AB-ON802575A2.0047C222-802575A2.00480364_at_ons.gsi.gov.uk>
I've not tried this with RMAN but last week I had occassion to hot clone (alter database begin backup; copy files; alter database end backup; switch logfiles; copy logfiles etc.) a 10.2.0.3 database into a 10.2.0.4 home and it worked OK - Just remember to run catupgrd once you have restored the database.
Cheers,
Ian
|---------+----------------------------->
| | vishal_at_vishalgupta|
| | .com |
| | Sent by: |
| | oracle-l-bounce_at_fr|
| | eelists.org |
| | |
| | |
| | 23/04/2009 16:03 |
| | Please respond to |
| | vishal |
| | |
|---------+-----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: oracle-l_at_freelists.org | | cc: | | Subject: RE: RMAN Duplicate from lower patchset to higher patchsets | >--------------------------------------------------------------------------------------------------------------|
Anyone got any ideas ?
Regards,
Vishal Gupta
http://www.vishalgupta.com
From: oracle-l-bounce_at_freelists.org on behalf of Vishal Gupta
Sent: Wed 22/04/2009 23:25
To: oracle-l_at_freelists.org
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
This email was received from the INTERNET and scanned by the Government Secure Intranet anti-virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In case of problems, please call your organisation’s IT Helpdesk. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.(See attached file: attf2qrz.dat)
For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk
Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 24 2009 - 08:06:33 CDT
- application/octet-stream attachment: attf2qrz.dat