oracle备库使用oratop报错ora-01476的解决办法

mahan

参考官网文档

Utility Oratop Fails With ORA-01476 (Doc ID 2941209.1)

Applies to:
Oracle Database - Enterprise Edition - Version 19.1.0.0.0 and later
Information in this document applies to any platform.
Symptoms
The command oratop is failed caused by ORA-01476 as below:

./oratop -i 10 / as sysdba

oratop: Release 16.5.1 Production on Sun Dec 11 10:30:00 CST 2022
Copyright (c) 2011, Oracle. All rights reserved.

Connecting
ORA-01476: divisor is equal to zero
Error - database not open.

Changes
Upgraded to 19c.

Cause
The below SQL is included into oratop utility from 19c:

SELECT
  (SPACE_USED - SPACE_RECLAIMABLE) / SPACE_LIMIT * 100 fra
FROM
  V$RECOVERY_FILE_DEST
If the value of V$RECOVERY_FILE_DEST.SPACE_LIMIT is 0(after configure Fast Recovery Area, then dis-configure it), the above SQL will fail by error ORA-01476.



Solution
Setting parameter db_recovery_file_dest_size to a non-zero value.