DataGuard slave database deletes applied logs

DataGuard slave database deletes applied logs

The company set up a slave uard. At the beginning, it did not pay attention to the management of archiving logs in the slave database. After the system was running for a while, it was found that the space of the slave database was cracked up by archiving logs.

Solution: Oracle provides a view for you to view the execution status of archived logs. You can delete the archived logs through the operating system as long as they have been applied.

Script for viewing archived logs: select sequence #, applied from v $ archived_log order by sequence #;

The following is the scheduled Delete script for the operating system I configured:

#! /Bin/sh

Export PATH

ORACLE_SID = orcl

TABLE = 'v $ archived_log'

Export ORACLE_BASE ORACLE_SID

Export ORACLE_HOME =/u01/app/oracle/product/OraDb11g_home1

Export PATH = $ PATH: $ ORACLE_HOME/bin: $ ORACLE_HOME/OPatch

$ ORACLE_HOME/bin/sqlplus-silent "/as sysdba" <EOF>/home/oracle/deleteorclarch. sh
 
Set heading off;

Set pagesize 0;

Set term off;

Set feedback off;

Set linesize 32767;

Select 'rm-rf '| name from $ {TABLE} where DELETED = 'no' and APPLIED = 'yes ';

Exit;

EOF

Sh/home/oracle/deleteorclarch. sh

Rman target/<END

Crosscheck archivelog all;

Delete noprompt expired archivelog all;

Exit;

END

Use crontab to regularly run scripts on a daily basis;

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Important configuration parameters of Oracle Data Guard

Configure Oracle 11g Data Guard based on the same host

Explore Oracle 11g elastic uard

Oracle Data Guard (RAC + DG) archive deletion policies and scripts

Role conversion for Oracle Data Guard

FAL gap in Oracle Data Guard logs

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby