iSelfSchooling.com - Community of Sharing

Click here for Online Oracle 8i, 9i, 10g, 11g and 12c Training

from www.iSelfSchooling.com

August 01, 2014, 07:26:41 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Login Register  
Pages: [1]   Go Down
  Send this topic  |  Print  
Author Topic: DG-Step #9: Enable MAXAVAILABILITY protection mode  (Read 1797 times)
hitech2010
Jr. Member
**
Posts: 16


« on: April 18, 2010, 07:11:48 AM »

www.iselfschooling.com

//////////////////////////////////////////////////////////////////
This note is a link from the "Creating a Dataguard" note.
To follow the subject please start from the following link.
http://www.iselfschooling.com/board/index.php?topic=337.0
//////////////////////////////////////////////////////////////////
Notice that the commands below will only suceed if the standby database is configured with standby redo logs.

Ensure the LogXptMode Property is set to SYNC.

Connect to DG Broker and set the LogXptMode Property to SYNC
# dgmgrl
Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys/[password]@[prim_service_name]
Connected.

DGMGRL> help
The following commands are available:
add            Add a standby database to the broker configuration
connect        Connect to an Oracle instance
convert        Convert database from one standby type to another
create         Create a broker configuration
disable        Disable a configuration, a database, or Fast-Start Failover
edit           Edit a configuration, database, or instance
enable         Enable a configuration, a database, or Fast-Start Failover
exit           Exit the program
failover       Change a standby database to be the primary database
help           Display description and syntax for a command
quit           Exit the program
reinstate      Change a disabled database into a viable standby database
rem            Comment to be ignored by DGMGRL
remove         Remove a configuration, database, or instance
show           Display information about a configuration, database, or instance
shutdown       Shut down a currently running Oracle instance
start          Start Fast-Start Failover observer
startup        Start an Oracle database instance
stop           Stop Fast-Start Failover observer
switchover     Switch roles between the primary database and a standby database

Use "help <command>" to see syntax for individual commands


DGMGRL> EDIT DATABASE [prim_DB_UNIQUE_NAME] SET PROPERTY 'LogXptMode'='SYNC';

DGMGRL> EDIT DATABASE [stndby_DB_UNIQUE_NAME] SET PROPERTY 'LogXptMode'='SYNC';

Upgrade the "PROTECTION MODE" to MAXAVAILABILITY
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

--hitech2010
Logged
Pages: [1]   Go Up
  Send this topic  |  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!