How to enable and disable differ in DR database

-
Please find  below steps

Step 1: sql> show parameter log_archive_dest_state_2

Step 2: sql> alter system set log_archive_dest_state_2=DEFER;

Step 3: sql> alter system set log_archive_dest_state_2=ENABLE;

FYI: Please check the free space availability in the production archive destination also.

Comments

Post a Comment

Popular posts from this blog

How to check OS inventory

-
Grid-1 [root@scnluatoradb02 lib]# su - grid Last login: Sun Nov 18 16:18:44 IST 2018 on pts/1 [grid@makuatoradb02 ~]$ [grid@makuatoradb02 ~]$ [grid@makuatoradb02 ~]$ /oracle/12.2.0/grid/OPatch/opatch lsinventory  -oh /oracle/12.2.0/grid Oracle Interim Patch Installer version 12.2.0.1.14 Copyright (c) 2018, Oracle Corporation.  All rights reserved. Oracle Home       : /oracle/12.2.0/grid Central Inventory : /oracle/app/oraInventory    from           : /oracle/12.2.0/grid/oraInst.loc OPatch version    : 12.2.0.1.14 OUI version       : 12.2.0.1.4 Log file location : /oracle/12.2.0/grid/cfgtoollogs/opatch/opatch2018-11-18_17-57-39PM_1.log Lsinventory Output file location : /oracle/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-11-18_17-57-39PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname:...
Read more