db_recovery_file_dest_size of 37580963840 bytes is 98.29% used and has 644202496 remaining bytes ava
edited Dec 8, 2011 4:32AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 10 commentsAnswered ✓
Hi experts.
I have this situation. Dba is on vacation, I don't know what to do. I cant'see any scripts dealing with the db_recovery_dest files.
What we use is a script for archives show below:
db_recovery_file_dest
string /gateprd/ARCHIVE/fra
db_recovery_file_dest_size
big integer 35G
db_recovery_file_dest_size of 37580963840 bytes is 98.29% used and has 644202496 remaining bytes available.
/home/oracle/dba/scripts> more rmovarch.sh
#!/bin/ksh
# compress /gateprd/ARCHIVE/*.arc
find /gateprd/ARCHIVE/*.arc -type f ! -mtime -1 -exec echo {} > /
home/oracle/dba/lists/ARCHIVElist \;
if test $(cat /home/oracle/dba/lists/ARCHIVElist|wc -l) -gt 0
I have this situation. Dba is on vacation, I don't know what to do. I cant'see any scripts dealing with the db_recovery_dest files.
What we use is a script for archives show below:
db_recovery_file_dest
string /gateprd/ARCHIVE/fra
db_recovery_file_dest_size
big integer 35G
db_recovery_file_dest_size of 37580963840 bytes is 98.29% used and has 644202496 remaining bytes available.
/home/oracle/dba/scripts> more rmovarch.sh
#!/bin/ksh
# compress /gateprd/ARCHIVE/*.arc
find /gateprd/ARCHIVE/*.arc -type f ! -mtime -1 -exec echo {} > /
home/oracle/dba/lists/ARCHIVElist \;
if test $(cat /home/oracle/dba/lists/ARCHIVElist|wc -l) -gt 0
0