Would backup archive until time delete input backup the whole or part of the archive log file?
Hi all,
Since I'm using Oracle standard edition (11.2.0.4), I speed up the archive log backup by using 2 scripts:
Script A: database include current controlfile archivelog UNTIL TIME "TO_DATE('${CURDATE} 10:00:00','YYYYMMDD HH24:MI:SS')" delete input;
Script B: database include current controlfile archivelog FROM TIME "TO_DATE('${CURDATE} 10:00:00','YYYYMMDD HH24:MI:SS')" delete input;
Both processes backup the following files:
| RECID | THREAD# | FIRST_TIME | NEXT_TIME |
|---|---|---|---|
| 3854 | 1 | 2014/06/26 9:55:12 | 2014/06/26 10:00:12 |
| 3855 | 2 | 2014/06/26 9:50:08 | 2014/06/26 10:05:15 |
Sometime, ORA-19588 is raised when both processes want to backup both files, but are deleted by the other process.
But what I really concern is, would script A backup the whole archive files, or only content between 9:55:12 - 10:00:00 for recid 3854, and content between 9:50:08 - 10:00:00 for recid 3855?
0