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

On 3 Jul 2005 20:16:10 -0700, "Edwinah63" <edwinah_at_customercare.com.au> wrote:

>unfortunately it is a hot back up. the database runs 24/7 and cannot
>be closed for a cold backup.
>
>when you say "re-create the service" (SID=myDB) could you explain
>further? i had imagined the following steps:
>
>1. reinstall oracle (after reformatting and ensuring hardware is all
>good)
>2. recreate database and tablespaces using GUI database configuration
>assistant - this would create a new set of (empty) datafiles THEN....
>
>3. copy control, init, and spfile files back to their original
>locations (overwriting new ones created)
>
>then are you saying here:
>
>4. copy datafiles, archive logs etc back to their original locations
>via OS commands then....
>
>5. reopen the database via OEM???? or via command line
>
>if above steps are incorrect could you please indicate the correct
>order. code or commands would help greatly.
>
>thanking you for your reply.

2 is unneccessary

1 is unnecessary assuming you still have Oracle (ie if you don't have everything on one drive). If you need to reinstall, don't create a database.
3 copy everything back to the original location 4 fire up a dos window
5 oradim -new -sid (etc....)
6 mount the database
7 recover the database (as this was a hot backup you are going to need this)
8 alter database open resetlogs

Note: the above should not be treated as a replacement for your reading of the backup and recovery documentation.

--
Sybrand Bakker, Senior Oracle DBA