primary database dataguard archive

[Roshan]

Oracle Database 11g
Red Hat Linux

Hi,

I have a dataguard environment(production and standby). I have setup archivelog backups for primary database with deletetion policy for archives <= 2 days.

I see the archive logs have not been deleted. The archivelog filesystem is often full on primary database.
WHen I delete archivelog until time 'sysdate-2'
archive.PNG

I have to move the archive logs older than 3 days to another filesystem and delete expired.

Please advise if I increase the filesystem size or modify rman archivelog script?

Thanks,
Roshan

[Roshan]

I see there is a large gap between primary and standby DB

Standby DB
SQL> select max(sequence#) from v$archived_log where applied='YES' ;

MAX(SEQUENCE#)
--------------
        155750

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
        156688

SHould I perform and incremental backup and restore?

[ErmanArslansOracleBlog]

Archive deletion policy prevents deleting of archivelogs when they are not applied to standby.
If you want to continue using the archivelog deletion policy, solve that dataguard gap.

Incremental backup can be a solution if you believe your network or server resources are not cabaple of solving the gap.

However, you need to find a permenant fix for that. I mean there should not be that kind of gap in any time. It is not acceptable in a critical dataguard env.

[ErmanArslansOracleBlog]

Also note that,

When the Archived Redo Log Deletion Policy Is Disabled ->
The archived redo log deletion policy is configured to NONE by default. In this case, RMAN considers archived redo log files in the recovery area as eligible for deletion if they meet both of the following conditions:

"The archived redo logs, whether in the flash recovery area or outside of it, have been transferred to the required remote destinations specified by LOG_ARCHIVE_DEST_n."

The archived redo logs have been backed up at least once to disk or SBT or the logs are obsolete according to the backup retention policy.

[ErmanArslansOracleBlog]

Also note that, if you delete those archivelogs, what will be transfferred to the standby?
Incremental rman backup may work okay but ... your choice.

Anyways, find the cause of the gap, implement a permenant fix for the gap..

[Roshan]

Hi Erman,

I am following the doc

Steps to perform for Rolling Forward a Physical Standby Database using RMAN Incremental Backup. (Doc ID 836986.1)

to make the database in sync with Primary database.

Regards,

Roshan

[ErmanArslansOracleBlog]

Good.