RE: Database refresh problem

From: Vishal Gupta <vishal_at_vishalgupta.com>
Date: Mon, 9 Nov 2009 18:29:41 -0000
Message-ID: <787DD2F284E39D4FA3C2ABD2DAF1AB2DA1CC_at_MAIL.vishalgupta.co.uk>

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      

Regards,
Vishal Gupta
http://www.vishalgupta.com

---

From: oracle-l-bounce_at_freelists.org 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 <piontekdd_at_gmail.com> wrote:

	Nilesh, 
	 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  
	        direction."
	 -- William Feather 



	On Mon, Nov 9, 2009 at 10:47 AM, nilesh kumar <nileshkum_at_gmail.com> 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 10.2.0.3 and test database was of 10.2.0.4. Do I need to login to 10.2.0.3 database home and then try recovering and then do the upgrade to 10.2.0.4 afterwards ??
		
		Thanks
		Nilesh 


		On Mon, Nov 9, 2009 at 6:15 AM, Mark W. Farnham <mwf_at_rsiz.com> 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.

			 

			Regards,

			 

			mwf

			 

			


________________________________



			From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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 10.2.0.3 where as the earlier database on test machine was 10.2.0.4. 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

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 09 2009 - 12:29:41 CST