Re: Restore Table

Steve,

I would suggest you if you are doing an incomplete database recovery in this way you need to restore all your datafiles and make sure you open the database with alter database open resetlogs.

p.s. you will need your archive logs and also remember to backup your database cold when you have it working.

Paul.

In article <lrj%7.9700$X87.1540288_at_news2-win.server.ntlworld.com>, "Steve James" <stevejames73_at_hotmail.com> wrote:

> 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 - 10:56:48 CST