RMAN-06457 error when cloning a RAC db to a different box

  • From: Li Li <litanli@xxxxxxxxx>
  • To: oracle-l <Oracle-L@xxxxxxxxxxxxx>
  • Date: Mon, 1 Feb 2010 17:34:52 -0600

Hi, List,

Today when cloning a production RAC DB to a different box, we ran into
this RMAN-06457 error. what we did was:

RMAN> run
{
set until sequence 1468 thread 4;
duplicate target database to xxxxx;
}

and it errored out with:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/01/2010 16:20:02
RMAN-06457: UNTIL scn (15612469216) is ahead of last scn in archived
logs (15576714010)

we have been doing this routinely to refresh our non-production
databases with no issue for a long time. One thing to note here is:
one of the production RAC server was down (and still is down). SCN
15576714010 appears to be really really old, it doesn't make sense to
me. The backup used to clone was from like:

backup device type disk format
'/path/to/backup/location/%d_%I_%Y%M%D_%s_%p' database plus
archivelog;

so this basically 1. backup the existing archivelogs, 2. backup the
datafiles, 3. backup the new archivelogs that were generated during
backing up the datafiles.

sequence 1468 thread 4 was the newly generated archivelogs during
backing up the datafiles, I am puzzled how this would lead to the
RMAN-06457 error? Can anyone shed some light here?

Thanks in Advance!
-Li
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » RMAN-06457 error when cloning a RAC db to a different box - Li Li