Ora-00257:archiver error. Connect internal only, until freed

Source: Internet
Author: User
Tags imagecopy

1, User connection error
Sql> conn Scott/[email protected];
ERROR:
Ora-00257:archiver error. Connect internal only, until freed. --Archive error (log space full)

Rman joins the same error in the form of catalog.

2, check the use of Flash_recovery_area_usage
Sql> Conn/as sysdba;
Connected.

Sql> Show parameter log_archive_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
Log_archive_dest string
Log_archive_dest_1 string
Log_archive_dest_10 string
Log_archive_dest_2 string
Log_archive_dest_3 string
Log_archive_dest_4 string
Log_archive_dest_5 string
......

Sql> select * from V$flash_recovery_area_usage;

File_type percent_space_used percent_space_reclaimable Number_of_files
------------ ------------------ ------------------------- ---------------
Controlfile 0 0 0
Onlinelog 0 0 0
ARCHIVELOG 99.6.51 50
Backuppiece. 33 0 1
Imagecopy 0 0 0
Flashbacklog 0 0 0

6 rows selected.


3. Clear some logs---use Rman to clear the log
[Email protected] orcl]$ Rman target sys/12345

Recovery manager:release 10.2.0.1.0-production on Mon Jan 5 14:51:36 2015

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to target DATABASE:ORCL (dbid=1379778111)

Rman> crosscheck Archivelog All; ---Check with this command first

rman> Delete expired Archivelog all;--Deleting an expired log

Released Channel:ora_disk_1
Allocated Channel:ora_disk_1
Channel ora_disk_1:sid=124 Devtype=disk
Specification does not match no archive log in the recovery Catalog-no expiration log

rman> Delete Archivelog until Time "to_date (' 2015-01-01 23:00:00 ', ' yyyy-mm-dd hh24:mi:ss ')"; --Delete the log before the specified log

Released Channel:ora_disk_1
Allocated Channel:ora_disk_1
Channel ora_disk_1:sid=124 Devtype=disk

List of archived Log Copies
Key thrd Seq S Low Time Name
------- ---- ------- - --------- ----
1 1 1209 A 24-dec-14/home/oracle/oracle/flash_recovery_area/orcl/archivelog/2014_12_24/o1_mf_1_1209_b9o2yclz_.arc
......

4. View Flash_recovery_area_usage Usage
Sql> select * from V$flash_recovery_area_usage;

File_type percent_space_used percent_space_reclaimable Number_of_files
------------ ------------------ ------------------------- ---------------
Controlfile 0 0 0
Onlinelog 0 0 0
ARCHIVELOG 34.72 0 17
Backuppiece. 33 0 1
Imagecopy 0 0 0
Flashbacklog 0 0 0

6 rows selected.

5, connect Sqlplus normal again

Ora-00257:archiver error. Connect internal only, until freed

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.