High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

log_archive_dest_32?

I have never seen this, but I noticed after upgrading 11.2.0.2 -> 11.2.0.3:

on primary:

/db/foobar/oraarch/foobar/     PRIMARY

foobar_db1_dg     STANDBY

on standby:

SQL> select dest_id, destination as archive_dest, target from v$archive_dest where status = 'VALID' order by dest_id;

  1 /db/foobar/oraarch/foobar/ LOCAL

  2 foobar_db2_dg REMOTE

  32 /db/foobar/oraarch/foobar/ LOCAL

select * from v$archive_dest where  dest_id = 32;

  32

STANDBY_ARCHIVE_DEST

VALID   OPTIONAL  SYSTEM  LOCAL   ARCH       ACTIVE

/db/foobar/oraarch/foobar/

    0     300   0   1       0 RFS   YES     0 0       0   0

NONE

LOG_ARCHIVE_DEST_1

NONE

  0     0       0 SYNCHRONOUS 0 YES PUBLIC  YES ALL_LOGFILES ALL_ROLES    NONE     NO DISABLE   0

show parameter Log_archive_dest_32

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