ORA-19815: WARNING: string of string bytes is string%% used, and has string remaining bytes available. Cause: DB_RECOVERY_FILE_DEST is running out of disk space. Action: One of the following:1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.2. Backup files to tertiary device using RMAN.3. Consider changing RMAN retention policy.4. Consider changing RMAN archivelog deletion policy.5. Delete files from recovery area using RMAN. 只做了第一项,其他的都进行不下去。 帮看看如何处理?
多半是闪回区问题了,一般来说,闪回区不足,可能hang住数据库。 设置闪回区大小:alter system set db_recovery_file_dest_size=10G
使用环境:solaris 10
ORA-19815、ORA-07444、ORA-19809、ORA-19804错误
WARNING: string of string bytes is string%% used, and has string remaining bytes available.
Cause: DB_RECOVERY_FILE_DEST is running out of disk space.
Action: One of the following:1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.2. Backup files to tertiary device using RMAN.3. Consider changing RMAN retention policy.4. Consider changing RMAN archivelog deletion policy.5. Delete files from recovery area using RMAN.
只做了第一项,其他的都进行不下去。
帮看看如何处理?
设置闪回区大小:alter system set db_recovery_file_dest_size=10G