Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE error from auxiliary database: ORA-01152: file 2 was not restored fr

RjTanMay 15 2013 — edited May 16 2013
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
This post has been answered by Hemant K Chitale on May 15 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2013
Added on May 15 2013
4 comments
2,598 views