归档日志删除的疑惑

显示全部楼层 · 2014-7-30 16:25:01

本帖最后由 blzys 于 2014-10-22 09:14 编辑
直接贴命令了，如下：
[oracle@svrdb01 log]$ ll
总计 5143396
-rw-r----- 1 oracle oinstall 37258752 09-28 14:02 1_1185_842565593.dbf
-rw-r----- 1 oracle oinstall 37718016 09-28 18:02 1_1186_842565593.dbf
-rw-r----- 1 oracle oinstall 41147904 09-29 01:00 1_1187_842565593.dbf
-rw-r----- 1 oracle oinstall 34901504 09-29 09:59 1_1188_842565593.dbf
-rw-r----- 1 oracle oinstall 34916352 09-29 13:09 1_1189_842565593.dbf
-rw-r----- 1 oracle oinstall 37512192 09-29 22:00 1_1190_842565593.dbf
-rw-r----- 1 oracle oinstall 36494336 09-29 22:03 1_1191_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 09-29 22:03 1_1192_842565593.dbf
-rw-r----- 1 oracle oinstall 43867648 09-29 22:03 1_1193_842565593.dbf
-rw-r----- 1 oracle oinstall 34957824 09-30 03:12 1_1194_842565593.dbf
-rw-r----- 1 oracle oinstall 35119104 09-30 12:30 1_1195_842565593.dbf
-rw-r----- 1 oracle oinstall 34899968 09-30 18:11 1_1196_842565593.dbf
-rw-r----- 1 oracle oinstall 38394880 09-30 22:00 1_1197_842565593.dbf
-rw-r----- 1 oracle oinstall 41236992 09-30 22:04 1_1198_842565593.dbf
-rw-r----- 1 oracle oinstall 42689536 09-30 22:04 1_1199_842565593.dbf
-rw-r----- 1 oracle oinstall 34903040 10-01 03:16 1_1200_842565593.dbf
-rw-r----- 1 oracle oinstall 35870720 10-01 12:30 1_1201_842565593.dbf
-rw-r----- 1 oracle oinstall 35013120 10-01 19:08 1_1202_842565593.dbf
-rw-r----- 1 oracle oinstall 37179392 10-01 22:00 1_1203_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-01 22:04 1_1204_842565593.dbf
-rw-r----- 1 oracle oinstall 34991616 10-01 22:13 1_1205_842565593.dbf
-rw-r----- 1 oracle oinstall 35330048 10-02 04:00 1_1206_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-02 13:00 1_1207_842565593.dbf
-rw-r----- 1 oracle oinstall 38646272 10-02 22:00 1_1208_842565593.dbf
-rw-r----- 1 oracle oinstall 44627456 10-02 22:05 1_1209_842565593.dbf
-rw-r----- 1 oracle oinstall 42659840 10-02 22:05 1_1210_842565593.dbf
-rw-r----- 1 oracle oinstall 34941440 10-03 03:44 1_1211_842565593.dbf
-rw-r----- 1 oracle oinstall 43660288 10-03 13:00 1_1212_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-03 22:00 1_1213_842565593.dbf
-rw-r----- 1 oracle oinstall 37968384 10-03 22:00 1_1214_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-03 22:06 1_1215_842565593.dbf
-rw-r----- 1 oracle oinstall 34918912 10-03 23:36 1_1216_842565593.dbf
-rw-r----- 1 oracle oinstall 34958848 10-04 05:08 1_1217_842565593.dbf
-rw-r----- 1 oracle oinstall 35235328 10-04 06:00 1_1218_842565593.dbf
-rw-r----- 1 oracle oinstall 35026432 10-04 11:00 1_1219_842565593.dbf
-rw-r----- 1 oracle oinstall 34900480 10-04 14:27 1_1220_842565593.dbf
-rw-r----- 1 oracle oinstall 34898432 10-04 22:18 1_1221_842565593.dbf
-rw-r----- 1 oracle oinstall 35237888 10-05 04:00 1_1222_842565593.dbf
-rw-r----- 1 oracle oinstall 35044864 10-05 07:00 1_1223_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-05 08:08 1_1224_842565593.dbf
-rw-r----- 1 oracle oinstall 42604032 10-05 08:08 1_1225_842565593.dbf
-rw-r----- 1 oracle oinstall 36180480 10-05 10:08 1_1226_842565593.dbf
-rw-r----- 1 oracle oinstall 36866560 10-05 13:00 1_1227_842565593.dbf
-rw-r----- 1 oracle oinstall 35502080 10-05 19:00 1_1228_842565593.dbf
-rw-r----- 1 oracle oinstall 43248128 10-06 01:00 1_1229_842565593.dbf
-rw-r----- 1 oracle oinstall 43502080 10-06 08:09 1_1230_842565593.dbf
-rw-r----- 1 oracle oinstall 42341376 10-06 08:09 1_1231_842565593.dbf
-rw-r----- 1 oracle oinstall 36395520 10-06 13:00 1_1232_842565593.dbf
-rw-r----- 1 oracle oinstall 36211712 10-06 22:00 1_1233_842565593.dbf
-rw-r----- 1 oracle oinstall 36055552 10-06 22:00 1_1234_842565593.dbf
-rw-r----- 1 oracle oinstall 35620352 10-07 03:38 1_1235_842565593.dbf
-rw-r----- 1 oracle oinstall 38476288 10-07 08:09 1_1236_842565593.dbf
-rw-r----- 1 oracle oinstall 43677696 10-07 08:09 1_1237_842565593.dbf
-rw-r----- 1 oracle oinstall 38273536 10-07 13:00 1_1238_842565593.dbf
-rw-r----- 1 oracle oinstall 35530752 10-07 22:00 1_1239_842565593.dbf
-rw-r----- 1 oracle oinstall 35080192 10-07 22:00 1_1240_842565593.dbf
-rw-r----- 1 oracle oinstall 34967552 10-08 03:42 1_1241_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-08 08:10 1_1242_842565593.dbf
-rw-r----- 1 oracle oinstall 41092096 10-08 08:10 1_1243_842565593.dbf
-rw-r----- 1 oracle oinstall 44605952 10-08 13:00 1_1244_842565593.dbf
-rw-r----- 1 oracle oinstall 36656640 10-08 22:00 1_1245_842565593.dbf
-rw-r----- 1 oracle oinstall 34899968 10-08 22:02 1_1246_842565593.dbf
-rw-r----- 1 oracle oinstall 34962944 10-09 03:26 1_1247_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-09 08:11 1_1248_842565593.dbf
-rw-r----- 1 oracle oinstall 43712000 10-09 08:11 1_1249_842565593.dbf
-rw-r----- 1 oracle oinstall 35606528 10-09 12:00 1_1250_842565593.dbf
-rw-r----- 1 oracle oinstall 39093248 10-09 22:00 1_1251_842565593.dbf
-rw-r----- 1 oracle oinstall 37573120 10-09 22:00 1_1252_842565593.dbf
-rw-r----- 1 oracle oinstall 36601856 10-10 08:12 1_1253_842565593.dbf
-rw-r----- 1 oracle oinstall 48173056 10-10 08:12 1_1254_842565593.dbf
-rw-r----- 1 oracle oinstall 34995712 10-10 10:00 1_1255_842565593.dbf
-rw-r----- 1 oracle oinstall 34912256 10-10 16:42 1_1256_842565593.dbf
-rw-r----- 1 oracle oinstall 35211776 10-10 22:00 1_1257_842565593.dbf
-rw-r----- 1 oracle oinstall 35696128 10-11 01:00 1_1258_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-11 08:13 1_1259_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-11 08:13 1_1260_842565593.dbf
-rw-r----- 1 oracle oinstall 41423360 10-11 10:03 1_1261_842565593.dbf
-rw-r----- 1 oracle oinstall 35887104 10-11 14:00 1_1262_842565593.dbf
-rw-r----- 1 oracle oinstall 34922496 10-11 20:46 1_1263_842565593.dbf
-rw-r----- 1 oracle oinstall 34896896 10-12 05:14 1_1264_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-12 08:14 1_1265_842565593.dbf
-rw-r----- 1 oracle oinstall 38900224 10-12 08:14 1_1266_842565593.dbf
-rw-r----- 1 oracle oinstall 35655168 10-12 10:04 1_1267_842565593.dbf
-rw-r----- 1 oracle oinstall 35320832 10-12 10:04 1_1268_842565593.dbf
-rw-r----- 1 oracle oinstall 38813696 10-12 18:04 1_1269_842565593.dbf
-rw-r----- 1 oracle oinstall 35077632 10-13 03:00 1_1270_842565593.dbf
-rw-r----- 1 oracle oinstall 39162368 10-13 08:15 1_1271_842565593.dbf
-rw-r----- 1 oracle oinstall 41152000 10-13 08:15 1_1272_842565593.dbf
-rw-r----- 1 oracle oinstall 34902016 10-13 17:53 1_1273_842565593.dbf
-rw-r----- 1 oracle oinstall 38394368 10-13 22:00 1_1274_842565593.dbf
-rw-r----- 1 oracle oinstall 35054592 10-14 03:38 1_1275_842565593.dbf
-rw-r----- 1 oracle oinstall 36073472 10-14 08:16 1_1276_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-14 08:16 1_1277_842565593.dbf
-rw-r----- 1 oracle oinstall 34903552 10-14 12:03 1_1278_842565593.dbf
-rw-r----- 1 oracle oinstall 37056000 10-14 22:00 1_1279_842565593.dbf
-rw-r----- 1 oracle oinstall 36127232 10-14 22:00 1_1280_842565593.dbf
-rw-r----- 1 oracle oinstall 44211712 10-15 08:17 1_1281_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-15 08:17 1_1282_842565593.dbf
-rw-r----- 1 oracle oinstall 35156992 10-15 12:00 1_1283_842565593.dbf
-rw-r----- 1 oracle oinstall 37207552 10-15 22:00 1_1284_842565593.dbf
-rw-r----- 1 oracle oinstall 35716608 10-15 22:00 1_1285_842565593.dbf
-rw-r----- 1 oracle oinstall 35038720 10-16 07:00 1_1286_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-16 08:18 1_1287_842565593.dbf
-rw-r----- 1 oracle oinstall 34900480 10-16 08:33 1_1288_842565593.dbf
-rw-r----- 1 oracle oinstall 34985984 10-16 18:01 1_1289_842565593.dbf
-rw-r----- 1 oracle oinstall 40562176 10-16 22:00 1_1290_842565593.dbf
-rw-r----- 1 oracle oinstall 35966464 10-17 04:00 1_1291_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-17 08:19 1_1292_842565593.dbf
-rw-r----- 1 oracle oinstall 39884288 10-17 08:19 1_1293_842565593.dbf
-rw-r----- 1 oracle oinstall 34945024 10-17 16:18 1_1294_842565593.dbf
-rw-r----- 1 oracle oinstall 35195392 10-17 22:00 1_1295_842565593.dbf
-rw-r----- 1 oracle oinstall 35144192 10-18 01:00 1_1296_842565593.dbf
-rw-r----- 1 oracle oinstall 34897408 10-18 08:02 1_1297_842565593.dbf
-rw-r----- 1 oracle oinstall 48256000 10-18 08:19 1_1298_842565593.dbf
-rw-r----- 1 oracle oinstall 35259392 10-18 10:10 1_1299_842565593.dbf
-rw-r----- 1 oracle oinstall 35340800 10-18 12:00 1_1300_842565593.dbf
-rw-r----- 1 oracle oinstall 34899456 10-18 19:49 1_1301_842565593.dbf
-rw-r----- 1 oracle oinstall 34998784 10-19 04:54 1_1302_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-19 08:20 1_1303_842565593.dbf
-rw-r----- 1 oracle oinstall 44035584 10-19 08:20 1_1304_842565593.dbf
-rw-r----- 1 oracle oinstall 37701120 10-19 10:01 1_1305_842565593.dbf
-rw-r----- 1 oracle oinstall 35110912 10-19 15:00 1_1306_842565593.dbf
-rw-r----- 1 oracle oinstall 34900992 10-19 22:08 1_1307_842565593.dbf
-rw-r----- 1 oracle oinstall 34902016 10-20 08:51 1_1308_842565593.dbf
-rw-r----- 1 oracle oinstall 35020288 10-20 13:00 1_1309_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-20 22:00 1_1310_842565593.dbf
-rw-r----- 1 oracle oinstall 40890368 10-20 22:00 1_1311_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-20 22:22 1_1312_842565593.dbf
-rw-r----- 1 oracle oinstall 44609024 10-20 22:22 1_1313_842565593.dbf
-rw-r----- 1 oracle oinstall 34900992 10-21 04:23 1_1314_842565593.dbf
-rw-r----- 1 oracle oinstall 34896896 10-21 12:00 1_1315_842565593.dbf
-rw-r----- 1 oracle oinstall 34980352 10-21 15:35 1_1316_842565593.dbf
-rw-r----- 1 oracle oinstall 34902528 10-21 21:03 1_1317_842565593.dbf
-rw-r----- 1 oracle oinstall 38265344 10-21 22:00 1_1318_842565593.dbf
-rw-r----- 1 oracle oinstall 43970560 10-21 22:23 1_1319_842565593.dbf
-rw-r----- 1 oracle oinstall 35324928 10-21 23:00 1_1320_842565593.dbf
-rw-r----- 1 oracle oinstall 34941952 10-22 04:46 1_1321_842565593.dbf
-rw-r----- 1 oracle oinstall784 08-05 09:12 db11g_ora_4690.trc
[oracle@svrdb01 log]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Wed Oct 22 09:00:51 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates.All rights reserved.
connected to target database: DB11G (DBID=312235159)
RMAN> delete archivelog all completed before 'sysdate-7';
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=202 device type=DISK
List of Archived Log Copies for database with db_unique_name DB11G
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
126111266A 12-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1266_842565593.dbf
126211267A 12-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1267_842565593.dbf
126311268A 12-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1268_842565593.dbf
126411269A 12-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1269_842565593.dbf
126511270A 12-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1270_842565593.dbf
126611271A 13-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1271_842565593.dbf
126711272A 13-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1272_842565593.dbf
126811273A 13-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1273_842565593.dbf
126911274A 13-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1274_842565593.dbf
127011275A 13-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1275_842565593.dbf
127111276A 14-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1276_842565593.dbf
127211277A 14-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1277_842565593.dbf
127311278A 14-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1278_842565593.dbf
127411279A 14-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1279_842565593.dbf
127511280A 14-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1280_842565593.dbf
127611281A 14-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1281_842565593.dbf
127711282A 15-OCT-14
Name: /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1282_842565593.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1266_842565593.dbf RECID=1261 STAMP=860746474
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1267_842565593.dbf RECID=1262 STAMP=860753075
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1268_842565593.dbf RECID=1263 STAMP=860753099
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1269_842565593.dbf RECID=1264 STAMP=860781895
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1270_842565593.dbf RECID=1265 STAMP=860814014
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1271_842565593.dbf RECID=1266 STAMP=860832926
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1272_842565593.dbf RECID=1267 STAMP=860832929
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1273_842565593.dbf RECID=1268 STAMP=860867584
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1274_842565593.dbf RECID=1269 STAMP=860882422
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1275_842565593.dbf RECID=1270 STAMP=860902708
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1276_842565593.dbf RECID=1271 STAMP=860919382
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1277_842565593.dbf RECID=1272 STAMP=860919386
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1278_842565593.dbf RECID=1273 STAMP=860933005
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1279_842565593.dbf RECID=1274 STAMP=860968813
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1280_842565593.dbf RECID=1275 STAMP=860968852
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1281_842565593.dbf RECID=1276 STAMP=861005837
deleted archived log
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/1_1282_842565593.dbf RECID=1277 STAMP=861005841
Deleted 17 objects

RMAN>

我的疑惑是[size=11.8181819915771px]
[size=11.8181819915771px]delete archivelog all completed before 'sysdate-7'这条命令,为什么只删除了红色部分.
[size=11.8181819915771px]
[size=11.8181819915771px]我的原意是想把绿色和红色一并删了.

千问 · 2014-7-30 16:25:01

请忽略[size=11.8181819915771px]，论坛自动添加的。

千问 · 2014-7-30 16:25:01

V$ARCHIVED_LOG里边没有绿色的？

千问 · 2014-7-30 16:25:01

1x1xqq_cu 发表于 2014-10-22 09:35
V$ARCHIVED_LOG里边没有绿色的？
恩，对的。
以V$ARCHIVED_LOG这个视图为参考的话，就好理解了。
不过V$ARCHIVED_LOG视图里面日志的保留策略是什么呢，怎么查看它呢？

千问 · 2014-7-30 16:25:01

blzys 发表于 2014-10-22 09:49
恩，对的。
以V$ARCHIVED_LOG这个视图为参考的话，就好理解了。
不过V$ARCHIVED_LOG视图里面日志的保留 ...
我看了下V$ARCHIVED_LOG这个视图，只保留近10天的归档日志。
这个10天的参数，可以在哪里查到呢？

千问 · 2014-7-30 16:25:01

个人觉得，delete archive log ，来源是控制文件，而控制文件存放归档日志的部分是循环使用的，默认应该保留7天，如果控制文件里归档日志信息被覆盖了。那delete自然就删不了了，
而官方文档上说 V$ARCHIVED_LOG 也是读的控制文件，通过这个视图，可以看到控制文件里保存的归档日志的情况。这里没看到，说明控制文件里确实没有那些归档日志的信息了

千问 · 2014-7-30 16:25:01

我在一本书上看到：
控制文件包含近期的归档日志信息。这个近期于我的库来讲，就是10天吧。

千问 · 2014-7-30 16:25:01

看来绿色部分已经不在oracle管控范围内了，可以直接os命令腾出空间了。

千问 · 2014-7-30 16:25:01

1x1xqq_cu 发表于 2014-10-22 09:53
个人觉得，delete archive log ，来源是控制文件，而控制文件存放归档日志的部分是循环使用的，默认应该保 ...
SQL> show parameter control
NAME
TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time
integer 7
参数显示是7，但v$archived_log为什么会有12日以来的，也就是10天？

千问 · 2014-7-30 16:25:01

blzys 发表于 2014-10-22 10:09
SQL> show parameter control
NAME
TYPE VALUE
控制文件的内容分为可变内容和不可变内容。参数control_file_record_keep_time是对于可变内容来说的。这个参数默认值是7天，它的意思不是说控制文件只保留7天内的信息，而是分为两种情况：
1.如果控制文件足够大的话，那么即使里面的信息超过7天了也不会被删除，因为还有足够的空间去存放这些信息。
2.如果控制文件不够大的话，现在又要将新的内容放进去，那么就要从控制文件中删除掉一些信息来存放新的信息，那么要删除哪些信息呢？这时候就是control_file_record_keep_time这个参数的用处了，它会选择将那些超过或者接近control_file_record_keep_time的值的内容删除，来存放新的内容。