Saturday 21 September 2013

Maintenance of archivelogs which are already applied on standby database in Oracle 10g

Maintenance Of Archivelogs On Standby Databases

Applies to:
Oracle Server – Enterprise Edition – Version: 10.1.0.0 to 11.1
Information in this document applies to any platform.

Goal
Maintenance of archivelogs which are already applied on standby database in Oracle 10g

Solution
In Oracle 10g, RMAN has a specific configuration for archivelog deletion policy i.e.
ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY
This parameter can be set on primary and standby databases.
To enable automatic maintenance of the archivelogs on standby perform the below steps on standby database :

Step 1 :  Enable the flash recovery area on the standby database so that all the archivelogs are shipped in the flash recovery area.
Example :
To enable Flash Recovery Area and to allow the archivelogs to be shipped to Flash Recovery Area set the below parameters
SQL> alter system set DB_RECOVERY_FILE_DEST=’/disk1/FRA’;
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=80G;
SQL> alter system set  LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’;

Step 2 : Set the parameter Archive log deletion policy to applied on standby
Example :
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
Note : With the above settings whenever there is a space pressure in Flash Recovery Area all the archivelogs that are applied on standby database will be automatically deleted.

References
Oracle Metalink Doc ID 464668.1

1 comment:

  1. Jadwal Resmi Laga Ayam SV388 14 Maret 2019 - Kamis, 14 Maret 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.

    Situs Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.

    Untuk Info Lebih Lanjut Bisa Hub kami Di :
    wechat : bolavita
    line : cs_bolavita
    whatsapp : +628122222995
    BBM: BOLAVITA

    ReplyDelete