Re: recovery aproach ...

gallasr_at_post.sk wrote:
> >
> > Again the answer is NO.
> > Datafiles and controlfiles have a database id. The database id of the
> > datafiles must match with the database id of the controlfiles.
> > Other than directly changing the database id directly by editing files
> > with a binary editor (thus loosing support), there is no magic
> > available
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
>
> and what about DBNEWID utility?
>
> Changing the new DBID to old DBID and after that change replacing the
> files? What about reco issues and SCN`s? There will be all goo
> datafiles with one system datafile which is newer ... ?

dbnewid assumes the files are consistent. Also: you can not specify the id.
So: you can not change the dbid of the old datafiles to the id of the new database.
You also can not change the id of the new database as you can not specify the id.
Look at it: a database is a *unity*, and it's integrity has to be guaranteed. If the jugglary you describe was possible, how to guarantee integrity? People will screw up their database and blame (or even sue) Oracle.

-- 
Sybrand Bakker
Senior Oracle DBA