Re: Database refresh problem

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Mon, 9 Nov 2009 10:53:16 -0600
Message-ID: <e9569ef30911090853k4721e584o7bda2281d165bafa_at_mail.gmail.com>

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 - 10:53:16 CST