How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
standby database → A standby database, which is a special copy of the source database (called a primary database in a … database. A standby database is not assigned a new DBID. RMAN can perform the duplication in any of the … Data Guard Concepts and Administration to learn how to create,
Contents → Registration of a Database in the Recovery Catalog About Standby Database Registration Registering a … Standby Database Resetting the Database Incarnation in the Recovery Catalog Upgrading the Recovery … an OPEN RESETLOGS Operation with Flashback Database Undoing an
Contents → a Standby Database with the Primary Database Purging the Database Recycle Bin Configuring the … Conventions 1 Introduction to the Upgrade Process for Oracle Database Where to Find the Latest … Information About Upgrading Oracle Database Overview of Oracle Database Upgrade
2.1 Standby Database Types → initially created from a backup copy of the primary database. Once the standby database is created … and configured, Data Guard automatically maintains the standby database by transmitting primary … database redo data to the standby system, where the redo data is applied
physical standby database → A copy of a production database that you can use for disaster protection.
Logical standby database → indexes, are the same. A physical standby database is kept synchronized with the primary database … redo to the physical standby database. As of Oracle Database 11 g release 1 (11.1), a physical standby … database can receive and apply redo while it
Standby Transmission Mode → database. Caution: You can maintain a standby database on a local disk, but Oracle strongly encourages you … to maximize disaster protection by maintaining your standby database at a remote site. See Also … In standby transmission mode, the archiving destination is either a local or
Managing Standby Databases → The data files, control files, and redo log files in a standby database can be managed by the … recovery of a standby database encounters redo for the creation of a data file, if the data file is an … intervention. When recovery of a standby database encounters redo for the deletion
standby database → An independent copy of a production database that you can use for disaster protection in a high availability environment.
10.3.2 DBA_LOGSTDBY_LOG View → at the logical standby database at 01:02:41.The APPLIED column indicates that SQL Apply has applied
3.2.1 Create a Backup Copy of the Primary Database Datafiles → You can use any backup copy of the primary database to create the physical standby database, as … long as you have the necessary archived redo log files to completely recover the database. Oracle … recommends that you use the Recovery Manager utility (RMAN). See Oracle Database Backup and Recovery
Step 1 Create a parameter file PFILE from the server parameter file SPFILE used by the primary database. → values appropriate for use at the physical standby database.
4 Creating a Logical Standby Database → This chapter steps you through the process of creating a logical standby database. It includes the … following main topics: Prerequisite Conditions for Creating a Logical Standby Database Step-by-Step … Instructions for Creating a Logical Standby Database Post-Creation Steps See Also:
10 Managing a Logical Standby Database → Access to Tables in a Logical Standby Database Views Related to Managing and Monitoring a Logical … Standby Database Monitoring a Logical Standby Database Customizing a Logical Standby Database … Managing Specific Workloads In the Context of a Logical
10.7.4 Adjust the Memory Used for LCR Cache → For some workloads, SQL Apply may use a large number of pageout operations, thereby reducing the overall throughput of the system. To find out whether increasing memory allocated to LCR cache will be beneficial, perform the following steps: Issue the following query to obtain a snapshot of pageout activity: SQL> SELECT NAME, VALUE FROM V$LOGSTDBY_STATS WHERE NAME LIKE '%page%' - > OR NAME LIKE '%uptime%'
3.2.4 Copy Files from the Primary System to the Standby System → the standby system: Backup datafiles created in Section 3.2.1 Stan dby control file created in
10.3.7 V$LOGSTDBY_STATS View → meaningful in the context of a logical standby database. For example: SQL> ALTER SESSION SET … (seconds) 0 system idle time (seconds) 2921 standby redo logs mined 0 archived logs mined 5 gap fetched … logs mined 0 standby redo log reuse detected 1 logfile open failures 0 current logfile wait (seconds) 0
3.1.2 Configure Redo Transport Authentication → physical standby database in the configuration must have an up-to-date copy of the password file from … physical or snapshot standby database in the configuration with a fresh copy of the password file from … Directory (OID) enterprise domain and it allows the use of current user database links The
10.5.2 Using DBMS_LOGSTDBY.SKIP to Prevent Changes to Specific Schema Objects → By default, all supported tables in the primary database are replicated in the logical standby … DATABASE STOP LOGICAL STANDBY APPLY; Register the SKIP rules: SQL> EXECUTE DBMS_LOGSTDBY.SKIP (stmt … (stmt => 'SCHEMA_DDL', schema_name => 'HR', - > object_name => 'EMPLOYEES'); Start SQL Apply: SQL> ALTER DATABASE
3.1.3 Configure the Primary Database to Receive Redo Data → database will be ready to quickly transition to the standby role and begin receiving redo data. See … Although this task is optional, Oracle recommends that a primary database be configured to receive … Section 6.2.3 for a complete discussion of how to configure a database to receive redo data.