Hello,
i'm trying to clone a database. It is in archive log mode.
I took a full back using below command
run {
backup
tag 'DAILY_WHOLE'
format 'FULL_backup_%s_%p_%c.bkp' database
plus archivelog
tag 'DAILY_WHOLE'
delete all input;
backup
current controlfile
format 'FULL_backup_%s_%p_%c.bkp' tag 'WHOLE'
spfile
format 'FULL_backup_%s_%p_%c.bkp' tag 'WHOLE';
}
then i issue a duplicate database command
RUN
{
DUPLICATE DATABASE TO TEST_DB
NOFILENAMECHECK
NOREDO
BACKUP LOCATION '/disk10/flash_recovery_area/PROD';
}
at the very end I got this error.
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 05/15/2013 11:59:21
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01152: file 2 was not restored from a sufficiently old backup
ORA-01110: data file 2: 'sysaux.dbf'
Can anyone help me? I would appreciate it. thanks