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@xxxxxxxx> 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@xxxxxxxxxxxxx [mailto: > oracle-l-bounce@xxxxxxxxxxxxx] *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 >