據康孚備份方面反映，數據庫備份時報錯。
讓客戶滿意是我們工作的目標，不斷超越客戶的期望值來自于我們對這個行業(yè)的熱愛。我們立志把好的技術通過有效、簡單的方式提供給客戶，將通過不懈努力成為客戶在信息化領域值得信任、有價值的長期合作伙伴，公司提供的服務項目有：域名申請、網絡空間、營銷軟件、網站建設、合浦網站維護、網站推廣。
但據我從數據庫方面查詢，沒有報錯，并且是成功的，只是歸檔日志的備份與平常不同：每天備份多了幾條記錄。
我猜想是歸檔記錄多了，一次備不完，就多備了幾次。
從數據庫主機的歸檔目錄也能看出，以往只保存最近一周的歸檔，但現在已超過十天了。
于是我把已經備份成功的歸檔日志rm掉，再crosscheck，再delete expired archivelog all;
第二天檢查發(fā)現備份記錄正常了，簡單記錄在此。
以下是詳細記錄
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 03/31/2019 05:4 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 29.53M 32.00M 2.91M
1:38 1:39
2019-03-31T06:0 03/31/2019 06:0 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 45.39M 47.00M 6.71M
2:44 2:46
2019-03-31T06:2 03/31/2019 06:2 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 52.34M 54.00M 4.91M
3:45 3:47
2019-03-31T06:4 03/31/2019 06:4 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 47.54M 49.00M 8.17M
4:41 4:43
2019-04-01T03:0 04/01/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 04/01/2019 03:1 00:00:34 COMPLETED ARCHIVELOG SBT_TAPE 2.73G 2.74G 82.41M
0:14 0:16
2019-04-01T03:3 04/01/2019 03:3 00:04:36 COMPLETED ARCHIVELOG SBT_TAPE 26.16G 26.17G 97.08M
1:56 1:58
2019-04-01T03:5 04/01/2019 03:5 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 134.60M 136.00M 12.36M
6:51 6:53
2019-04-01T04:1 04/01/2019 04:1 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 37.52M 39.00M 6.50M
7:57 7:59
2019-04-01T04:3 04/01/2019 04:3 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 30.23M 32.00M 4.57M
8:52 8:53
2019-04-01T04:5 04/01/2019 05:0 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 30.18M 32.00M 4.57M
9:59 0:01
2019-04-01T05:2 04/01/2019 05:2 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 98.40M 100.00M 16.67M
0:50 0:52
2019-04-01T05:4 04/01/2019 05:4 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 35.81M 37.00M 6.17M
1:55 1:57
2019-04-01T06:0 04/01/2019 06:0 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 46.00M 47.00M 4.27M
2:57 2:59
2019-04-01T06:2 04/01/2019 06:2 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 52.10M 53.00M 4.82M
3:55 3:57
2019-04-01T06:4 04/01/2019 06:4 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 53.55M 55.00M 7.86M
4:54 4:56
2019-04-02T03:0 04/02/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 04/02/2019 03:1 00:00:19 COMPLETED ARCHIVELOG SBT_TAPE 1.42G 1.42G 76.42M
1:26 1:28
2019-04-02T03:3 04/02/2019 03:3 00:04:26 COMPLETED ARCHIVELOG SBT_TAPE 29.11G 29.13G 112.12M
3:01 3:02
2019-04-02T03:5 04/02/2019 03:5 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 33.86M 35.00M 5.00M
8:01 8:03
2019-04-02T04:1 04/02/2019 04:1 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 31.62M 33.00M 4.71M
9:04 9:06
2019-04-02T04:4 04/02/2019 04:4 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 30.39M 32.00M 4.57M
0:07 0:09
2019-04-02T05:0 04/02/2019 05:0 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 41.61M 43.00M 6.14M
1:01 1:03
2019-04-02T05:2 04/02/2019 05:2 00:00:06 COMPLETED ARCHIVELOG SBT_TAPE 86.42M 88.00M 14.67M
2:00 2:03
2019-04-02T05:4 04/02/2019 05:4 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 36.21M 38.00M 5.43M
3:04 3:06
2019-04-02T06:0 04/02/2019 06:0 00:00:11 COMPLETED ARCHIVELOG SBT_TAPE 50.37M 52.00M 4.73M
4:09 4:11
2019-04-02T06:2 04/02/2019 06:2 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 48.10M 49.00M 7.00M
5:08 5:10
2019-04-02T06:4 04/02/2019 06:4 00:00:07 COMPLETED ARCHIVELOG SBT_TAPE 48.05M 49.00M 7.00M
6:12 6:14
2019-04-03T03:0 04/03/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 04/03/2019 03:1 00:00:29 COMPLETED ARCHIVELOG SBT_TAPE 1.62G 1.63G 57.41M
2:04 2:06
30 rows selected.
重慶分公司
重慶分公司
