I am assuming that you are using Oracle 8.1 or above. In that case this is
the ideal situation for Tablespace point in time Recovery (TSPITR). This is
where you recover a tablespace to point in time different than the rest of
the database.The backup and recovery manual covers in great depth about
this procedure.
HTH
Murali
"Paul Fagan" <paulfagan_at_hotmail.com> wrote in message
news:20020110.192014.1939964443.1905_at_hotmail.com...
> 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 Fri Jan 11 2002 - 07:28:38 CST
