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

1. If there is no backup mechanism, if you want to automatically delete the repository archives, you need to use the quick recovery area (FRA).

Check the location of the current repository archive:

SQL > show parameter log_archive_dest_1

NAME TYPE VALUE

-

Log_archive_dest_1 string location=/archdir valid_for= (ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby

two。 Change FRA configuration

ALTER SYSTEM SET db_recovery_file_dest_size=60g SCOPE=BOTH

ALTER SYSTEM SET db_recovery_file_dest=/archdir SCOPE=BOTH

ALTER SYSTEM SET log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for= (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=standby' SCOPE=BOTH

3. Restart the standby library

ALTER DATABASE RECOVER managed standby database cancel

Shutdown immediate

Startup mount

ALTER DATABASE RECOVER managed standby database disconnect from session

At this point, the alert shows that the new archivelog is stored in the FRA.

Media Recovery Log / archdir/STANDBY/archivelog/2017_07_13/o1_mf_2_265_dpgfvl3o_.arc

4. Configure the archive deletion policy for rman

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY

When the FRA space reaches 80% utilization, the applied archivelog is automatically deleted:

Deleted Oracle managed file / archdir/STANDBY/archivelog/2017_07_18/o1_mf_2_412_dpvh6d5d_.arc

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.