Database Backup and Recovery (MOSC)

MOSC Banner

Use RMAN to create a database copy from backup (Oracle 10.2)

edited Sep 2, 2012 4:45PM in Database Backup and Recovery (MOSC) 1 commentAnswered ✓
 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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center