Home » RDBMS Server » Server Administration » Restore Droped Table
Restore Droped Table [message #55519] Tue, 28 January 2003 19:44 Go to next message
Supar
Messages: 9
Registered: January 2003
Junior Member
Can any one explain me how to restore dropped table from physical fullbackup database, without restore all backup ? thank's

Report message to a moderator

Re: Restore Droped Table [message #55527 is a reply to message #55519] Wed, 29 January 2003 02:03 Go to previous messageGo to next message
psmyth
Messages: 81
Registered: October 2002
Member
if you mean you have an online backup or cold backup of the database (file copies of all the datafiles), then there is no way to restore just one table - it's all or nothing. You can recover the backup on another server or as a different instance name on the same server temporarily, and then you can export/import to get your table back.

Often worthwhile doing daily exports as well as backups for this reason.

Report message to a moderator

Re: Restore Droped Table [message #55541 is a reply to message #55519] Wed, 29 January 2003 21:00 Go to previous messageGo to next message
Manish Deshmukh
Messages: 16
Registered: January 2003
Junior Member
Please specify if u have an export backup or a cold
backup.If u have export backup then u can restore particular table from that.But if u have only the cold backup then u cannot restore an particular table from that.In this case u have to remove all the datafiles
from the server phsically by issuing ur OS commands and
then copy the datafiles from the backup media again.To
avoid this kind of situation u should have an export
backup of the entire database daily,so that restoration of an particular table and its objects is easy and can be done with less down time.
Regards
Manish Deshmukh

Report message to a moderator

Re: Restore Droped Table [message #55576 is a reply to message #55519] Fri, 31 January 2003 22:13 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
If you have at least the db export file, then you can restore individual table. Otherwise, I don't see w/o any backup from where the deleted data will come???

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Flat File v. Oracle
Next Topic: oracle privilege
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 00:31:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.