用RMAN备份archivelog加delete input是真的能删除操作系统的ARCHIVELOG?

显示全部楼层 · 2006-4-12 17:47:49

该环境如下:
SQL> show parameter archive
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
archive_lag_target
integer 0
log_archive_dest
string
log_archive_dest_1
stringLOCATION=g:\oracle\oradata\AX0

3\archive
log_archive_dest_10
string
log_archive_dest_2
stringLOCATION=h:\oracle\oradata\AX0

3\archive
两个archive destination.

RMAN> list backup of archivelog from sequence 14450 until sequence 14453;

List of Backup Sets
===================
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
62183060MSBT_TAPE00:00:57 13-MAR-07
BP Key: 621831 Status: AVAILABLE Tag: TAG20070313T140021
Piece Name: SZHSVR044_AX03_set=12482_piece=1_date=20070313.ARC.rmn
List of Archived Logs in backup set 621830
Thrd Seq Low SCNLow TimeNext SCN Next Time
---- ------- ---------- --------- ---------- ---------
114450 34843530813-MAR-07 34851590013-MAR-07
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
621888241M SBT_TAPE00:00:30 13-MAR-07
BP Key: 621889 Status: AVAILABLE Tag: TAG20070313T160024
Piece Name: SZHSVR044_AX03_set=12484_piece=1_date=20070313.ARC.rmn
List of Archived Logs in backup set 621888
Thrd Seq Low SCNLow TimeNext SCN Next Time
---- ------- ---------- --------- ---------- ---------
114450 34843530813-MAR-07 34851590013-MAR-07
114451 34851590013-MAR-07 34855031613-MAR-07
114452 34855031613-MAR-07 34864729313-MAR-07
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
62447599MSBT_TAPE00:00:18 13-MAR-07
BP Key: 624476 Status: AVAILABLE Tag: TAG20070313T193912
Piece Name: SZHSVR044_AX03_set=12494_piece=1_date=20070313.ARC.rmn
List of Archived Logs in backup set 624475
Thrd Seq Low SCNLow TimeNext SCN Next Time
---- ------- ---------- --------- ---------- ---------
114453 34864729313-MAR-07 34872435713-MAR-07
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
62450599MSBT_TAPE00:00:27 13-MAR-07
BP Key: 624506 Status: AVAILABLE Tag: TAG20070313T203656
Piece Name: SZHSVR044_AX03_set=12497_piece=1_date=20070313.ARC.rmn
List of Archived Logs in backup set 624505
Thrd Seq Low SCNLow TimeNext SCN Next Time
---- ------- ---------- --------- ---------- ---------
114453 34864729313-MAR-07 34872435713-MAR-07
然后查看备份记录，发现archivelog是完整的，也就是说备份已经成功，且接下来的"DELETE INPUT"应该可以正常执行。
可是sequence为14450和14452的日志仍在主机上，没有被删除。
我的备份命令如下:
RMAN> run
{
backup archivelog all delete input format 'ZHSVR044_%d_set=%s_piece=%p_date=%T.ARC.rmn';
}
使用CATALOG, 备份工具为TSM (tivoli 5.2)
请前辈点播。谢谢

千问 · 2006-4-12 17:47:49

你有两个dest，你看到存在的只是其中一个。删除的应该是另一个。

千问 · 2006-4-12 17:47:49

有的ARCHIVELOG确实同时存在于两个destination里，正常的情况一样是一个完全删除，另一个存在。

千问 · 2006-4-12 17:47:49

改成DELETE ALL INPUT 试试。

千问 · 2006-4-12 17:47:49

版主说的甚是

千问 · 2006-4-12 17:47:49

但是这样有一个问题：
WARNING: archive log not deleted, not yet applied by standby
请问是否delete input会兼顾standby archived log applying. 而delete all input则强制删除?
“all” 这个选项带来了哪些改变? 谢谢大师。

千问 · 2006-4-12 17:47:49

std数据库recover结束后这个归档就会被删掉了

千问 · 2006-4-12 17:47:49

会吗? 我想还是测试一下吧。另外可能还要考虑DATAGUARD的模式，是maximum available, 还是maximum performance吧。

千问 · 2006-4-12 17:47:49

rman target / catalog rman/rman@catdb<< !!
crosscheck archivelog all;
run{
backup format '/orabak/oradata/db_%u_%d_%s'database;
}
run{
backup format '/orabak/oradata/ar_%t_%s_%p'archivelog all delete all input;
}
exit

!!

千问 · 2006-4-12 17:47:49

学习中。。。