Shulou(Shulou.com)06/01 Report--

Oracle 12C DG environment, prepare library archive directory alarm, check crontab script, find delete operation, keep it for two days, and then execute it manually to check the specific cause of error.

RMAN > delete noprompt expired archivelog all

Released channel: ORA_DISK_1

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=5408 device type=DISK

Specification does not match any archived log in the repository

RMAN > delete noprompt archivelog until time 'sysdate-2'

Released channel: ORA_DISK_1

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=5408 device type=DISK

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

Archived log file name=/u01/arch/fcdstdydb1_948_973216253.dbf thread=1 sequence=948

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

Archived log file name=/u01/arch/fcdstdydb1_949_973216253.dbf thread=1 sequence=949

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

Archived log file name=/u01/arch/fcdstdydb1_950_973216253.dbf thread=1 sequence=950

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

Archived log file name=/u01/arch/fcdstdydb1_951_973216253.dbf thread=1 sequence=951

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

Archived log file name=/u01/arch/fcdstdydb1_952_973216253.dbf thread=1 sequence=952

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

-solve

RMAN > delete noprompt force archivelog all completed before 'sysdate-2'

Released channel: ORA_DISK_1

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=5408 device type=DISK

List of Archived Log Copies for database with db_unique_name FCDSTDYDB

Key Thrd Seq S Low Time

935 1 948 A 2018:06:05 02:23:34

Name: / u01/arch/fcdstdydb1_948_973216253.dbf

936 1 949 A 2018:06:05 02:28:52

Name: / u01/arch/fcdstdydb1_949_973216253.dbf

937 1 950 A 2018:06:05 02:32:32

-description-

This is 11g bug. You need to add the force keyword after delete. It is recorded on metalink.

RMAN-08137 When deleting archivelogs even when Streams CAPTURE does not require them [ID 1079953.1]

In this Document

Symptoms

Changes

Cause

Solution

References

Symptoms

Applies To: 11gR1-11gR2

RMAN is unable to delete archive logs from database even though they are not needed by CAPTURE process anymore.

Changes

Cause

In 11g, RMAN looks at MIN_REQUIRED_CAPTURE_CHANGE# in v$database and not at DBA_CAPTURE. By default this value is updated every 6 hours. So by default the value in v$database will be six hours behind the current value.

Solution

Since changing frequency of update to MIN_REQUIRED_CAPTURE_CHANGE# in v$database can not be controlled, following workaround can be used:

Archive log which are not needed by capture process can be deleted using:

Delete noprompt force archivelog all completed before 'sysdate-10/1440'

PS: our environment is 12C DG. The BUG is clearly identified in 11g. 12C MARK this.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.