Problém 50:
Nelze provést zálohu, díky neadekvátně nastavenému parametru db_recovery_file_dest_size… piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\MIGDB\BACKUPSET\2011_06_24\O1_MF_NCSNF_TAG20110624T131429_708WGV5N_.BKP tag=TAG20110624T131429 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of backup plus archivelog command at 06/24/2011 13:15:39RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/24/2011 13:15:35ORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 52428800 bytes disk space from 2147483648 limit
Řešení:
Analýza:SQL> set lines 100SQL> col name format a60SQL> select name 2 , floor(space_limit / 1024 / 1024) „Size MB“ 3 , ceil(space_used / 1024 / 1024) „Used MB“ 4 from v$recovery_file_dest 5 order by name 6 /NAME Size MB Used MB————————————————-C:\oracle\flash_recovery_area 2048 1157SQL> alter system set db_recovery_file_dest_size=10G scope=both 2 /System altered.SQL> set lines 100SQL> col name format a60SQL> select name 2 , floor(space_limit / 1024 / 1024) „Size MB“ 3 , ceil(space_used / 1024 / 1024) „Used MB“ 4 from v$recovery_file_dest 5 order by name 6 /NAME Size MB Used MB————————————————-C:\oracle\flash_recovery_area 10240 1157A vše již funguje správně:piece handle=C:\ORACLE\FLASH_RECOVERY_AREA\MIGDB\BACKUPSET\2011_06_24\O1_MF_ANNNN_TAG20110624T131957_708WPXPP_.BKP tag=TAG20110624T131957 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 24-JUN-11