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 FROM


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


High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

Outage Class Description ExamplesTable 9-4 Scheduled Outages Outage Class Description Examples Site-wide The entire site where the current production database resides is unavailable. This is usually known well in advance and can be scheduled. Scheduled power outages Site maintenance Regular planned switchovers to test infrastructure Hardware maintenance (node impact) This is scheduled downtime of a database server node for hardware

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

Scope of Outage Reason for Outage Recovery Steps for "Data Guard Only" Architecture Recovery Steps for…Table 9-6 Recovery Steps for Scheduled Outages on the Secondary Site Scope of Outage Reason for Outage Recovery Steps for "Data Guard Only" Architecture Recovery Steps for MAA Site Site shutdown Before the outage: "Preparing for Scheduled Secondary Site Maintenance" After the outage: "Restoring Fault Tolerance after Secondary Site or Clusterwide Scheduled Outage" Before the outage: "Preparing for

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

9.1.1 Recovery Steps for Unscheduled Outages on the Primary Sitearchitectures have a secondary site to protect from site disasters. The estimated recovery times (ERT) are … strictly examples derived from customer and actual testing experiences and do not reflect a

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

9 Recovering from OutagesThis chapter describes scheduled and unscheduled outages and the Oracle recovery process and architectural framework that can manage each outage and minimize downtime. This chapter contains the following sections: Recovery Steps for Unscheduled Outages Recovery Steps for Scheduled Outages

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

Scope of Outage Reason for Outage Recovery Steps for "Database Only" Architecture Recovery Steps for…Table 9-5 Recovery Steps for Scheduled Outages on the Primary Site Scope of Outage Reason for Outage Recovery Steps for "Database Only" Architecture Recovery Steps for "RAC Only" Architecture Recovery Steps for "Data Guard Only" Architecture Recovery Steps for MAA Site Site shutdown Downtime for entire duration Downtime for entire duration Database Switchover Complete or Partial Site Failover Database

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

Reason for Outage Recovery Steps for "Data Guard Only" Architecture Recovery Steps for MAATable 9-3 Recovery Steps for Unscheduled Outages of the Standby Database on the Secondary Site Reason for Outage Recovery Steps for "Data Guard Only" Architecture Recovery Steps for MAA Standby apply instance failure Restart node and standby instance. Restart recovery. If there is only one standby database and if maximum database protection is configured, then the production database will shut down

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

Reason for Outage Recovery Steps for "Database Only" Architecture Recovery Steps for "RAC Only" Architecture…… Restore from tape backups. Recover database. ERT: hours to days Restore site. Restore from tape … /A ERT: hours to days Restore cluster or restore at least one node. Restore from tape backups … minimize data loss. User error ERT: minutes Recovering from User Error with Flashback Technology ERT … : minutes

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

9.2.3 Preparing for Scheduled Secondary Site MaintenanceTo achieve continued service during a secondary site scheduled outage, downgrade the maximum protection mode to maximum availability or maximum performance. When you are scheduling secondary site maintenance, consider that the duration of a site-wide or clusterwide outage adds to the time the standby lags behind the production database, which lengthens the time to restore fault tolerance. Table 9-7

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

Production Database Protection Mode Reason for Outage Preparation Steps for "Data Guard Only" Architecture…Table 9-7 Preparing for Scheduled Secondary Site Maintenance Production Database Protection Mode Reason for Outage Preparation Steps for "Data Guard Only" Architecture and MAA Maximum protection Site shutdown Switch the production data protection mode to either maximum availability or maximum performance See Also: "Changing the Data Protection Mode" Maximum protection Hardware maintenance (clusterwide

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

9.1.2 Recovery Steps for Unscheduled Outages on the Secondary SiteOutages on the secondary site do not directly affect availability because the clients always access the primary site unless there is a switchover or failover. Outages on the secondary site may impact the MTTR if there are concurrent failures on the primary site. For most cases, outages on the secondary site can be managed with no impact on availability. However, if maximum protection mode is part

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

9.1 Recovery Steps for Unscheduled Outagesdetection and recovery from failures. Detection is described in Chapter 8, "Using Oracle Enterprise … deleted from a table Widespread damage (needs drastic action to avoid downtime) Application errors result

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

9.2 Recovery Steps for Scheduled OutagesScheduled outages are planned outages. They are required for regular maintenance of the technology infrastructure that supports the application and include tasks such as hardware maintenance, repair, and upgrades; software upgrades and patching; application changes and patching; and changes to improve performance and manageability of systems. Scheduled outages should be scheduled at times best suited

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

9.2.1 Recovery Steps for Scheduled Outages on the Primary SiteIf the primary site contains the production database and the secondary site contains the standby database, then the outages on the primary site are the ones of most interest. Solutions for these outages are critical for continued availability of the system. Table 9-5 shows the recovery steps for scheduled outages on the primary site.

High Availability Architecture and Best Practices, 10g Release 1 (10.1)

9 Recovering from Outages

9.2.2 Recovery Steps for Scheduled Outages on the Secondary SiteOutages on the secondary site do not impact availability because the clients always access the primary site unless there is a switchover or failover. Outages on the secondary site may affect the MTTR if there are concurrent failures on the primary site. Outages on the secondary site can be managed with no impact on availability. If maximum protection database mode is configured, then downgrade the

Application Developer's Guide, 10g Release 1 (10.1)

B Upgrading From Express Server

B.4.5 Example: Converting the XADEMO Database to Standard FormThis example uses an EIF file that contains objects and Oracle Express Objects metadata from an … steps to create a standard form analytic workspace from this file. Log in to your Oracle database as … Database as the XADEMO user. Open OLAP Worksheet. Create an analytic workspace from the EIF file … : AW CREATE xademo IMPORT ALL

Concepts, 10g Release 1 (10.1)

9 Managing From Anywhere - EM2Go

Mobile SecurityEM2Go offers a highly secure solution as it leverages the Enterprise Manager security features. EM2Go utilizes HTTPS communications and the security model of administrator privileges and roles. When you connect your browser to the EM2Go URL, a login prompt is issued for you to enter your Enterprise Manager preferred credentials ( Figure 9-1 ). You will then only see the targets to which you have been

Developer's Guide, 10g Release 1 (10.1)

Obtaining Data From an OracleDataReader

Obtaining LONG and LONG RAW Datait) The requested data is fetched from the database when the appropriate typed accessor method

Application Developer's Guide, 10g Release 1 (10.1)

B Upgrading From Express Server

B.2.2 CommunicationsOracle OLAP provides communications through Oracle Call Interface (OCI) and Java Database Connectivity (JDBC). OLAP Worksheet uses XCA for communication with the analytic workspace. However, XCA is not supported for user-developed applications and may produce unexpected results. SNAPI is no longer available. Session sharing is not supported.

Application Developer's Guide, 10g Release 1 (10.1)

B Upgrading From Express Server

B.2.3 MetadataThe BI Beans can query data that is stored either in an analytic workspace or in relational tables. The database administrator defines OLAP Catalog metadata for both types of data source. The metadata is stored in tables and views. Database standard form is a type of metadata stored in analytic workspaces for use by the server tools provided in Analytic Workspace Manager. This metadata is stored in

SQL Reference, 10g Release 1 (10.1)

Selecting from the DUAL Table

Selecting from the DUAL Table, DUMMY, defined to be VARCHAR2(1), and contains one row with a value X. Selecting from the DUAL table is … expression from any table, but the value will be returned as many times as there are rows in the table … . Please refer to "SQL Functions " for many examples of selecting a constant value from DUAL.