Problém 60:
Může vás překvapit chyba RMANa o tom, že nemáte dostatek místa pro uložení záloh i když to není pravda.
Ve skutečnosti je problém v nastavení parametru db_recovery_file_dest_size, který má nižší hodnotu než potřebujete pro uložení full zálohy.
channel ORA_DISK_1: starting piece 2 at 03-DEC-11
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 12/03/2011 11:30:49
ORA-19809: pro soubory obnovy byl prekrocen limit
ORA-19804: nelze ziskat zpet 52428800 bajtu diskoveho prostoru z limitu 4294967296
Řešení:
oracle@dbsrv:/data/oracle/flash_recovery_area/TEST/backupset/2011_12_03> sqlplus / as sysdba
SQL*Plus: Release 10.1.0.5.0 – Production on Sat Dec 3 11:40:09 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Pripojeno k:
Oracle Database 10g Release 10.1.0.5.0 – Production
SQL> set lines 100
col name format a60
select name
, floor(space_limit / 1024 / 1024) “Size MB”
, ceil(space_used / 1024 / 1024) “Used MB”
from v$recovery_file_dest
order by name
/SQL>
NAME Size MB Used MB
———————————————————— ———- ———-
/data/oracle/flash_recovery_area 4096 45
SQL> exit
Odpojeno od Oracle Database 10g Release 10.1.0.5.0 – Production
oracle@dbsrv:/data/oracle/flash_recovery_area/TEST/backupset/2011_12_03> df -h /data/oracle/flash_recovery_area
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d1p1 401G 57G 324G 15% /data
oracle@dbsrv:/data/oracle/flash_recovery_area/TEST/backupset/2011_12_03> sqlplus / as sysdba
SQL*Plus: Release 10.1.0.5.0 – Production on Sat Dec 3 11:41:02 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Pripojeno k:
Oracle Database 10g Release 10.1.0.5.0 – Production
SQL> alter system set db_recovery_file_dest_size=300G scope=both;
System zmenen.
SQL> set lines 100
col name format a60
select name
, floor(space_limit / 1024 / 1024) “Size MB”
, ceil(space_used / 1024 / 1024) “Used MB”
from v$recovery_file_dest
order by name
/SQL>
NAME Size MB Used MB
———————————————————— ———- ———-
/data/oracle/flash_recovery_area 307200 45