Shulou(Shulou.com)06/01 Report--

According to Kangfu backup, the database backup times is wrong.

But according to my query from the database, there was no error, and it was successful, but the backup of the archived log was different from the usual: a few more records were backed up every day.

I guess there are too many archived records, and if you can't finish them at one time, you'll have to prepare them several times.

It can also be seen from the archive directory of the database host that in the past only the most recent week's archives were saved, but now it has been more than ten days.

So I rm the archived logs that have been backed up successfully, then crosscheck, and then delete expired archivelog all.

The next day, I checked and found that the backup record was normal. Simply record it here.

The following is a detailed record

SQL*Plus: Release 11.2.0.2.0 Production on Wed Apr 3 10:57:02 2019

Copyright (c) 1982, 2010, Oracle. All rights reserved.

SQL > connect / as sysdba

Connected.

SQL > set lines 9999

SQL > set pages 9999

SQL >

SQL > col backup_name for A15

SQL > col start_time for A15

SQL > col elapsed_time for A15

SQL > col status for A10

SQL > col input_type for A10

SQL > col output_device_type for A10

SQL > col input_size for A10

SQL > col output_size for A10

SQL > col output_rate_per_sec for A10

SQL >

SQL >

SQL >

SQL > SELECT

2 r.command_id backup_name

3, TO_CHAR (r.start_time, 'mm/dd/yyyy HH24:MI:SS') start_time

4, r.time_taken_display elapsed_time

5, DECODE (r.status

6, 'COMPLETED'

7, r.status

8, 'RUNNING'

9, r.status

10, 'FAILED'

11, r.status

12, r.status

13) status

14, r.input_type input_type

15, r.output_device_type output_device_type

16, r.input_bytes_display input_size

17, r.output_bytes_display output_size

18, r.output_bytes_per_sec_display output_rate_per_sec

19 FROM

20 (select

21 command_id

22, start_time

23, time_taken_display

24, status

25, input_type

26, output_device_type

27, input_bytes_display

28, output_bytes_display

29, output_bytes_per_sec_display

30 from v$rman_backup_job_details

31 order by start_time DESC

32) r

33 WHERE

34 rownum < 31

35 order by 1

BACKUP_NAME START_TIME ELAPSED_TIME STATUS INPUT_TYPE OUTPUT_DEV INPUT_SIZE OUTPUT_SIZ OUTPUT_RAT

2019-03-31T05:4 03ax 31max 2019 05:4 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 29.53M 32.00M 2.91m

1:38 1:39

2019-03-31T06:0 03ax 31max 2019 06:0 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 45.39M 47.00M 6.71m

2:44 2:46

2019-03-31T06:2 03ax 31max 2019 06:2 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 52.34M 54.00M 4.91m

3:45 3:47

2019-03-31T06:4 03ax 31max 2019 06:4 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 47.54M 49.00M 8.17m

4:41 4:43

2019-04-01T03:0 04ax 01ax 2019 03:0 00:09:29 COMPLETED DB INCR SBT_TAPE 127.82G 1020.00M 1.79m

0:11 0:13

2019-04-01T03:1 04Accord 01Accord 2019 03:1 00:00:34 COMPLETED ARCHIVELOG SBT_TAPE 2.73G 2.74G 82.41m

0:14 0:16

2019-04-01T03:3 04ax 01ax 2019 03:3 00:04:36 COMPLETED ARCHIVELOG SBT_TAPE 26.16G 26.17G 97.08m

1:56 1:58

2019-04-01T03:5 04ax 01ax 2019 03:5 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 134.60M 136.00M 12.36m

6:51 6:53

2019-04-01T04:1 04ax 01ax 2019 04:1 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 37.52M 39.00M 6.50m

7:57 7:59

2019-04-01T04:3 04ax 01ax 2019 04:3 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 30.23M 32.00M 4.57m

8:52 8:53

2019-04-01T04:5 04ax 01ax 2019 05:0 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 30.18M 32.00M 4.57m

9:59 0:01

2019-04-01T05:2 04ax 01ax 2019 05:2 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 98.40M 100.00M 16.67m

0:50 0:52

2019-04-01T05:4 04ax 01ax 2019 05:4 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 35.81M 37.00M 6.17m

1:55 1:57

2019-04-01T06:0 04ax 01ax 2019 06:0 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 46.00M 47.00M 4.27m

2:57 2:59

2019-04-01T06:2 04ax 01ax 2019 06:2 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 52.10M 53.00M 4.82m

3:55 3:57

2019-04-01T06:4 04ax 01ax 2019 06:4 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 53.55M 55.00M 7.86m

4:54 4:56

2019-04-02T03:0 04Accord 02 Universe 2019 03:0 00:10:40 COMPLETED DB INCR SBT_TAPE 127.83G 817.00M 1.28m

0:17 0:19

2019-04-02T03:1 04Compact 02 Universe 2019 03:1 00:00:19 COMPLETED ARCHIVELOG SBT_TAPE 1.42G 1.42G 76.42m

1:26 1:28

2019-04-02T03:3 04Compact 02 Universe 2019 03:3 00:04:26 COMPLETED ARCHIVELOG SBT_TAPE 29.11G 29.13G 112.12m

3:01 3:02

2019-04-02T03:5 04Compact 02 Universe 2019 03:5 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 33.86M 35.00M 5.00m

8:01 8:03

2019-04-02T04:1 04Compact 02 Universe 2019 04:1 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 31.62M 33.00M 4.71m

9:04 9:06

2019-04-02T04:4 04ax 02max 2019 04:4 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 30.39M 32.00M 4.57m

0:07 0:09

2019-04-02T05:0 04Compact 02 Universe 2019 05:0 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 41.61M 43.00M 6.14m

1:01 1:03

2019-04-02T05:2 04Compact 02 Universe 2019 05:2 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 86.42M 88.00M 14.67m

2:00 2:03

2019-04-02T05:4 04Accord 02Accord 2019 05:4 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 36.21M 38.00M 5.43m

3:04 3:06

2019-04-02T06:0 04Compact 02 Universe 2019 06:0 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 50.37M 52.00M 4.73m

4:09 4:11

2019-04-02T06:2 04Compact 02 Universe 2019 06:2 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 48.10M 49.00M 7.00m

5:08 5:10

2019-04-02T06:4 04Compact 02 Universe 2019 06:4 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 48.05M 49.00M 7.00m

6:12 6:14

2019-04-03T03:0 04Compact 03Accord 2019 03:0 00:11:10 COMPLETED DB INCR SBT_TAPE 127.83G 755.00M 1.13m

0:28 0:30

2019-04-03T03:1 04Compact 03Accord 2019 03:1 00:00:29 COMPLETED ARCHIVELOG SBT_TAPE 1.62G 1.63G 57.41m

2:04 2:06

30 rows selected.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.