Sunday, March 1, 2015

How to change the protection mode

Protection modes in Data Guard
  There are three protection modes in Data Guard: Maximum protection, maximum availability and Maximum performance .
  The protection mode can be determined by the protection_mode (and protection_level) column in v$database. 


Changing the protection mode
alter database set standby database to maximize [protection|availability|performance]
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to create user in MY SQL

Create  a new MySQL user Account mysql > CREATE USER ' newuser '@'localhost' IDENTIFIED BY ' password '...

  • Lock Script
    Hii All  Today i'm posting  lock script. sometime some session block to other session. This situation is very critical because our wh...
  • IMPOTED Excel/Text File Data USING TOAD
    IMPOTED Excel/Text File Data Into Oracle Table Using TOAD Step 1 :  Open TOAD. Step 2 :  Write the following query to create a test tabl...
  • Audit - Enabling or Disabling Audit Trail
    Auditing in Oracle Database The Oracle Server provides several auditing options. The following three types of audits are provi...