From Oracle Database 11 g onward, the transient logical database rolling upgrade process can also be used with existing physical standby databases.Ī snapshot standby database is a fully updatable standby database. The flexibility of a logical standby database lets you upgrade Oracle Database software (patch sets and new Oracle Database releases) and perform other database maintenance in rolling fashion with almost no downtime. The logical standby database is kept synchronized with the primary database through SQL Apply, which transforms the data in the redo received from the primary database into SQL statements and then executes the SQL statements on the standby database. Ĭontains the same logical information as the production database, although the physical organization and structure of the data can be different. For more information about this functionality, see the My Oracle Support note 1265700.1 at. ![]() A physical standby database can therefore be used concurrently for data protection and reporting.Īdditionally, as of Oracle Database 11 g Release 2 (11.2.0.1), a physical standby database can be used to install eligible one-off patches, patch set updates (PSUs), and critical patch updates (CPUs), in rolling fashion. A physical standby database is kept synchronized with the primary database, through Redo Apply, which recovers the redo data received from the primary database and applies the redo to the physical standby database.Īs of Oracle Database 11 g Release 1 (11.1), a physical standby database can receive and apply redo while it is open for read-only access. The database schema, including indexes, are the same. Provides a physically identical copy of the primary database, with on-disk database structures that are identical to the primary database on a block-for-block basis. The types of standby databases are as follows: Similar to a primary database, a standby database can be either a single-instance Oracle database or an Oracle RAC database. Oracle Data Guard automatically maintains each standby database by transmitting redo data from the primary database and then applying the redo to the standby database. Using a backup copy of the primary database, you can create up to thirty standby databases and incorporate them into an Oracle Data Guard configuration. Oracle Active Data Guard Supports Oracle ShardingĪ standby database is a transactionally consistent copy of the primary database. Oracle Data Guard and Complementary Technologies See the following topics which describe the highlights of Oracle Data Guard: With Oracle Data Guard, administrators can optionally improve production database performance by offloading resource-intensive backup and reporting operations to standby systems. Oracle Data Guard transport services are also used by other Oracle features such as Oracle Streams and Oracle GoldenGate for efficient and reliable transmission of redo from a source database to one or more remote destinations. Oracle Data Guard can be used with traditional backup, restoration, and cluster techniques to provide a high level of data protection and data availability. Then, if the production database becomes unavailable because of a planned or an unplanned outage, Oracle Data Guard can switch any standby database to the production role, minimizing the downtime associated with the outage. ![]() Oracle Data Guard maintains these standby databases as copies of the production database. Oracle Data Guard provides a comprehensive set of services that create, maintain, manage, and monitor one or more standby databases to enable production Oracle databases to survive disasters and data corruptions. Oracle Data Guard ensures high availability, data protection, and disaster recovery for enterprise data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |