New Features For Oracle 11g Data Guard

Latest features in Oracle 11g Data Guard their main product for defensive databases and an vital part of frequent disaster recovery strategy. Configure records log removal policy change .Configuration setting for RMAN is not in and of it self latest to Oracle 11g. With 11gR2, Oracle has extra a new setting for the archive log deletion policy.

Configure archive log deletion policy to shipped to standby;

The main differentiation and advantage here is that we might configure stand by databases to intentionally remain apply the redo data to the stand by database. With this latest site, RMAN could remove records one time they have been effectively shipped to the stand by, whether or not they really been applied. The standby logs are individual archived, we know the data is obtainable to the standby database.

There are databases out there where obtainable space is a best, so being able to eliminate the archives extra fast in a data guard situation is useful.

Fast start fail over Improvements:  Fast start fail over for data guard was initially begin in 10gR2, as a technique to effort among data guard adviser to mechanically begin a fail over from the main to a chosen stand by database. A divide process called observer is installed on a divide host with full connectivity to c both databases, and if watcher lost contact with the primary database for extra than a chosen sill time, the fail over would be start. Configure quick start fail over, the data guard safety level had to be the best part ease of use.

With 11gR1 quite a few new features were extra to the fast create failover options. The safety stage could be moreover most ease of use or greatest performance.

There were fairly a little extra property that could be configured:

[1] Fast Start Fail over Lag Limit: Sets an suitable time lag for the stand by to drop after the primary for functional redo.  This defaults to 30 seconds.

[2] Fast Start Fail over Pmy Shutdown: Indicate if the major database must be shut down if the major database has missing obtain in handle with with the stand by and redo age collection has been stalled. This is skill ful use a shut down finish option.  This defaults to false.

[3] Fast Start Fail over Auto Reinstate: Discover if the old major database must be automatically re instate back into the collection as a stand by database if a fail over is initiate. This defaults to true.

[4] Observer Connect Identifier: Use to tell the viewer how to connect to and observe the main and standby databases.  This default to the normal connect identifier formed for the data guard configuration.

Role Based Services:  Initial with 11gR2, with the start of the latest grid interactions software, we have the ability to set up services in our databases that can at the current mechanically be joined to the specific position that a database is playing in our data guard configuration. This can be use for both RAC and only instance databases presently so extended as grid communications had been installed.  The services would have to be set up use SRVCTL fairly than DBMS_SERVICE.

Linux training  to educate some one to increase their Linux ability and acquire high quality job in current market.  IcanXplore present Linux course  for  developers, programmers, immigrant and Un employed.  Online Linux training construct easy to obtain better  Linux ability. We are situated in city of Pleasanton, CA, USA in San Francisco bay area, int the Silicon valley.

Snapshot Standby Database: A snapshot standby database is a physical standby that is temporarily “disconnected” from your data guard configuration and bright to be used as a completely updatable stand alone database. Several variety of difficult or changes can be done, including features like using Database replay. A great way to maximize probable utilize of resources. While the database is in the snap shot role, redo in sequence continue to be ship to the stand by database, and archived at the standby database. The rebuild will not be applied to the stand by database awaiting after it is transformed back into a normal physical stand by database.

When the database is transformed back, it is flash back to the certain re store point, put back into the complete data guard configuration, and the redo is functional finally infectious the stand by database reverse up to the main.  Once this is complete, the certain restore point is indifferent mechanically.

Active data guard: Latest characteristic of Oracle 11g data protector active data guard. The data guard pattern, this display as have real time query enable. We have the capability to go further on and use a physical stand by database for query purpose, and redo continue to be functional while queries are being run touching the database. Extra features were extra as fraction of active data protector  doing incremental backups on the physical stand by among block modify track enabled and mechanical alter chunk discovery and recovery.

Individual probable area of worry with genuine time query is that potentially your stand by database can drop behind the primary through an apply lag. The queries you are off loading are awfully time available, even a lag of a not numerous seconds can be difficult. Oracle has a session level parameter STANDBY_MAX_DATA_DELAY which sets a meeting explicit acceptance level for how far after the main database the stand by can and still permit queries to run unchanged. RMAN obstruct recover commands can utilize one of three sources nowadays for decision the opening high-quality of  block restore a stand by database with existent time query enable, flash back logs and then as the most recent option, RMAN complete backups are use.

IcanXplore is from San Francisco bay area, in Silicon Valley, CA, USA, focused on providing Linux training around the world at own time, pace, 24/7. Only e-mail skill can renovate person into a successful Linux system administrator. Information technology professionals from Silicon Valley, CA, USA reveal effectual Linux training system to train person with basic knowledge of computer.

This entry was posted in Linux Training | Online Linux Training | Linux and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s