Recovering Oracle to Point in Time

[CassidyHunt]

I have all my archive logs and would like to create a new database rolled back to a point in time. Is this possible? If so do you have any advice or sites showing how to do that?

Thanks

Cassidy

 

[Turkbear]

Hi,
Try these ( Google is our friend):

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr006.htm

http://download.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmtspit.htm

http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmflash.htm#i1011846

That site has many examples as well...





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[karluk]

Also take a look at chapter 13 in the Backup and Recovery Advanced User's Guide. It is probably more specific to your purpose of creating a clone of an existing database, rolled back to a point in time.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#i1008564

13 Creating and Updating Duplicate Databases with RMAN

This chapter describes how to use the DUPLICATE command to create a duplicate database for testing purposes.

 

[CassidyHunt]

Thansk. Take me a bit to try it out. I will let you know my luck.

Thanks

Cassidy