db_recovery_file_dest_size: user-specified limit
节点告警信息:
This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup
原因
每次rman 备份都是备份到archdg 闪回盘 总共20G 上面说的意思是说用了闪回去53%的空间,告警我
做实验
1 自动rman备份 看 是不是备份到闪回去 猜想 可能是asm的omf
2 手动自动 +data/数据库名字/arch路径 看看 查看闪回去占用情况
参考
Hi expert,
in my alert log i'm seeing this message. This after I add on 1gb to my recovery file dest.
in my alert log i'm seeing this message. This after I add on 1gb to my recovery file dest.
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 2G scope = both;
this is the message:
db_recovery_file_dest_size of 2048 MB is 49.54% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
what's it? my istance is in archivelog, but the path /oradata/data07/archive is empty
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/data07/archive
Oldest online log sequence 7120
Next log sequence to archive 7122
Current log sequence 7122
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 49.54 0 16
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL>
SQL> show parameter DB_RECOVERY_FILE_DEST;
NAME TYPE VALUE
------------------------------------ -------------------------------- ----------------------------
db_recovery_file_dest string /oradata/data01/flash_recov
ery_area
db_recovery_file_dest_size big integer 2G
SQL> show parameter DB_FLASHBACK_RETENTION_TARGET;
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_flashback_retention_target integer 1440
many thanks for all suggest.
SQL> col name format a30
SQL> set pagesize 6000
SQL> set linesize 500
SQL> col name format a30
SQL> col value format a35
SQL> select name, value from v$parameter where name like 'db_recovery_%';
NAME VALUE
------------------------------ -----------------------------------
db_recovery_file_dest +ARCHDG
db_recovery_file_dest_size
21474836480
select flashback_on from v$database;
select name, floor(space_limit/1024/1024) "Size_MB", ceil(space_used/1024/1024) "Used_MB" from v$recovery_file_dest order by name
节点告警信息:
This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup
原因
每次rman 备份都是备份到archdg 闪回盘 总共20G 上面说的意思是说用了闪回去53%的空间,告警我
做实验
1 自动rman备份 看 是不是备份到闪回去 猜想 可能是asm的omf
2 手动自动 +data/数据库名字/arch路径 看看 查看闪回去占用情况
参考
Hi expert,
in my alert log i'm seeing this message. This after I add on 1gb to my recovery file dest.
in my alert log i'm seeing this message. This after I add on 1gb to my recovery file dest.
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 2G scope = both;
this is the message:
db_recovery_file_dest_size of 2048 MB is 49.54% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
what's it? my istance is in archivelog, but the path /oradata/data07/archive is empty
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oradata/data07/archive
Oldest online log sequence 7120
Next log sequence to archive 7122
Current log sequence 7122
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE 0 0 0
ONLINELOG 0 0 0
ARCHIVELOG 49.54 0 16
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL>
SQL> show parameter DB_RECOVERY_FILE_DEST;
NAME TYPE VALUE
------------------------------------ -------------------------------- ----------------------------
db_recovery_file_dest string /oradata/data01/flash_recov
ery_area
db_recovery_file_dest_size big integer 2G
SQL> show parameter DB_FLASHBACK_RETENTION_TARGET;
NAME TYPE VALUE
------------------------------------ -------------------------------- ------------------------------
db_flashback_retention_target integer 1440
many thanks for all suggest.
SQL> col name format a30
SQL> set pagesize 6000
SQL> set linesize 500
SQL> col name format a30
SQL> col value format a35
SQL> select name, value from v$parameter where name like 'db_recovery_%';
NAME VALUE
------------------------------ -----------------------------------
db_recovery_file_dest +ARCHDG
db_recovery_file_dest_size
21474836480
select flashback_on from v$database;
select name, floor(space_limit/1024/1024) "Size_MB", ceil(space_used/1024/1024) "Used_MB" from v$recovery_file_dest order by name
ORA-19527与ORA-00312和db_recovery_file_dest_size of 2048 MB is 0.00% used
2012-08-21 14:42:19