[Oracle 8][DEBUTANT]LOG HISTORY "Saturé"
Lorsque je regarde mon control file, voila ce que je vois:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
| select * from v$controlfile_record_section
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX
----------------- ----------- ------------- ------------ ----------- ----------
DATABASE 192 1 1 0 0
CKPT PROGRESS 4084 1 0 0 0
REDO THREAD 104 1 1 0 0
REDO LOG 72 32 4 0 0
DATAFILE 180 254 6 0 0
FILENAME 524 319 10 0 0
TABLESPACE 68 254 6 0 0
RESERVED1 56 254 0 0 0
RESERVED2 1 1 0 0 0
LOG HISTORY 36 6126 6126 4369 4368
OFFLINE RANGE 56 291 0 0 0
ARCHIVED LOG 584 13 0 0 0
BACKUP SET 40 408 0 0 0
BACKUP PIECE 736 510 0 0 0
BACKUP DATAFILE 116 563 0 0 0
BACKUP REDOLOG 76 107 0 0 0
DATAFILE COPY 660 519 0 0 0
BACKUP CORRUPTION 44 371 0 0 0
COPY CORRUPTION 40 408 0 0 0
DELETED OBJECT 20 408 0 0 0
PROXY COPY 852 575 0 0 0
RESERVED4 1 8168 0 0 0
22 rows selected |
Mon LOG HISTORY est saturé.
Comment faire pour le réinitialiser?
