| |
1, dbca building a database back-end error description of the problem
[Root @ companydb1 rpms] # find / -name * alert * log
/mnt/resource/app/Oracle/diag/rdbms/strora/strora/trace/alert_strora.log
/mnt/resource/app/oracle/product/11.2.0/dbhome_1/log/diag/rdbms/dbua0/DBUA0/trace/alert_DBUA0.log
/mnt/resource/app/oracle/product/11.2.0/dbhome_1/oc4j/j2ee/oc4j_applications/applications/em/em/database/instance/alertlog
[Root @ companydb1 rpms] # tail -f /mnt/resource/app/oracle/diag/rdbms/strora/strora/trace/alert_strora.log
3. Add disk space and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
system command was used to delete files, then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
************************************************** **********************
Errors in file /oracle/app/oracle/diag/rdbms/strora/strora/trace/strora_arc0_17846.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: can not reclaim 15883776 bytes disk space from 5218762752 limit
ARC0: Error 19809 Creating archive log file to '/oracle/app/oracle/flash_recovery_area/strora/archivelog/2015_10_21/o1_mf_1_280_%u_.arc'
^ C
[Root @ companydb1 rpms] #
2, delete the old one solution rman archive
Enter rman delete the old archive log
RMAN> delete archivelog all;
RMAN> crosscheck archivelog all;
3, the second expansion of the space limitations archiving solutions
First, find the location of archive files
SQL> show parameter background_dump_dest;
NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
background_dump_dest string / oracle / app / oracle / diag / rdbms /
strora / strora / trace
SQL>
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 280
Next log sequence to archive 280
Current log sequence 282
SQL>
You can see archive log location is DB_RECOVERY_FILE_DEST, precise path can also be found in
View space usage:
SQL> SELECT * FROM V $ RECOVERY_FILE_DEST;
NAME
-------------------------------------------------- ------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ------------ ---
/ Oracle / app / oracle / flash_recovery_area
5218762752 52080363520143
SQL>
Then you can increase db_recovery_file_dest_size
SQL> alter system set db_recovery_file_dest_size = 16G;
System altered. |
|
|
|