Database Backup and Recovery (MOSC)

MOSC Banner

Backing Up Archive Logs in a Standby Database Environment

edited Aug 23, 2015 11:54PM in Database Backup and Recovery (MOSC) 5 commentsAnswered ✓

What is best practice for backing up archive logs on the primary database in a (manual) standby database environment?

I copy the archived redo logs from the primary database server to the standby server every hour.

From RMAN if I periodically do an archive log backup by executing "backup archivelog all not backed up delete all input;" then this deletes all the archive logs on disk which then results in a missing archive log on the standby server.

Should some archive logs be retained on disk after they are backed up rather than delete all?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center