归档空间满了，如何删除归档日志？

myseasky2007

$ rman target sys/oracle
rman> delete archivelog all;

晶晶小妹

给你看我已前写的一个例子，删除12个小时前的归档：
#!/bin/bash
rman target / <<EOF
  delete  noprompt   archivelog until time='sysdate-12/24';
exit;
EOF

sqysl

你这是删除的RMAN里的归档信息，并未没删除数据库服务器节点上的归档，而且，这连RMAN备份的物理文件都未删除。

Yong Huang

原帖由 sqysl 于 2009-9-22 03:28 发表
你这是删除的RMAN里的归档信息，并未没删除数据库服务器节点上的归档，而且，这连RMAN备份的物理文件都未删除。

RMAN command "delete archivelog" physically deletes archivelog files in addition to the record in the catalog. Maybe very old version of RMAN does not do that? I tested in 10.2.0.1 and it worked.

Yong Huang

sqysl

SORRY,看错了，看成DELETE EXPIRED。。。了。
YONGHUANG，您删除的是数据库上的ARCHIVELOGS吗？不是RMAN备份的ARCHIVELOGS吧？因为我看到ORACLE11G里的资料，说的有些模糊：
DELETE...:
To delete backups, update the control file records to status DELETED, and remove their records from the recovery catalog (if a recovery catalog is used).

You can specify that DELETE should remove backups that are EXPIRED or OBSOLETE. If you run DELETE EXPIRED on a backup that exists, then RMAN issues a warning and does not delete the backup. If you use the DELETE command with the optional FORCE keyword, then RMAN deletes the specified backups, but ignores any I/O errors, including those that occur when a backup is missing from disk or tape. It then updates the RMAN repository to reflect the fact that the backup is deleted, regardless of whether RMAN was able to delete the file or whether the file was already missing.

RMAN uses all configured channels to perform the deletion. If you use DELETE for files on devices that are not configured for automatic channels, then you must use ALLOCATE CHANNEL FOR MAINTENANCE. For example, if you made a backup with an SBT channel, but only a disk channel is configured, then you must manually allocate an SBT channel for DELETE. An automatic or manually allocated maintenance channel is required when you use DELETE on a disk-only file.
从上面这段资料看，RMAN DELETE只能删除备份信息库和备份集合。

Yong Huang

> 您删除的是数据库上的ARCHIVELOGS吗？不是RMAN备份的ARCHIVELOGS吧？

Yes, the actual archivelog files are deleted. You can find their paths from v$archived_log.name. Use OS command (dir or ls) to see them. Launch RMAN, type "delete archivelog all;" or "delete archivelog 'fullpathtoanarchivelogfile';". Check the OS level files again.

Yong Huang

sqysl

谢谢YONGHUANG回复，回头实验一下。

Coast_lichao

ok

keor

支持下8楼。。。