Oracle - Deleted PRODB733 Tables

  • Thread starter Gopal_Kistasami
  • Start date

Gopal_Kistasami

Active Member
I have accidently dropped all the tables from PRODB733. Nightly backup is performed using Unix OS ufsdump of the U02 filesystem. The solution I have is to backup current filesystem, restore last night, export tables, restore current and import tables( Orcale 8.1.6 ). This I estimated will take 22 hrs.

As anyone got a solution by just restoring the affected tablespace(PRODB733T and PRODB733I - /u02/orcl/datafiles/prodb733t01.dbf and prodb733i.dbf files from last night backup) and configuring these OS files into Oracle.

Your input will be much appreciated.

Many thanks in advance for your support.

Regards,

Gopal
OW B7331 SP7, Sun Unix 2.7, Oracle 8.1.6.3.0


Gopal Kistasami
ICL (SA) PTY LTD
P O Box 1379
Wandsbeck
3631

Phone: 031-7194141
Cell Phone: 0829032747
E'mail: [email protected]
 
are your log files archived (is your database in archivelog mode)?

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
The quickest way to navigate through this mess is to call Oracle support - they can quickly help you to determine the best way to recover.

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
Back
Top