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]
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]