Re: Are we screwed??

amerar_at_iwc.net wrote:
> Ok, problem here:

Right:

- No OS given
- No Oracle Version given
- No error messages in your whole post

How did you create the copy?
>
> I asked our jr. dba (mistake there) to change the SID and get the
> database up. Apparently after changing the init.ora and directory
> names, etc, he tried to open the database and got some control file
> consistancy error. So, he basically copied all 3 copies of the control
> file to make them the same.

This sounds like you copied all files while the prod db was open - not the best idea perhaps?
And what was the reason to change the SID in the first place? Don't blame the dba for trying to accomplish what you asked for
>
> The database would not mount because the file header did not match the
> SID in the control file, etc. Hence, he could not backup the control
> file to trace.
>
> So, he went to another test database, and took a trace of that
> controlfile and brought it over, changing the necessary lines to change
> the SID along with resetlogs.
>
> Now, the database wants to recover, however, we have no archive logs
> for this.

Is the production database in NOARCHIVELOG?

>
> I mean, this is totally screwed! We have database files from one
> database, and a trace control file from another, and cannot mount/open
> the database......
>
> What a mess!
>
> Any help on opening this sucker?
>

Start out fresh by rebuilding the database from a proper backup. The RMAN Users Guide contains some valuable information on how to duplicate a database.

And the exact procedure will differ depending on your OS *and* Oracle Version which you deliberately didn't mention.

Regards,
Holger Received on Fri Jan 13 2006 - 10:02:19 CST