Disable log_archive_dest_3

disable log_archive_dest_3

[root@ebiz Desktop]# su - oraebiz

[oraebiz@ebiz ~]$ 

[oraebiz@ebiz ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 15 11:53:35 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter log_archive_config;

NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_25     string

log_archive_dest_26     string

log_archive_dest_27     string

log_archive_dest_28     string

log_archive_dest_29     string

log_archive_dest_3     string SERVICE=prodstb2 NOAFFIRM ASYN

C VALID_FOR=(ONLINE_LOGFILES,P

RIMARY_ROLE) DB_UNIQUE_NAME=PR

ODSTB2

SQL> select dest_name,status,error from v$archive_dest_status where dest_id=3;

DEST_NAME

--------------------------------------------------------------------------------

STATUS  ERROR

--------- -----------------------------------------------------------------

LOG_ARCHIVE_DEST_3

BAD PARAM

SQL> alter system set log_archive_dest_3='';

System altered.

You could also disable it by setting the state to DEFER:

SQL> alter system set log_archive_dest_state_3=defer;