oracle 规范与存储库中的任何备份都不匹配
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/21668713/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
specification does not match any backup in the repository
提问by Ron
i want to delete arhcivelog on my DB oracle.
我想删除我的数据库 oracle 上的 archcivelog。
RMAN> list backup of archivelog all;
specification does not match any backup in the repository
it seems there is not any of them.
似乎没有他们中的任何一个。
but the recovery area is not empty.
但恢复区不是空的。
SELECT * FROM V$RECOVERY_FILE_DEST;
name space_limit space_used space_reclaimable number of files
/opt/oracle/recovery_area 21474836480 10529677312 0 8
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 2081
Current log sequence 2083
what's wrong in my oracle? how to delete all archivelog?
我的预言机出了什么问题？如何删除所有归档日志？
Thanks a lot.
非常感谢。
采纳答案by soulemane moumie
Delete all archivelog on disk no matter wether they are backed up or not
删除磁盘上的所有归档日志，无论它们是否备份
RMAN > delete archivelog all;
Delete all archivelog on disk no matter wether they are backed up or not having one day old.
删除磁盘上的所有存档日志，无论它们是否已备份或没有一天。
RMAN > delete archivelog all completed before ‘sysdate -1′;
回答by vivek
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=47 device type=DISK
specification does not match any archived log in the repository
回答by ali yousef
RMAN> delete archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=6 device type=DISK
specification does not match any archived log in the repository
