Re: Are we screwed??

"amerar_at_iwc.net" <amerar_at_iwc.net> wrote in news:1137166762.790438.74390_at_o13g2000cwo.googlegroups.com:

> Ok, problem here:
>
> We copied one of our databases onto the test server.......
>
> 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.
>
> 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.
>
> 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?
>
>

READY, FIRE, AIM!
You might want to consider starting over; or not.

> Hence, he could not backup the control file to trace.

Why don't you do that on the original instance, & then use the trace file to create new control files on target? Received on Fri Jan 13 2006 - 09:50:45 CST