oracle数据库查看归档路径,系统提示归档目录满，请教如何在ORACLE下查询空间占用情况？...

Errors in file /export/home/oracle/product/10.2/admin/omcr/bdump/omcr_arc1_22894.trc:

ORA-19815: 警告: db_recovery_file_dest_size 字节 (共 10737418240 字节) 已使用 100.00%, 尚有 0 字节可用。

Thu Jul 13 10:46:16 2006

************************************************************************

You have following choices to free up space from flash recovery area:

1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

then consider changing RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such as tape using RMAN

BACKUP RECOVERY AREA command.

3. Add disk space and increase db_recovery_file_dest_size parameter to

reflect the new space.

4. Delete unnecessary files using RMAN DELETE command. If an operating

system command was used to delete files, then use RMAN CROSSCHECK and

DELETE EXPIRED commands.

************************************************************************

ARC1: Failed to archive thread 1 sequence 139 (19809)

ARCH: Archival stopped, error occurred. Will continue retrying

Thu Jul 13 10:46:16 2006

ORACLE Instance omcr - Archival Error

Thu Jul 13 10:46:16 2006

ORA-16038: 日志 1 序列号 139 无法归档

ORA-19809: 超出了恢复文件数的限制

ORA-00312: 联机日志 1 线程 1: '/oradb/omcr/redo01.log'

Thu Jul 13 10:46:16 2006

Errors in file /export/home/oracle/product/10.2/admin/omcr/bdump/omcr_arc1_22894.trc:

ORA-16038: 日志 1 序列号 139 无法归档

ORA-19809: 超出了恢复文件数的限制

ORA-00312: 联机日志 1 线程 1: '/oradb/omcr/redo01.log'

Thu Jul 13 10:47:07 2006

ARC0: Archiving not possible: No primary destinations

ARC0: Failed to archive thread 1 sequence 139 (4)

ARCH: Archival stopped, error occurred. Will continue retrying

Thu Jul 13 10:47:07 2006

ORACLE Instance omcr - Archival Error

Thu Jul 13 10:47:07 2006

ORA-16014: 日志 1 的序列号 139 未归档, 没有可用的目的地

ORA-00312: 联机日志 1 线程 1: '/oradb/omcr/redo01.log'

Thu Jul 13 10:47:07 2006

Errors in file /export/home/oracle/product/10.2/admin/omcr/bdump/omcr_arc0_22892.trc:

ORA-16014: 日志 1 的序列号 139 未归档, 没有可用的目的地

ORA-00312: 联机日志 1 线程 1: '/oradb/omcr/redo01.log'

ARC0: Archiving not possible: No primary destinations

ARC0: Failed to archive thread 1 sequence 139 (4)