Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

problem with incremental 1 backup

796727Feb 10 2011 — edited Feb 10 2011

Hi, two days ago we backed up whole database. It was level 0 backup. It completed without errors. But one day later when incremental 1 backup was finished, we encountered that its status was COMPLETED WITH ERRORS. I wonder what went wrong and if this problem will do any trouble in case of potencial recovery. I mean, can I think that it is ok? here is the log of COMPLETED WITH ERRORS backup 1 : ( I give only fragments where errors are...)

...

input datafile fno=00079 name=/u01/app/oracle/oradata/easy/snapshot_tc12
input datafile fno=00081 name=/u01/app/oracle/oradata/easy/snapshot_tc307
input datafile fno=00074 name=/u01/app/oracle/oradata/easy/integracja03
skipping datafile 00074 because it has not changed
input datafile fno=00008 name=/u01/app/oracle/oradata/easy/bnumerow101
input datafile fno=00010 name=/u01/app/oracle/oradata/easy/bnumerow301
input datafile fno=00023 name=/u01/app/oracle/oradata/easy/invision01
input datafile fno=00046 name=/u01/app/oracle/oradata/easy/bnumerow302
input datafile fno=00058 name=/u01/app/oracle/oradata/easy/obn03
input datafile fno=00064 name=/u01/app/oracle/oradata/easy/dbspace2_idx03
input datafile fno=00070 name=/u01/app/oracle/oradata/easy/dbspace203
input datafile fno=00078 name=/u01/app/oracle/oradata/easy/invision03
input datafile fno=00043 name=/u01/app/oracle/oradata/easy/statstbs01
input datafile fno=00048 name=/u01/app/oracle/oradata/easy/sisdevelop01
RMAN-03009: failure of backup command on t1 channel at 02/10/2011 01:40:15
ORA-19643: datafile 75: incremental-start SCN is too recent
ORA-19640: datafile checkpoint is SCN 7857728905217 time 01/11/2011 11:37:51
channel t1 disabled, job failed on it will be run on another channel
channel t2: starting incremental level 1 datafile backupset
channel t2: specifying datafile(s) in backupset
input datafile fno=00002 name=/u01/app/oracle/oradata/easy/undotbs101
input datafile fno=00030 name=/u01/app/oracle/oradata/easy/snapshot_tc01
input datafile fno=00032 name=/u01/app/oracle/oradata/easy/snapshot_tc03

...

input datafile fno=00039 name=/u01/app/oracle/oradata/easy/snapshot_tc301
input datafile fno=00041 name=/u01/app/oracle/oradata/easy/snapshot_tc303
channel t2: starting piece 1 at 10-LUT-2011 01:59:02
input datafile fno=00052 name=/u01/app/oracle/oradata/easy/snapshot_tc205
input datafile fno=00054 name=/u01/app/oracle/oradata/easy/rsnapshot_idx07
input datafile fno=00057 name=/u01/app/oracle/oradata/easy/snapshot_tc305
input datafile fno=00061 name=/u01/app/oracle/oradata/easy/snapshot_tc206
input datafile fno=00065 name=/u01/app/oracle/oradata/easy/snapshot_tc207
input datafile fno=00067 name=/u01/app/oracle/oradata/easy/snapshot_tc09
input datafile fno=00072 name=/u01/app/oracle/oradata/easy/snapshot_idx11
input datafile fno=00079 name=/u01/app/oracle/oradata/easy/snapshot_tc12
input datafile fno=00081 name=/u01/app/oracle/oradata/easy/snapshot_tc307
input datafile fno=00074 name=/u01/app/oracle/oradata/easy/integracja03
skipping datafile 00074 because it has not changed
input datafile fno=00008 name=/u01/app/oracle/oradata/easy/bnumerow101
input datafile fno=00010 name=/u01/app/oracle/oradata/easy/bnumerow301
input datafile fno=00023 name=/u01/app/oracle/oradata/easy/invision01
input datafile fno=00046 name=/u01/app/oracle/oradata/easy/bnumerow302
input datafile fno=00058 name=/u01/app/oracle/oradata/easy/obn03
input datafile fno=00064 name=/u01/app/oracle/oradata/easy/dbspace2_idx03
input datafile fno=00070 name=/u01/app/oracle/oradata/easy/dbspace203
input datafile fno=00078 name=/u01/app/oracle/oradata/easy/invision03
input datafile fno=00043 name=/u01/app/oracle/oradata/easy/statstbs01
input datafile fno=00048 name=/u01/app/oracle/oradata/easy/sisdevelop01
input datafile fno=00075 name=/u01/app/oracle/oradata/easy/invision02
skipping datafile 00075 because it has not changed
input datafile fno=00004 name=/u01/app/oracle/oradata/easy/undotbs201
channel t2: specifying datafile(s) in backupset
channel t2: starting incremental level 1 datafile backupset
input datafile fno=00044 name=/u01/app/oracle/oradata/easy/easyold02
channel t2: finished piece 1 at 10-LUT-2011 02:17:58
piece handle=df_L1C_t742701541_s56409_p1 tag=TAG20110210T014012 comment=API Version 2.0,MMS Version 5.5.1.0
channel t2: backup set complete, elapsed time: 00:18:57
Finished backup at 10-LUT-2011 02:17:58

...

archived log /ar1/easy/easy_1_0000051639_685384945.arc not found or out of sync with catalog
skipping inaccessible file /ar1/easy/easy_1_0000051639_685384945.arc
RMAN-06061: WARNING: skipping archivelog compromises recoverability
channel t2: starting archive log backupset
channel t2: specifying archive log(s) in backup set
input archive log thread=2 sequence=93294 recid=144148 stamp=742701717
input archive log thread=2 sequence=93295 recid=144150 stamp=742701985
input archive log thread=2 sequence=93296 recid=144151 stamp=742702141
input archive log thread=2 sequence=93297 recid=144152 stamp=742702162
input archive log thread=2 sequence=93298 recid=144154 stamp=742702176
archived log /ar1/easy/easy_1_0000051635_685384945.arc not found or out of sync with catalog
skipping inaccessible file /ar1/easy/easy_1_0000051634_685384945.arc
archived log /ar1/easy/easy_1_0000051634_685384945.arc not found or out of sync with catalog
skipping inaccessible file /ar1/easy/easy_1_0000051633_685384945.arc
archived log /ar1/easy/easy_1_0000051633_685384945.arc not found or out of sync with catalog
archived log /ar1/easy/easy_1_0000051637_685384945.arc not found or out of sync with catalog
input archive log thread=2 sequence=93300 recid=144156 stamp=742702221
channel t2: starting piece 1 at 10-LUT-2011 02:19:17
input archive log thread=2 sequence=93311 recid=144172 stamp=742702742
input archive log thread=2 sequence=93310 recid=144170 stamp=742702717

...

RMAN-06012: channel: t1 not allocated
RMAN-03002: failure of release command at 02/10/2011 02:20:35
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2011

Added on Feb 10 2011

#general-database-discussions

2 comments

661 views

Oracle Database Discussions

problem with incremental 1 backup

Comments

Post Details