Re: Recover Tablespace?

On 4/12/05, Bryan Wells <bunjibry@xxxxxxxxx> wrote:
> we are playing with Tivoli trying to recover a tablespace from a snapshot
> that was backedup earlier. because i am continually in learning mode, im
> trying to find a way to recover a particular tablespace, one i created fo=
r
> this experiment, back to the state at the time of the snapshot. im trying=
 to
> find docs on how to recover the tablespace. does this become a point in t=
ime
> recovery, where the point in time is the snapshot? or is it an entire
> database recovery resetting the logs?
>  Oracle 9iR2 on W2K AdvSvr
>=20
> --
> Bryan S Wells - DBA Newbie
> bunjibry@xxxxxxxxx
>=20
> --
> http://www.freelists.org/webpage/oracle-l
>=20

Hi Brian,

You cannot perform a point-in-time recovery of a tablespace by issuing
simple "restore" and "recover" commands over this tablespace. You'll
need an auxiliary database for that.
Have a look at "Performing user-managed TSPITR" or "Performing RMAN
TSPITR" in the documentation.

Regards,
Jerome
--
http://www.freelists.org/webpage/oracle-l

Other related posts: