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

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. Received on Sun Jul 03 2005 - 22:16:10 CDT