| System Change Number issue [message #244847] |
Thu, 14 June 2007 05:53  |
niallg
Messages: 1
Registered: June 2007
Location: Cork, Ireland
|
Junior Member |
|
|
System details: Oracle 7.3.4 on OpenVMS V7.1-2 (very old and due to be replaced in 2 years).
Every hour, we force a log switch, and determine the HIGH_CHANGE# for the Archived Redo Log (ARL) created, for database recovery purposes.
Here are the ARLs generated on 11-May-07:
Archived Redo-Log Size Date/Time
(Blocks)
ARCH0001_0000018490.ARC;1 2636 11-MAY-2007 09:01:21.67
ARCH0001_0000018491.ARC;1 2845 11-MAY-2007 10:01:21.09
ARCH0001_0000018492.ARC;1 3139 11-MAY-2007 11:01:25.65
ARCH0001_0000018493.ARC;1 2623 11-MAY-2007 12:01:22.71
ARCH0001_0000018494.ARC;1 3624 11-MAY-2007 13:01:19.35
ARCH0001_0000018495.ARC;1 1117 11-MAY-2007 14:01:21.34
ARCH0001_0000018496.ARC;1 2501 11-MAY-2007 15:01:20.09
ARCH0001_0000018497.ARC;1 2392 11-MAY-2007 16:01:19.30
ARCH0001_0000018498.ARC;1 2808 11-MAY-2007 17:01:20.43
ARCH0001_0000018499.ARC;1 284 11-MAY-2007 18:01:26.90
SEQUENCE# TO_CHAR(LOW_CHANGE#) TO_CHAR(HIGH_CHANGE#)
----------------------------------------
18490 14737058 14737413
18491 14737414 14737835
18492 14737836 14738286
18493 14738287 14738675
18494 14738676 7881857686858
18495 7881857686859 7881857687068
18496 7881857687069 7881857687473
18497 7881857687474 7881857687829
18498 7881857687830 7881857688315
18499 7881857688316 7881857688414
Can anyone explain the jump in SCN in sequence 18494 ?
Thank You
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
