Re: Database refresh problem
- From: nilesh kumar <nileshkum@xxxxxxxxx>
- To: "Mark W. Farnham" <mwf@xxxxxxxx>
- Date: Mon, 9 Nov 2009 08:47:36 -0800
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
>
Other related posts:
