Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-19643: datafile 323: incremental-start SCN is too recent

Posted by Hendry chinnapparaj on June 4, 2010

Problem

———-

The incremental backup throws up ORA-19643 complaining on the datafile checkpoint SCN as older.

RMAN> BACKUP INCREMENTAL LEVEL 1 NOT BACKED UP SINCE TIME ‘SYSDATE-1/2’ DEVICE TYPE DISK CUMULATIVE DATABASE

FILESPERSET 8 FORMAT ‘/u03/oradata/flash_recovery_area/CPSOA1_JS/backupset/LF_%U’;

Starting backup at 03-06-2010 18:22:56

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=702 devtype=DISK

channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00023 name=/u02/oradata/cpsoa1/BWA_LM_DATA_64M_02.DBF

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/03/2010 18:23:42

ORA-19643: datafile 323: incremental-start SCN is too recent

ORA-19640: datafile checkpoint is SCN 18624685831 time 04/07/2009 15:15:04

Solution

————

Do the backup based on the SCN time in the error above, which takes care of the other datafiles as well.

RMAN> BACKUP INCREMENTAL FROM SCN 18624685831 DEVICE TYPE DISK CUMULATIVE DATABASE FILESPERSET 8 FORMAT ‘/u03/oradata/flash_recovery_area/CPSOA1_JS/backupset/LF_%U’;

Starting backup at 03-06-2010 18:59:28

using channel ORA_DISK_1

RMAN-06755: WARNING: datafile 269: incremental-start SCN is too recent; using checkpoint SCN 18624685314 instead

RMAN-06755: WARNING: datafile 270: incremental-start SCN is too recent; using checkpoint SCN 18624685323 instead

RMAN-06755: WARNING: datafile 271: incremental-start SCN is too recent; using checkpoint SCN 18624685332 instead

RMAN-06755: WARNING: datafile 272: incremental-start SCN is too recent; using checkpoint SCN 18624685341 instead

RMAN-06755: WARNING: datafile 273: incremental-start SCN is too recent; using checkpoint SCN 18624685351 instead

RMAN-06755: WARNING: datafile 274: incremental-start SCN is too recent; using checkpoint SCN 18624685360 instead

RMAN-06755: WARNING: datafile 275: incremental-start SCN is too recent; using checkpoint SCN 18624685370 instead

RMAN-06755: WARNING: datafile 276: incremental-start SCN is too recent; using checkpoint SCN 18624685379 instead

RMAN-06755: WARNING: datafile 277: incremental-start SCN is too recent; using checkpoint SCN 18624685389 instead

RMAN-06755: WARNING: datafile 278: incremental-start SCN is too recent; using checkpoint SCN 18624685399 instead

RMAN-06755: WARNING: datafile 279: incremental-start SCN is too recent; using checkpoint SCN 18624685408 instead

RMAN-06755: WARNING: datafile 280: incremental-start SCN is too recent; using checkpoint SCN 18624685417 instead

RMAN-06755: WARNING: datafile 281: incremental-start SCN is too recent; using checkpoint SCN 18624685426 instead

RMAN-06755: WARNING: datafile 282: incremental-start SCN is too recent; using checkpoint SCN 18624685436 instead

RMAN-06755: WARNING: datafile 283: incremental-start SCN is too recent; using checkpoint SCN 18624685446 instead

RMAN-06755: WARNING: datafile 284: incremental-start SCN is too recent; using checkpoint SCN 18624685456 instead

RMAN-06755: WARNING: datafile 285: incremental-start SCN is too recent; using checkpoint SCN 18624685465 instead

RMAN-06755: WARNING: datafile 286: incremental-start SCN is too recent; using checkpoint SCN 18624685475 instead

RMAN-06755: WARNING: datafile 287: incremental-start SCN is too recent; using checkpoint SCN 18624685484 instead

RMAN-06755: WARNING: datafile 288: incremental-start SCN is too recent; using checkpoint SCN 18624685494 instead

RMAN-06755: WARNING: datafile 289: incremental-start SCN is too recent; using checkpoint SCN 18624685504 instead

RMAN-06755: WARNING: datafile 290: incremental-start SCN is too recent; using checkpoint SCN 18624685514 instead

RMAN-06755: WARNING: datafile 291: incremental-start SCN is too recent; using checkpoint SCN 18624685523 instead

RMAN-06755: WARNING: datafile 292: incremental-start SCN is too recent; using checkpoint SCN 18624685532 instead

RMAN-06755: WARNING: datafile 293: incremental-start SCN is too recent; using checkpoint SCN 18624685542 instead

RMAN-06755: WARNING: datafile 294: incremental-start SCN is too recent; using checkpoint SCN 18624685552 instead

RMAN-06755: WARNING: datafile 295: incremental-start SCN is too recent; using checkpoint SCN 18624685561 instead

RMAN-06755: WARNING: datafile 296: incremental-start SCN is too recent; using checkpoint SCN 18624685571 instead

RMAN-06755: WARNING: datafile 297: incremental-start SCN is too recent; using checkpoint SCN 18624685580 instead

RMAN-06755: WARNING: datafile 298: incremental-start SCN is too recent; using checkpoint SCN 18624685590 instead

RMAN-06755: WARNING: datafile 299: incremental-start SCN is too recent; using checkpoint SCN 18624685599 instead

RMAN-06755: WARNING: datafile 300: incremental-start SCN is too recent; using checkpoint SCN 18624685608 instead

RMAN-06755: WARNING: datafile 301: incremental-start SCN is too recent; using checkpoint SCN 18624685617 instead

RMAN-06755: WARNING: datafile 302: incremental-start SCN is too recent; using checkpoint SCN 18624685627 instead

RMAN-06755: WARNING: datafile 303: incremental-start SCN is too recent; using checkpoint SCN 18624685637 instead

RMAN-06755: WARNING: datafile 304: incremental-start SCN is too recent; using checkpoint SCN 18624685647 instead

RMAN-06755: WARNING: datafile 305: incremental-start SCN is too recent; using checkpoint SCN 18624685656 instead

RMAN-06755: WARNING: datafile 306: incremental-start SCN is too recent; using checkpoint SCN 18624685666 instead

RMAN-06755: WARNING: datafile 307: incremental-start SCN is too recent; using checkpoint SCN 18624685677 instead

RMAN-06755: WARNING: datafile 308: incremental-start SCN is too recent; using checkpoint SCN 18624685687 instead

RMAN-06755: WARNING: datafile 309: incremental-start SCN is too recent; using checkpoint SCN 18624685696 instead

RMAN-06755: WARNING: datafile 310: incremental-start SCN is too recent; using checkpoint SCN 18624685706 instead

RMAN-06755: WARNING: datafile 311: incremental-start SCN is too recent; using checkpoint SCN 18624685715 instead

RMAN-06755: WARNING: datafile 312: incremental-start SCN is too recent; using checkpoint SCN 18624685725 instead

RMAN-06755: WARNING: datafile 313: incremental-start SCN is too recent; using checkpoint SCN 18624685735 instead

RMAN-06755: WARNING: datafile 314: incremental-start SCN is too recent; using checkpoint SCN 18624685744 instead

RMAN-06755: WARNING: datafile 315: incremental-start SCN is too recent; using checkpoint SCN 18624685753 instead

RMAN-06755: WARNING: datafile 316: incremental-start SCN is too recent; using checkpoint SCN 18624685763 instead

RMAN-06755: WARNING: datafile 317: incremental-start SCN is too recent; using checkpoint SCN 18624685773 instead

RMAN-06755: WARNING: datafile 318: incremental-start SCN is too recent; using checkpoint SCN 18624685783 instead

RMAN-06755: WARNING: datafile 319: incremental-start SCN is too recent; using checkpoint SCN 18624685793 instead

RMAN-06755: WARNING: datafile 320: incremental-start SCN is too recent; using checkpoint SCN 18624685803 instead

RMAN-06755: WARNING: datafile 321: incremental-start SCN is too recent; using checkpoint SCN 18624685813 instead

RMAN-06755: WARNING: datafile 322: incremental-start SCN is too recent; using checkpoint SCN 18624685822 instead

channel ORA_DISK_1: starting compressed full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00023 name=/u02/oradata/cpsoa1/BWA_LM_DATA_64M_02.DBF

input datafile fno=00323 name=/u04/oradata/cpsoa1/CB055_01.DBF

skipping datafile 00323 because it has not changed

input datafile fno=00346 name=/u04/oradata/cpsoa1/CB078_01.DBF

input datafile fno=00222 name=/u02/oradata/cpsoa1/CSHTRAP.DBF

input datafile fno=00120 name=/u02/oradata/cpsoa1/CPS_LM_DATA_64M_01.DBF

channel ORA_DISK_1: starting piece 1 at 03-06-2010 18:59:37

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: