据康孚备份方面反映,数据库备份时报错。
但据我从数据库方面查询,没有报错,并且是成功的,只是归档日志的备份与平常不同:每天备份多了几条记录。
我猜想是归档记录多了,一次备不完,就多备了几次。
从数据库主机的归档目录也能看出,以往只保存最近一周的归档,但现在已超过十天了。
于是我把已经备份成功的归档日志rm掉,再crosscheck,再delete expired archivelog all;
第二天检查发现备份记录正常了,简单记录在此。
以下是详细记录
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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26870952/viewspace-2640217/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26870952/viewspace-2640217/