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