When you see that error in your RMAN backups then check the status of the file#. It might be OFFLINE.
Here is the RMAN Log showing that error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_7 channel at 07/10/2013 13:31:04
ORA-19643: datafile 6: incremental-start SCN is too recent
ORA-19640: datafile checkpoint is SCN 286109177130 time 01/28/2013 15:44:19
Recovery Manager complete.
[Major] From: ob2rman@ndhdbt3 "adm_t" Time: 07/10/13 13:32:09
External utility reported error.
RMAN PID=9062
[Major] From: ob2rman@ndhdbt3 "adm_t" Time: 07/10/13 13:32:09
The database reported error while performing requested operation.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_7 channel at 07/10/2013 13:31:04
ORA-19643: datafile 6: incremental-start SCN is too recent
ORA-19640: datafile checkpoint is SCN 286109177130 time 01/28/2013 15:44:19
Recovery Manager complete.
In my case, I know that we have to take this particular tablespace offline due to some issues and that was causing SCN check to be invalid.
select current_scn from v$database;
CURRENT_SCN
331472777523
So, I just have to ged rid of that tablespace to make my backups run successful.
Here is the RMAN Log showing that error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_7 channel at 07/10/2013 13:31:04
ORA-19643: datafile 6: incremental-start SCN is too recent
ORA-19640: datafile checkpoint is SCN 286109177130 time 01/28/2013 15:44:19
Recovery Manager complete.
[Major] From: ob2rman@ndhdbt3 "adm_t" Time: 07/10/13 13:32:09
External utility reported error.
RMAN PID=9062
[Major] From: ob2rman@ndhdbt3 "adm_t" Time: 07/10/13 13:32:09
The database reported error while performing requested operation.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on dev_7 channel at 07/10/2013 13:31:04
ORA-19643: datafile 6: incremental-start SCN is too recent
ORA-19640: datafile checkpoint is SCN 286109177130 time 01/28/2013 15:44:19
Recovery Manager complete.
In my case, I know that we have to take this particular tablespace offline due to some issues and that was causing SCN check to be invalid.
select current_scn from v$database;
CURRENT_SCN
331472777523
So, I just have to ged rid of that tablespace to make my backups run successful.
No comments:
Post a Comment