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

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

The reason is that the log is full, according to the above URL provides the steps to be able to delete the partial archive log.

1. First view current Flash recovery area usage

C:\windows\system32>sqlplus Sys/[email protected] as Sysdba

Sql*plus:release 11.2.0.1.0 Production on Wednesday September 4 18:08:48 2013

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

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the partitioning, OLAP, Data Mining and Real application testing options

Sql> Show parameter log_archive_dest;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

Log_archive_dest string--the value of the log path does not have values

Log_archive_dest_1 string

............................................................. Omitted

Log_archive_dest_state_1 string Enable

............................................................ Omitted

Sql> Set Linesize 200

Sql> select * from V$flash_recovery_area_usage;

File_type percent_space_used percent_space_reclaimable Number_of_files

-------------------- ------------------ ------------------------- ---------------

CONTROL FILE 0 0 0

REDO LOG 0 0 0

Archived LOG 99.98 0 97 found already used 99.98%

BACKUP PIECE 0 0 0

IMAGE COPY 0 0 0

FLASHBACK LOG 0 0 0

FOREIGN archived LOG 0 0 0

7 rows have been selected.

2. Clear some logs

Clear Log with Rman method

C:\windows\system32>rman Target Sys/fyzh

Recovery manager: Release 11.2.0.1.0-production on Wednesday September 4 18:35:02 2013

Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.

Connect to target database: ORCL (dbid=1351232595)

Rman> crosscheck Archivelog All; --First check the

Using the target database control file instead of recovering the directory

Allocated channel: Ora_disk_1

Channel ora_disk_1:sid=68 Device Type =disk

Validation of archived logs is successful

Archive log file name =e:\app\fuyinzhen\flash_recovery_area\orcl\archivelog\2013_09_04\o1_mf_1_329_92frdr8g_. ARC recid=77 stamp=825262239

Validation of archived logs is successful

..........................................................

rman> Delete expired Archivelog all; --Delete expired logs, this library does not have an expired

Freed Channel: Ora_disk_1

Allocated channel: Ora_disk_1

Channel ora_disk_1:sid=68 Device Type =disk

Description does not match any archive log in the repository

--there is no expiration, in order to make room for space, it is specified to the specific time to delete it.

Rman>delete Archivelog until Time "to_date (' 2013-09-04 13:00:00 ', ' yyyy-mm-dd hh24:mi:ss ')";

--After the deletion in the use of the log to see the space situation, found that has been used only 21.73%

Sql> select * from V$flash_recovery_area_usage;

File_type percent_space_used percent_space_reclaimable Number_of_files

-------------------- ------------------ ------------------------- ---------------

CONTROL FILE 0 0 0

REDO LOG 0 0 0

Archived LOG 21.73 0 21

BACKUP PIECE 0 0 0

IMAGE COPY 0 0 0

FLASHBACK LOG 0 0 0

FOREIGN archived LOG 0 0 0

7 rows have been selected.

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