14:51:16 SYS@ssbm2>>alter database add logfile thread 2 group 3 size 200M;
alter database add logfile thread 2 group 3 size 200M
*
ERROR at line 1:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 210763776 bytes disk space from 5344591872 limit
Elapsed: 00:00:00.57
此时所有节点的日志组的信息是
节点1: 200M*5+50M*2 总共:1G
节点2:200M*5+50M*2 总共 1G
节点3:200M*7 总共:1.4G
节点4:200M*7 总共:1.4G
现在想做的是把节点1,2,两组50M的日志组删掉,然后建成200M的日志组。
14:52:14 SYS@ssbm2>>show parameter recover
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +DATA
db_recovery_file_dest_size big integer 5097M
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0
14:52:49 SYS@ssbm2>>alter system set db_recovery_file_dest_size=50G
14:53:03 2 ;
System altered.
Elapsed: 00:00:00.07
14:53:04 SYS@ssbm2>>show parameter recover
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +DATA
db_recovery_file_dest_size big integer 50G
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0
14:53:11 SYS@ssbm2>>alter database add logfile thread 2 group 3 size 200M;
Database altered.
Elapsed: 00:00:01.06
延伸问题:FRA的大小与日志组大小之间的关系!
猜测:日志组的大小不能超过FRA的大小。