Data Guard to protection data Warehouse

havewala-dataguard-oem12c-fig03If you have not logged in to the PROD database previously, you will have to do so at this point - the login screen appears.

Connect with SYSDBA privileges. This is required for setting up and monitoring Oracle Data Guard in all databases upto version 11g. In the new Oracle Database 12c, there is now a different privilege known as SYSDG. This privilege allows a user to perform Data Guard operations. This is a much sought-after enhancement that has finally been realized in Oracle Database 12c, and means that the management of Data Guard can be achieved without sysdba privileges.

havewala-dataguard-oem12c-fig04The wizard now displays the next page where you can select the type of Standby Database that is to be created.

Figure 2: Select the Standby Type

The main options are a new Physical Standby, or a new Logical Standby.

However, if you have already set up a standby database manually, it is also possible to add it at this stage to the Data Guard configuration. You can do this by choosing Manage an existing standby database with Data Guard broker.

In the case of Oracle Database 12c, when adding a Standby Database, the wizard does not continue unless all the Pluggable databases (PDBs) in the production Container database (CDB) are open. This is seen in the following screenshot.havewala-dataguard-oem12c-fig01 The wizard is now CDB and PDB aware, and can create a Standby Database from a Container Database. Note that the standby created is for the entire CDB and all PDBs contained in it.

Figure 3: CDB and PDB aware Wizard in Oracle Database 12c.

When it comes to choosing between a physical standby database and a logical standby database, in most cases, a physical standby database is suitable - it has the better performance as compared to a logical standby. The logical standby also has a number of restrictions as to the data types allowed.

Hence, we select Create a new physical standby database to use a physical standby. Click on Continue. The wizard now starts, displaying the first step as shown below.

havewala-dataguard-oem12c-fig06 havewala-dataguard-oem12c-fig07 havewala-dataguard-oem12c-fig08 havewala-dataguard-oem12c-fig10

You might also like

Pacer Performance Pacer Performance 25-502 Black Deluxe Bumper Guard Kit - 4 Piece
Automotive Parts and Accessories (Pacer Performance)
  • Deluxe gloss black UV protected PVC universal bumper guards
  • Attractive and inexpensive way to protect your vehicle from minor parking lot scrapes and scratches
  • Install using 3M self-stick tape; no drilling required
  • Sold in complete 4 piece kit

GT Software Ships Data Unification Solution  — Database Trends and Applications
GT Software, a provider of enterprise data management solutions,has introduced a new software platform and supporting services that enables users to access critical information from across the organization, regardless of where the data resides, on or ..

APC APC Back-UPS ES 8 Outlet 550VA 120V
  • The item is non-returnable.Special Shipping Information: This item cannot be returned to For additional information concerning this policy, please visit...
  • Four battery backup/surge protected outlets keep critical devices running during outages and fluctuations; four surge only outlets protect non-critical devices.
  • Auto Shutdown Software available through manufacturer s website
  • Three Yr Warranty, $75, Equipment Protection Policy, free technical phone and online support, Data Recovery Services
  • Data Line Surge Protection guards against surges and spikes traveling over an analog phone line; Building Wiring Fault Indicator detects problems in building wiring.;Ultra...
myLife Brand Products myLife Bright Lava Red and Dark Steel Black - Neo Hybrid Series (Built In Kickstand) 2 Piece + 2 Layer Case for NEW Galaxy S5 (5G) Smartphone by Samsung (External Hard Fit Armor With Built in Kick Stand + Internal Soft Silicone Rubberized Flex Gel Bumper Guard)
Wireless (myLife Brand Products)
  • IMPORTANT FEATURES AND DESIGN: This case comes with a built in kickstand that is perfect for keeping your Galaxy S5 cell phone in a horizontal or vertical upright...
  • COLOR: This case comes in a deep high quality color that will last the life of your Galaxy S5 because the color is fused with the silicone and rubberized material...
  • MATERIALS AND DESIGN: The case has a soft gell inner layer with a hard rubber exterior layer for double the protection. This case protects the Galaxy S5 Smartphone...
  • WARRANTY AND PACKAGING: All myLife (TM) are sold exclusively by myLife Brand Products. Any products being offered by other vendors are fake and not authentic myLife...
  • COMPATIBILITY: It is important to note that the Galaxy S5 is for sale from the following carriers; Verizon, AT&T, Sprint, T-Mobile, MetroPCS, U.S. Cellular...
3M 3M Privacy Screen for 17.0-Inch Monitor
CE (3M)
  • Filter viewing area 10 15/16 x 13 5/8 , fits 15 to 18 standard monitors
  • Reduces screen glare and reflections for more comfortable viewing
  • Optically clear with greater than or equal to 92% clarity plus the east-to-clean surface repels permanent marker.
  • The only light-weight framed privacy filter available for both widescreen and standard desktop monitors
  • Screen data is visible only to persons directly in front of the monitor. 3M privacy technology darkens on-screen data when viewed from the side.
AVG Technologies Ltd. AVG Internet Security 2011 (3-User) [Old Version]
Software (AVG Technologies Ltd.)
  • AVG LinkScanner s provides full web protection by actively checking web pages in real time before you visit them.
  • It alerts you if the site is untrustworthy and shows website safety ratings in your search engine results
  • AVG Social Networking Protection keeps you safe by checking the links in messages you post on sites like Facebook working automatically in real time
  • And includes smart intrusion prevention to keep your home network even more secure


What are benefits of data warehouse?

One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.