ORA-19809 & amp; ORA-03113

Source: Internet
Author: User

Idle> startup
The ORACLE routine has been started.
Total System Global Area 3407261696 bytes
Fixed Size 2180504 bytes
Variable Size 2348812904 bytes
Database Buffers 1040187392 bytes
Redo Buffers 16080896 bytes

The database has been loaded.

ORA-03113: End of the file for the communication channel

Process ID 6416

Session ID: 5 serial number: 3

View alarm logs:
**************************************** ********************************
Errors in file d: \ app \ lenovo \ diag \ rdbms \ orcl \ trace \ orcl_arc1_1_2.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 14319616 bytes disk space from 4102029312 limit
ARC1: Error 19809 Creating archive log file to 'd: \ APP \ LENOVO \ FLASH_RECOVERY_AREA \ ORCL \ ARCHIVELOG \ 2013_12_29 \ O1_MF_1_284 _ % U_.ARC'
Errors in file d: \ app \ lenovo \ diag \ rdbms \ orcl \ trace \ orcl_ora_5368.trc:
ORA-19815 :?? : Db_recovery_file_dest_size ?? (? 4102029312 ??) ??? 100.00% ,?? 0 ?????
**************************************** ********************************

Official reasons and solutions:
ORA-19809: limit exceeded for recovery files
Cause: The limit for recovery files specified by the DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Action: There are five possible solutions: 1) Take frequent backup of recovery area using RMAN. 2) Consider changing RMAN retention policy. 3) Consider changing RMAN archived log deletion policy. 4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE. 5) Delete files from recovery area using RMAN.

The fourth solution is used here:
Idle> startup nomount;

The ORACLE routine has been started.
Idle> alter system set db_recovery_file_dest_size = 8g scope = both;

The system has been changed.
Idle> shutdown immediate;
ORA-01507 :??????

The ORACLE routine has been disabled.
Idle> startup

The ORACLE routine has been started.
Total System Global Area 3407261696 bytes
Fixed Size 2180504 bytes
Variable Size 2348812904 bytes
Database Buffers 1040187392 bytes
Redo Buffers 16080896 bytes

The database has been loaded.

The database has been opened.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.