Rman Restore & Recovery for 1 TB database
Hi,
We have a database of 1 TB size. Very often (Quarterly) clients want to clone that production database to test environment.
Clone means not the exact clone
.. it is a incomplete recovery (until time or scn) to the test database from the latest backup of production.
First I use to remove the database from the test environment, then create a fresh database with the same name as production, take a control file backup from production, mount the test database from that controlfile, then restore the latest production backup from tape.
After the recovery rename the database to TEST.
The structure has been made similar on TEST as PROD using symbolic links.
So first I change the route of tape to the test environment from production environment and restore from the latest backup using RMAN.
The archive logs are first restored from the tape to the archive destination and applied to the database.
The restore and recovery take place simultaneously.
My problem is the disk space. While restoring to the archive destination the disk becomes full. So I have to do UNTIL CANCEL recovery 3-4 times.
My question is that, is it possible to restore the archive logs and delete the logs immediately after it gets applied to the database.
Any RMAN scripts regarding that?
Please share your ideas.
Regards