Use RMAN to create a database copy from backup (Oracle 10.2)
We do daily RMAN backups of production to disk using this script with 2weeks retention:
backup device type disk tag '%TAG' database include current controlfile;
sql "alter system archive log current";
backup device type disk tag '%TAG' archivelog all delete input;
crosscheck backup;
I want to create a copy of the production database to a test database by restoring from the RMAN backup taken exactly 5 days ago. I appreciate any help on the steps I need to accomplish this.
Also, there is one large tablespace I don't need in the test database. Is there a way to skip this while creating the test copy, or do I need to do a full restore then delete the big tablespace?
0