RE: Recover Tablespace?

Alter the datafiles associated offline immediate Restore the datafiles from backup...if one exists....if it doesn't exist, recreate the datafile=20

(do an alter database backup controlfile to trace to get the datafile location recreate the datafile)

SQL> ALTER DATABASE CREATE DATAFILE =20
      2> '/ORADATA/u03/users01.dbf';

THEN=20 Recover either tablespace or datafiles using archive logs And current online redo if necessary

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bryan Wells Sent: Tuesday, April 12, 2005 4:58 PM
To: Oracle-L
Subject: Recover Tablespace?

we are playing with Tivoli trying to recover a tablespace from a snapshot=20
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 for=20
this experiment, back to the state at the time of the snapshot. im trying to=20
find docs on how to recover the tablespace. does this become a point in time=20
recovery, where the point in time is the snapshot? or is it an entire=20 database recovery resetting the logs?
 Oracle 9iR2 on W2K AdvSvr
=20
--=20

Bryan S Wells - DBA Newbie
bunjibry_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 12 2005 - 22:37:25 CDT