Flashback database, (active) duplicate with RMAN, and tablespaces that are read-only. You can only have two out of three from my recent testing. One database with a few read-only tablespaces was cloned by using active duplicate in RMAN. Before the testing (using Real Application Testing replay) a restore point with guarantee flashback database was created. After the testing I tried to perform a flashback database, but it failed with:
Øyvind's Blog
Enesi Consulting AS
Trust your data
About
Enesi Consulting AS is at the time being just Øyvind Isene. Mostly Oracle, Linux, integration, and troubleshooting.
Learn More