| NEED Help ASAP - Have a database file. Can I use it on different server? [message #233614] |
Thu, 26 April 2007 22:44  |
ferrethouse
Messages: 43
Registered: August 2006
|
Member |
|
|
Our disk corrupted but we do have access to the database file. We installed Oracle on another computer and then copied over the database file. It didn't like it. We couldn't start the database. It is not a backup. It is the actual datafile. Is there anyway to use it?
This is urgent so any help would be MUCH appreciated.
|
|
|
|
| Re: NEED Help ASAP - Have a database file. Can I use it on different server? [message #233658 is a reply to message #233614] |
Fri, 27 April 2007 02:07  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
No, it wouldn't help just copying a single file. Some options:
1) Restore the DB to the new machine from backup. You do have backups, right?
2) Copy the entire DB (all files) to the new machine. If would be best to shutdown the DB before copying the files. If you cannot, apply archlogs until the DB is consistent again (only when running in archlog mode).
3) Use Oracle's Transportable Tablespace feature to copy the tablespace's files across.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
