| Recovery using Import / Export [message #71443] |
Sun, 03 November 2002 21:52  |
JD Park
Messages: 1
Registered: November 2002
|
Junior Member |
|
|
HI all,
Can any one guide me on how to recover from Oracle db using import and export techniue.
Please provide any information or links
Thanks
Pakr
|
|
|
|
| Re: Recovery using Import / Export [message #71448 is a reply to message #71443] |
Mon, 04 November 2002 08:24  |
B
Messages: 327
Registered: August 1999
|
Senior Member |
|
|
scenarii ?
export/import is not a "point-to-crash" recover.
U can restore an image of Ur database.
If someone drop a user, a table etc...
U can always restore this user or this table ( at the time of Ur backup ). If u did a backup 3 weeks ago ... u've got an user "3 weeks old" ...
If U crash the entire database .. the best way is to recreate an empty database then import "FULL" database.
So understand that ur options are limited by the frequency of Ur backup
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
