Re: Restore to test env

>>Adam Sorati wrote: >> >>> Eng: online 7.23.UC1 >>> OS: AIX 2.4.1 >>> HW: 1x166Mhz CPU, 128MG RAM and 2x4.5GIG disk. >>> DB: 1.3 GIG >>> 242 Tables >>> >>> I have a production instance and a development instance on the same >>> machine, the database in each is the same. A level 0 backup is done >>> each night for the production instance. >>> >>> A question has been put to me which I think is not possible however I >>> am getting great pressure to solve it. >>> >>> The question ' Is it possible to restore an old production backup to the >>> >>> development instance, without effecting the production instance at all. >>> This is not possible because ontape will restore to the identical chunks which it initially backed up. However, given your database size and machine combination, a dbexport-dbimport combination would work - that is, if you can find the window (about 1.5 hours, I imagine) to dbexport . Your production database will be locked exclusively during the export. The dbimport would probably take about 3 to 4 hours. HTH Rudy Fernandes Purolator Courier.