Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ DBCA Error: ORA-19809: limit exceeded for recovery files process     - MogileFS system installation configuration example (Server)

- SQL statement to repair SQL Server database (Database)

- After reloading the cinder-volume OpenStack not start properly (Server)

- Efficient Linux Shell - Shell special characters Summary (Linux)

- Five useful commands to manage file types and system time in linux (Linux)

- Android application simulates the phone keypad (Programming)

- About enhanced Linux / Unix server system security program (Linux)

- LaTeX Getting Started Tutorial (Linux)

- MySQL migration tool used in the production environment (Database)

- Linux System Getting Started Tutorial: how to find information on Linux-embedded module (Linux)

- Zabbix monitoring Oracle Database use Orabbix plug (Enhanced Edition) (Database)

- Java static internal class (Programming)

- Linux static library generated Guide (Programming)

- Docker in the development and practice of IFTTT (Server)

- Automatic batch resolve dependencies problem locally installed rpm package (Linux)

- Linux System Tutorial: Ubuntu on the desktop is disabled by default keyring to unlock tips (Linux)

- Different versions of MongoDB achieve master-slave replication (Database)

- After VMware CentOS full VM clone the network card is unavailable Solutions (Linux)

- The oh-my-zsh into true my zsh (Linux)

- 64-bit Oracle Linux recompiled Hadoop-2.2.0 (Server)

 
         
  DBCA Error: ORA-19809: limit exceeded for recovery files process
     
  Add Date : 2017-08-31      
         
         
         
  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.
     
         
         
         
  More:      
 
- Linux systems use IP masquerading anti-hacker (Linux)
- Linux Command Tutorial: Ubuntu apt-get command (Linux)
- Android system source code and compile the kernel source code (Programming)
- Spacewalk Linux system configuration and installation (Linux)
- Linux Powerful command Awk Introduction (Linux)
- The lambda expression Java8 (constructor references) (Programming)
- Linux disk quota-related instruction (Linux)
- C ++ thread creates transmission parameters are changed (Programming)
- Python format string (Programming)
- The virtual memory (Linux)
- How do I upgrade to Ubuntu 15.04 (Beta) (Linux)
- Redis 3.0.3 Cluster Setup (Database)
- Protobuf compiled and used on the Ubuntu 14.04 (Programming)
- The wrong in Linux: too many open files (Linux)
- React Getting Started Tutorial (Linux)
- jQuery get value drop-down list and select text (Programming)
- Hadoop - Task Scheduling System Comparison (Server)
- systemctl Command Complete Guide (Linux)
- CentOS 6.5 Linux System Customization and Packaging Quick Implementation Script (Linux)
- tar command to extract a file error: stdin has more than one entry (Linux)
     
           
     
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.