"Experiment-Video process" Database archive log is full after

After the archive log is full,

First, clean up the file

C:\users\administrator>19:24:36.78>sqlplus Scott/tiger

Sql*plus:release 11.2.0.1.0 Production on Friday October 9 19:24:40 2015

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

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

No more reading and writing is allowed at this time.

See how much you use

Sql>select * from V$flash_recovery_area_usage;

Delete an expired archive log

Rman Target Sys/xxxxxxxxxxx

Rman> crosscheck Archivelog All; – First check the
You can do this after physical deletion in the directory

Rman>delete expired Archivelog All; – Delete expired logs, this library does not have an expired

No expiration of the direct deletion to a certain day

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

My test library is all deleted directly.

Rman>delete Archivelog All

Second, expand the space, scheduled cleaning.

Set the archive log usage space to 10g, using the SQL command

Sql> alter system set DB_RECOVERY_FILE_DEST_SIZE=10G Scope=both; ---Set the use space size, if the production environment is recommended for a larger 500G

Sql> Show parameter db_recovery_file_dest;

NAME TYPE VALUE

Db_recovery_file_dest string D:\oracle\product\10.2.0\flash_recovery_area\
Db_recovery_file_dest_size Big Integer 10G

Custom tasks need to be scheduled to clean up the archive log

Deleting archived logs can only be done in Rman,

Then create a new bat file on the database server

Edit this file as: Rman target ' sys/password ' cmdfile ' d:\cmd.txt '--Here the path,

The file name arbitrarily creates a new Cmd.txt file under the corresponding path in the command, opens editing this file,

DELETE ARCHIVELOG all completed before ' SYSDATE-3 ';

Then add tasks to Windows Scheduled tasks

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced. If there is a need to reprint please contact [email protected]

Experiment-Video Process Database archive log is full later