The ORA-19809 exceeds the limit on the number of recovery files

From: http://space.itpub.net/10583980/viewspace-503920

 

1 login:

Sqlplus/nolog

SQL> connect sys/123 as sysdba;

 

SQL> shutdown normal
ORA-01109: the database is not open

The database has been detached.
The Oracle routine has been disabled.
SQL> startup Mount;
The Oracle routine has been started.

Total system global area 171966464 bytes
Fixed size 787988 bytes
Variable Size 145750508 bytes
Database buffers 25165824 bytes
Redo buffers 262144 bytes
The database has been loaded.

Alter database open Error

ORA-16038: log 3 serial number 160 cannot be archived
ORA-19809: exceeds the limit on the number of recovery files
ORA-00312: Online log 3 thread 1:
'D:/Oracle/product/10.2.0/oradata/orcl/redo03.log'

The following solutions

SQL> select * from V $ recovery_file_dest;

Space_limit space_used space_reclaimable number_of_files
-----------------------------------------------------
D:/Oracle/product/10.2.0/flash_recovery_area
2147483648 2233146368 0 29

The visible capacity is full.

SQL> alter system set db_recovery_file_dest_size = 8g scope = both;

The system has been changed.

SQL> alter database open;

The database has been changed.

Select * from V $ log;
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 6.91 0 31
Backuppiece 4.45 0 2
Imagecopy 0 0 0
Flashbacklog 0 0 0

You have selected 6 rows.
Archivelog 6.91%, backuppiece 4.45%

To manually delete a disk file, you need to crosscheck archivelog all; Delete expired archivelog all;

C:/datadumps> RMAN target/

RestoreManagementTool: Release 10.2.0.1.0-production on Tuesday

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

Connect to the target database: orcl (dbid = 1127021099)

RMAN> crosscheck archivelog all;

Use the target database control file to replace the recovery directory
Allocated channel: ora_disk_1
Channel ora_disk_1: SID = 145 devtype = Disk
The archived log is verified successfully.

In addition, my archived logs are manually cleared for a long time without clearing the database records, resulting in errors. You can also delete them using the RMAN policy:
Configure retention policy to recovery window of 6 days;
Configure retention policy to redundancy 6;
Configure retention policy to none;