Database Software

Hi all,

I need to clone a database every night from PROD to PREPROD.
I've been using RMAN, duplicate target database to 'PREPROD';
Since a few days ago it fails.

I use rman catalog

What I do is to get the SCN from rman, and then set unti scn xxx.

The is the script:

=====================
connected to target database: PNETPM (DBID=2326965480)
connected to recovery catalog database
connected to auxiliary database: PMPRE (not mounted)

RMAN>
echo set on


RMAN> run {
2> set until scn
3> 3406256315;
4> duplicate target database to 'PMPRE';
5> }

================================
It starts restoring but never finishes.
If I read the alert of the database beign cloned, I see the following:



alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16
Mon Nov 21 14:47:29 2011
alter database recover if needed
start until change 3406256315 using backup controlfile
Media Recovery Start
parallel recovery started with 7 processes
ORA-279 signalled during: alter database recover if needed
start until change 3406256315 using backup controlfile

I don't understand why it no longer works.

What should I do in order to get the preprod database cloned from prod at the same time when the PROD backup was taken with rman?

If I don't use set until clause, I need to copy the lasts archivelogs and then perform an imcomplete recvoery, but I need something automatic.

Thanks in advance