You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for standby database


1 to 20 of 77854 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Backup and Recovery Reference, 11g Release 2 (11.2)

DUPLICATE

standby databaseA 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,

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Database Backup and Recovery User's Guide - Contents

ContentsRegistration 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

Database Upgrade Guide, 11g Release 2 (11.2)

Database Upgrade Guide - Contents

Contentsa 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

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Getting Started with Data Guard

2.1 Standby Database Typesinitially 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

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Glossary

physical standby databaseA copy of a production database that you can use for disaster protection.

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Introduction to Oracle Data Guard

Logical standby databaseindexes, 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 standbydatabase can receive and apply redo while it

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Archived Redo Logs

Standby Transmission Modedatabase. 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

Database Administrator's Guide, 11g Release 2 (11.2)

Using Oracle Managed Files

Managing Standby DatabasesThe 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

Database Concepts, 11g Release 2 (11.2)

Glossary

standby databaseAn independent copy of a production database that you can use for disaster protection in a high availability environment.

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing a Logical Standby Database

10.3.2 DBA_LOGSTDBY_LOG Viewat the logical standby database at 01:02:41.The APPLIED column indicates that SQL Apply has applied

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Creating a Physical Standby Database

3.2.1 Create a Backup Copy of the Primary Database DatafilesYou 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

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Creating a Physical Standby Database

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.

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Creating a Logical Standby Database

4 Creating a Logical Standby DatabaseThis 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:

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing a Logical Standby Database

10 Managing a Logical Standby DatabaseAccess 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

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing a Logical Standby Database

10.7.4 Adjust the Memory Used for LCR CacheFor 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%'

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Creating a Physical Standby Database

3.2.4 Copy Files from the Primary System to the Standby Systemthe standby system: Backup datafiles created in Section 3.2.1 Stan dby control file created in

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing a Logical Standby Database

10.3.7 V$LOGSTDBY_STATS Viewmeaningful 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

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Creating a Physical Standby Database

3.1.2 Configure Redo Transport Authenticationphysical 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

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing a Logical Standby Database

10.5.2 Using DBMS_LOGSTDBY.SKIP to Prevent Changes to Specific Schema ObjectsBy default, all supported tables in the primary database are replicated in the logical standbyDATABASE 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

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Creating a Physical Standby Database

3.1.3 Configure the Primary Database to Receive Redo Datadatabase 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.