Re: Restore Table

That's ok if : : -

1. You have a spare system/disk space.
2. Are happy that no integrity constraints will not be violate or triggers., i.e. you will be exporting the missing table and putting back into the production system, which may have transactions running.
3. You do not have to recover you system database file.

Paul.

In article <P3l%7.14826$Wx3.2912421998_at_hebe.telenet-ops.be>, "koert54" <koert54_at_nospam.com> wrote:

> a better way to do it :
> - leave the production DB running
> - get system, temp, rollback and the tablespace, which includes the
> table, from backup and restore on a different localtion - recreate the
> the control file - rename the DB and lose all datafiles that aren't part
> of the tablespace mentioned above - offline drop the missing datafiles
> - recover database until time using backup controlfile ; - alter
> database open resetlogs ;
> - export the table from the recovered DB - import the table in the
> production system
>
> this way your production system does not need to go down !
>
>
> "Steve James" <stevejames73_at_hotmail.com> wrote in message
> news:lrj%7.9700$X87.1540288_at_news2-win.server.ntlworld.com...
>> Hi,
>>
>> A little problem I am having on a test system.
>>
>> I am running the system in archive log mode.
>>
>> I make a hot backup of all the data files at 1:00pm. After backing up
>> all the data files I issue an alter system switch
> logfile.
>>
>> At 4pm, I drop a table which I didn't want to do, so I want to do a
> recover
>> until time to five mins before I dropped the table.
>>
>> Is the correct process for this as follows?:
>>
>> Shutdown the database
>> replace the backup data file which would of contained the dropped
>> table. (the backup I took at 1pm).
>> startup mount
>> recover database until time '2001-01-10:15:55:00'
>>
>> I am getting a series of error messages regarding the system tablespace
>> needing more recovery but this doesn't make much sense. I have been
>> over
> the
>> Oracle documentation , which seems to go along with the process I have
>> written above.
>>
>> Can anyone verify whether what I am doing is correct?
>>
>>
>> Thanks
>>
>> Steve
>>
>>
>>
>>
>>
>>
>
>
>
Received on Thu Jan 10 2002 - 13:20:20 CST