Re: Oracle Backup and Restore when just have *.dbf files

"Edwinah63" <edwinah_at_customercare.com.au> wrote in message news:1120442412.673953.129820_at_g44g2000cwa.googlegroups.com...
> Hi experts,
>
> indulge me in this scenario:
>
> as part of our backup strategy we take a copy of our dbf files (data,
> undo, indx01 etc etc), together with the various *.ora files (init,
> spfile, listener etc etc), the *.ctl file and the archive logs.
>
> say i have a situation where my software instance of the Oracle
> database is ruined and i need to format my server, reinstall Oracle and
> recreate my database. recreating is easy enough,
>
> BUT....
>
> how do i make my old dbf files (and the data they contain) visible in
> the new database?
>
> what we have:
>
> * Oracle 9.2
> * Win 2000
>
> step by step instructions (or a link to step by step instructions) for
> this would be gratefully received.
>
> Edwinah63
>

if its a cold backup

restore them to the exact same places as they were before

re-create the service

start database

done Received on Sun Jul 03 2005 - 21:03:16 CDT