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

I. description of the environment

Oracle 12c single instance DataGuard

Rhel 7.3

Second, the testing process

Main library operation

1. Close DG and switch logs

SQL > alter system set log_archive_dest_state_2=defer

System altered.

SQL > show parameter log_archive_dest_state_2

NAME TYPE VALUE

-

Log_archive_dest_state_2 string DEFER

Log_archive_dest_state_20 string enable

Log_archive_dest_state_21 string enable

Log_archive_dest_state_22 string enable

Log_archive_dest_state_23 string enable

Log_archive_dest_state_24 string enable

Log_archive_dest_state_25 string enable

Log_archive_dest_state_26 string enable

Log_archive_dest_state_27 string enable

Log_archive_dest_state_28 string enable

Log_archive_dest_state_29 string enable

SQL > alter system switch logfile

System altered.

SQL > alter system switch logfile

System altered.

SQL >

2.rman delete archive

RMAN > list archivelog all

List of Archived Log Copies for database with db_unique_name ORCL

=

Key Thrd Seq S Low Time

-

40 1 31 A 26-NOV-2017 19:15:13

Name: / oracle/arch/1_31_958415134.dbf

42 1 32 A 26-NOV-2017 19:22:34

Name: / oracle/arch/1_32_958415134.dbf

RMAN > delete noprompt archivelog all

Released channel: ORA_DISK_1

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=39 device type=DISK

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

Archived log file name=/oracle/arch/1_32_958415134.dbf thread=1 sequence=32

List of Archived Log Copies for database with db_unique_name ORCL

=

Key Thrd Seq S Low Time

-

40 1 31 A 26-NOV-2017 19:15:13

Name: / oracle/arch/1_31_958415134.dbf

Deleted archived log

Archived log file name=/oracle/arch/1_31_958415134.dbf RECID=40 STAMP=961096954

Deleted 1 objects

RMAN >

III. Summary

When our DG environment, human or abnormal conditions lead to DG exceptions, archive logs that are not applied will not be deleted. A problem that may arise here is that

When our disk space is tight, a large number of logs may be generated to fill the disk, resulting in the problem that the database cannot be written. It is necessary for us to have a monitoring system to deal with DG exceptions in time.

Don't wait to affect the business before dealing with it passively.

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.