restore a truncated table
hello
u have to create a control file trace, by using the following
sql> alter database backup controlfile to trace;
then open the trace file and modify as per ur needs and take it to the test server and paste it.
this will take care of ur logfiles
as for the temp as rbs u can delete them from the backup control file.
rest all the files u need to restore and also see to it the path for the datafile r alter after u come to the mount stage, i.e.
sql> startup mount
then u need alter the paths of the datafiles, as u have said that the mount points r different.
sql> alter database rename datafile as ;
then u have to recover database until time i.e the time b4 the batch job started , say if job started at 22:00 then u should recover till 21:55 or so.
sql> alter database recover until time '10-oct-2002 21:55:00';
i think this will solve ur prob.
if u have any probs or need clarification mail me at liyakat.parkar@mannai.com.qa
regards
liyakat parkar