Skip to Content
0
Former Member
Aug 10, 2008 at 04:41 PM

Homogeneous System Copy

27 Views

Hello Experts,

I want to make a copy of production database to our test system.

For this purpose i am using a one month old Offline backup.

I am creating the script to generate the control files on production using following command

SQL:>Alter database backup control files to trace;

This will generate the script which will consist the data till today ( number of data files may be differ from actual restored and mentioned in script ), however i want the script which generate control files till my offline backup (ie 1 month old).

How can i achieve this.

Thanks.