"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...
- did a restore
- copy the missing datafiles to the new server
- startup
- of course, oracle will complain of which it will
- backup our control file and recreate it
- recover database using backup controlfile until cancel
- will prompt for which online log file
- alter database open resetlogs
- and it works....
Received on Sun Aug 24 2003 - 09:57:00 CDT
