Thursday, December 27, 2012

How to disable and enable logshipping when your standby database is in maximum availabilty through DataGuard Broker Architecture


We may not be able to disable the log transport when the database is in maximum availability mode. We may get the below error


DGMGRL> edit database 'DBNAME' set state=TRANSPORT-OFF;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

We may need to transfer the mode to maximum performance and disable the log transport.

1. Disable Log shipping

  1.1. Connect to dgmgrl broker
  $dgmgrl sys/welcome

 1.2  Verify the protection mode

 DGMGRL> show configuration
Configuration - DBNAME
  Protection Mode: MaxAvailability
  Databases:
    DBNAME    - Primary database
    DBNAME_SB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS


1.3 Disable the log apply in standby database
DGMGRL>  EDIT DATABASE 'DBNAME_SB' SET STATE='APPLY-OFF';  

1.4 Convert the database into maximum performance mode
DGMGRL>  EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;
   
1.5  Verify the configutaion
DGMGRL> show configuration
Configuration - DBNAME
  Protection Mode: MaxPerformance
  Databases:
    DBNAME    - Primary database
    DBNAME_SB - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS

1.6  Disable to the log transport
DGMGRL> edit database 'DBNAME' set state='LOG-TRANSPORT-OFF';

1.7 Verify the configuration in verbose mode
DGMGRL> show database verbose 'DBNAME'
  Database - DBNAME
  Role:            PRIMARY
  Intended State:  TRANSPORT-OFF
  Instance(s):
   .....

2. Enable Log shipping

2 .1 EDIT DATABASE 'DBNAME_SB' SET STATE='APPLY-ON';
2 .2 EDIT DATABASE 'DBNAME'  SET STATE='TRANSPORT-ON';
2 .3 EDIT CONFIGURATION SET PROTECTION MODE AS  'MAXAVAILABILITY'


For disable the log transport when the database is in maximum performance mode

DGMGRL> edit database 'DBNAME' set state=TRANSPORT-OFF;

DGMGRL> edit database 'DBNAME' set state=TRANSPORT-ON; 

Some important metalink notes



Metalink Notes:
===============

Subject: Complete Checklist for Manual Upgrades to 11gR1      Doc ID: NOTE:429825.1
Subject: Complete Checklist for Manual Upgrades to 10gR2     Doc ID:     316889.1
Subject: Complete Checklist for Manual Upgrades to 11gR2 [ID 837570.1]
11.2.0.3 Patchset is available now(Metalink Note Id: 742060.1 )


Note 169706.1:Pre-Install checks for Oracle RDBMS on AIX,HP-UX,Solaris,Tru64,Linux,MacOSX


Updating the RDBMS DST version in 11gR2 (11.2.0.1 and up) using DBMS_DST [ID 977512.1]


Self-PacedTraining for Oracle Database 11g Release 2 [ID 1060197.1]

How to determine the actual size of the LOB segments and how to free the deleted/unused space above/below the HWM [ID 386341.1]

General
=======
ID 401302.1 - How To Resolve Stranded DBA_2PC_PENDING Entries
How to Troubleshoot Slow Materialized View Complete Refresh Issues [ID 1313291.1]
Procwatcher ( Note 459694.1 ) to monitor for contention.

Send files to Oracle
====================
Refer:
External Support FTP site: Information Sheet (Doc ID 77483.1)
How to Send a File to Oracle Support Using FTP (ftp.oracle.com) (Doc ID 464666.1)

RAC
===
How to Validate Network and Name Resolution Setup for the Clusterware and RAC [ID 1054902.1]
11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained [ID 887522.1]

Support Information
==============
Release Schedule of Current Database Releases [ID 742060.1]


Data Guard
==========
How do you apply a Patchset,PSU or CPU in a Data Guard Physical Standby configuration (Doc ID 278641.1)
Step By Step How to Recreate Dataguard Broker Configuration [ID 808783.1]
Mixed Oracle Version support with Data Guard Redo Transport Services (Doc ID 785347.1)
Script to Collect Data Guard Primary Site Diagnostic Information (Doc ID 241374.1)
Script to Collect Data Guard Physical Standby Diagnostic Information (Doc ID 241438.1)
Data Guard Transport Considerations on Oracle Database Machine (Exadata) (Doc ID 960510.1)
11.2 Data Guard Physical Standby Switchover Best Practices using SQL*Plus [ID 1304939.1]
Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE [ID 1075908.1]
How to resolve MRP stuck issues on a physical standby database? [ID 1221163.1]

ASM
===
How To Gather/Backup ASM Metadata In A Formatted Manner version 10.1, 10.2, 11.1 & 11.2? ***** Enhanced ***** [ID 470211.1]

Best Practices- Exadata
=======================
Oracle Sun Database Machine Setup/Configuration Best Practices (Doc ID 1274318.1)
Flash Disks may report 'Not Present' or 'Poor Performance' after FDOM/Flash Disk Replacement [ID 1306635.1]
Oracle Exadata Diagnostic Information required for Disk Failures (Doc ID 761868.1)
Steps to shut down or reboot an Exadata storage cell without affecting ASM: (Doc ID 1188080.1)
Things to Check in ASM When Replacing an ONLINE disk from Exadata Storage Cell (Doc ID 1326611.1)
Replacing an Oracle Exadata System disk drive (Doc ID 1088475.1)
Exadata V2 Starter Kit [Document 1244344.1]
Database Machine and Exadata Storage Server 11g Release 2 (11.2) Supported Versions [Document 888828.1]
Exadata Storage Server Configuration Collection Guide [Document 735321.1]
Exadata Storage Server Diagnostic Collection Guide [Document 735323.1]
Oracle Exadata Best Practices [Document 757552.1]
Refer to the Exachk Tool How To downloadable from Note  1070954.1
Refer to the ExachkUserGuide.pdf downloaded with the Exachk bundle available from MOS Note  1070954.1
Steps To Shutdown/Startup The Exadata & RDBMS Services and Cell/Compute Nodes On An Exadata Configuration. [ID 1093890.1]


RMAN
====
RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]
How to duplicate a controlfile when ASM is involved [ID 345180.1]
Manual Completion of a Failed RMAN Duplicate [ID 360962.1]
RMAN 'Duplicate From Active Database' Feature in 11G [ID 452868.1]
Oracle® Database Backup and Recovery User's Guide 11g Release 1 (11.1) - http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm
Using RMAN DUPLICATE with OMF and ASM - http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#BGBEHADD
Oracle® Database Backup and Recovery User's Guide 11g Release 1 (11.1) - http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm
Duplicating a Database on a Remote Host with a Different Directory Structure
Duplicating a Database - http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm
A duplicate database, which is a copy of the target database (or a subset of the target database) with a unique DBID.
Duplicate target database command: - http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta028.htm
Duplicating a Database: Advanced Topics - http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmdupad.htm