Database Administration (MOSC)

MOSC Banner

Temporarily disabling archiving on primary db while log transport is disabled

edited Nov 12, 2015 8:28PM in Database Administration (MOSC) 10 commentsAnswered

Hi,

We need to load huge amount of data on our primary server with minimum time possible so we want to disable archiving while we load (one time only). Will doing the following wont affect dataguard configuration:

1. Disable redo log transport and apply on standby db (or shutdown standby db).

2. Turn OFF archiving on primary db.

3. Load the data.

4. Turn ON archiving on primary db.

5. Enable redo log transport and apply on standby db (or startup standby db)

Thank you.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center