• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Oracle - Deleted PRODB733 Tables

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: gopal.kistasami@smiths.co.za
 

Larry_Jones

Legendary Poster
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
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15
 
Top