查看归档目录的使用情况
SYS@lhrrac11> select * from v$recovery_file_dest;
SYS@lhrrac11> select * from v$flash_recovery_area_usage;
SYS@lhrrac11> show parameter db_recovery_file_dest
归档扩容
当归档空间不足时,或者有类似ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.报错时,可以使用以下命令为归档目录扩容:
SYS@lhrrac11> show parameter db_recovery_file_dest