Re: missing datafile

"Hieraklion" <hiera_klion_at_duchemol.fr> wrote in message news:<3f37b9d9$0$23398$79c14f64_at_nan-newsreader-02.noos.net>...
> "yls177" <yls177_at_hotmail.com> a écrit dans le message de news:
> c06e4d68.0308110457.32d750b6_at_posting.google.com...
> > we did a offline backup. backup was successful. however, in our
> > script, we forget to include a newly added datafile into the backups.
> > therefore, the successful backup is short of one missing data file. my
> > question is that is it possible to restored this offline backup in
> > another box considering that a datafile is not present.
>
> "Bonjour" from Paris,
>
> Well, the answer depends the achive mode your database is in.
>
> In noarchivemode, the best way i think is to use the offline drop command in
> order to delete the reference of this file in the controlfile when you
> willattemptto open the database.
>
> In archivemode, there is a special "touuchy" operation (see Note 29430.1)
> on Metalink. In this operation your can re-create the datafile during the
> backup phase.
>
> Good luck.
>
> "Au revoir" from pParis.
> Hieraklion
>
>
>
>
> Hieraklion
>
> Pour répondre, remplacer "duchemol" par "noos".
> To answer, replace "duchemol" by "noos".

this is what i did...

1. did a restore
2. copy the missing datafiles to the new server
3. startup
4. of course, oracle will complain of which it will
5. backup our control file and recreate it
6. recover database using backup controlfile until cancel
7. will prompt for which online log file
8. alter database open resetlogs
9. and it works....