RE: Database refresh problem

From: Vishal Gupta <>
Date: Mon, 9 Nov 2009 18:29:41 -0000
Message-ID: <>

If you are using RMAN duplicate command to clone from 10203 production database backup to 10204 test database. Then it will not work. This is because duplicate command at the end issues "alter database open resetlogs", which you can not issue on a 10203 database files with 10204 software binaries.  

What you need is install 10203 software on test system. DUPLICATE test database using 10203 binaries from production 10203 backup. Then upgrade it the usual way.  

Or, if you are not duplicating, then follow following steps.  

using 10204 binaries on test server
restore datababase; -- from 10203 production backup. recover database ; -- upto desired point in time open database in ugprade mode
run catupg.sql      

Vishal Gupta

From: on behalf of nilesh kumar Sent: Mon 09/11/2009 17:43
To: Bradd Piontek
Cc: Mark W. Farnham; ORACLE-L
Subject: Re: Database refresh problem

Yes, I restore the control files and datafiles from tape using RMAN and it is not the cold backup. Yes I am using RMAN for refreshing.

On Mon, Nov 9, 2009 at 8:53 AM, Bradd Piontek <> wrote:

	 This is pure speculation, but it looks like you are restoring / duplicating using RMAN. (maybe not). you may need to issue a 'recover database'. How did you 'restore the controlfile and datafiles'? 
	What is 'compatible' set to in the source database? 

	Bradd Piontek
	  "Next to doing a good job yourself, 
	        the greatest joy is in having someone 
	        else do a first-class job under your  
	 -- William Feather 

	On Mon, Nov 9, 2009 at 10:47 AM, nilesh kumar <> wrote:

		Hello Mark,
		I am on solaris box. I restored the control file, datafiles not the software ie binaries of 10g and logs also. I am trying to open the database in command prompt before to that i have also recovered the database. but when I issue the alter database open resetlogs it shows me every time as system file(.dbf) needs recovery. Checked the alert log also same message. 
		I got to know the production database was and test database was of Do I need to login to database home and then try recovering and then do the upgrade to afterwards ??

		On Mon, Nov 9, 2009 at 6:15 AM, Mark W. Farnham <> wrote:

			Tell us a little more. When you say "I have restored every thing from the production to Test" do you mean all the datafiles and such, or do you also mean the software?


			How are you trying to open the database? OEM, sqlplus, something else?


			What operating system are you on?


			And the big one: Exactly what problem are you having? Is there an error message? Does it just hang? Have you looked in the alert log or otherwise explored the log and trace files?


			That would be a good start to help us help you.







From: [] On Behalf Of nilesh kumar Sent: Monday, November 09, 2009 9:01 AM To: ORACLE-L Subject: Database refresh problem Hello DBA's, Good Morning!! Hoep everyone is doing a great job. I am stuck in middle of database refresh activity. I just got to know that the target Production database which I was refreshing was of version where as the earlier database on test machine was I have restored every thing from the production to Test. But I am facing the proble while I open the database. How should I solve this please help. Thanks Nilesh
Received on Mon Nov 09 2009 - 12:29:41 CST

Original text of this message