Database Software

Hi,

Apologies for the cross-post, I wasn't sure which forum to post this in.

I have a procedure that uses RMAN duplication to create a clone of my production database for another business unit to query and play around with. This procedure works really well except for the need to do a full backup to disk and to copy the backupset files to the other node to do the duplication. Our DB is 12GB in size and even when tarred up, the copy still takes ages over our WAN link. I have had an idea to try to just backup the archivelogs that are generated each day, copy them over (which would be much quicker) and then do a restore on the server hosting the duplicated database. I don't know if this is possible without using Data Guard though and we are running only Standard Edition of 10g2. I guess that the control files of the duplicate would have no idea as to the existance of these new archived logs though and therefore RMAN could do nothing with them. I thought I'd better check with people here first.

Thanks in advance.

Cheers,

Phil