DB archiver full error in "db_recovery_file_dest_size"=10g with RMAN script fault
Hi all:
I've posted it this topic when I encounter 'archive full' error in database with 'db_recovery_file_dest_size' set to 10GB and disk have 50+GB free. I posted it here:
Original set in init ORA parameter to be:
*.db_recovery_file_dest_size=10737418240
*.db_recovery_file_dest='/orabackup/flash_recovery_area'
file system usage: (notice '/orabackup' has 50+ GB free)
[oracle@]$df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sdd1 247G 184G 51G 79% /orabackup
Developer received error of 'archiver full' so his remote login failed. However, we have 'db_recovery_file_dest_size' set to 10g, and it goes to '/orabackup/flash_recovery_area/SID/'... with '/orabackup' has 50+GB free! Developer is loading simple data, 5K rows, no LONG, RAW, LOB data type.
I've posted it this topic when I encounter 'archive full' error in database with 'db_recovery_file_dest_size' set to 10GB and disk have 50+GB free. I posted it here:
Original set in init ORA parameter to be:
*.db_recovery_file_dest_size=10737418240
*.db_recovery_file_dest='/orabackup/flash_recovery_area'
file system usage: (notice '/orabackup' has 50+ GB free)
[oracle@]$df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sdd1 247G 184G 51G 79% /orabackup
Developer received error of 'archiver full' so his remote login failed. However, we have 'db_recovery_file_dest_size' set to 10g, and it goes to '/orabackup/flash_recovery_area/SID/'... with '/orabackup' has 50+GB free! Developer is loading simple data, 5K rows, no LONG, RAW, LOB data type.
0