Hi,
quering v$rman_status on 10204 instance shows :
select sid,recid,command_id,operation,status,start_time,end_time
from v$rman_status
where recid=16360
SID RECID COMMAND_ID OPERATION STATUS START_TIM END_TIME
---- ---------- -------------------- ---------- ----------------------- --------- ---------
0 16360 2012-05-07T15:54:18 RMAN COMPLETED WITH ERRORS 07-MAY-12 07-MAY-12
What was the reason of the failure ?
I follwed : http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcviews050.htm
COMPLETED WITH ERRORS - Job completed successfully, but there were some errors which were overcome using failover features. For example, RESTORE FAILOVER or BACKUP FAILOVER was used to schedule the job on another channel.
The first failure : 16360 took 4 hours to complete . rman backedup : 1.3 Tera
And then it was automatically restarted :16366 for another 4 hourse . rman backedup once again : 1.3 Tera
1)Why it didnt backuped only the fixs for errors in previous backup ?
2) What was the error in the first time ? Where i can found the reason for the failure so i can try to fix it by myself before the next backup begin ?
select
SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'dd/mm/yy hh24:mi') start_time,
to_char(END_TIME,'dd/mm/yy hh24:mi') end_time,
round((end_time-start_time)*1440,2) "Minutes"
from V$RMAN_BACKUP_JOB_DETAILS
where input_type='DB INCR'
order by session_key desc
16366 DB INCR COMPLETED 07/05/12 20:00 08/05/12 00:06 245.82
16360 DB INCR COMPLETED WITH ERRORS 07/05/12 15:54 07/05/12 19:59 244.37