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
Limitations of TSPITR → After TSPITR completes, RMAN recovers the data files in the recovery set to the target time. Note … the following special cases: TSPITR does not recover query optimizer statistics for recovered … objects.You must gather new statistics after TSPITR completes. If you run TSPITR on a tablespace and bring … has two
Overview of RMAN TSPITR → To use RMAN tablespace point-in-time recovery (TSPITR) effectively, it is helpful to understand … what types of problems it can resolve, its components, what RMAN does during TSPITR, and the various … limitations and restrictions on when and how it can be run. This section explains the basic concepts, preparatory tasks, and modes of running RMAN TSPITR.
Troubleshooting RMAN TSPITR → A variety of problems can cause RMAN TSPITR to fail. This section lists possible areas to check and … fix: Filename conflicts Mismatched or incorrect TSPITR target times for sets of tablespaces and
Purpose of RMAN TSPITR → Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to … TSPITR is most useful for the following situations: To recover a logical database to a point different … tablespaces. In fact, RMAN can perform TSPITR on dropped tablespaces even when a recovery catalog is not … rather than just
Basic Concepts of RMAN TSPITR → The following sections explain RMAN TSPITR fundamentals: Common Terms Modes of RMAN TSPITR How RMAN … TSPITR Works With an RMAN-Managed Auxiliary Instance Common Terms Table 21-1 defines some common … entities that are used by RMAN TSPITR. Table 21-1 RMAN TSPITR Entities Name Explanation Target
Planning and Preparing for TSPITR → This section assumes that you have read \"TSPITR Restrictions, Special Cases, and Limitations … \". You must complete the following steps when preparing for TSPITR: Step 1: Select the Right Target Time … for TSPITR Step 2: Determine the Recovery Set Step 3: Identify and Preserve Objects That Are Lost After TSPITR
Performing Fully Automated RMAN TSPITR → In the default mode, RMAN bases as much of the configuration for TSPITR as possible on the target … database. During TSPITR, the recovery set data files are written in their current locations on the … target database (For OMF files, see \"Limitations of TSPITR\" ). The same channel configurations for … files for which names are
Executing TSPITR with Your Own Auxiliary Instance → With the preparations complete and your TSPITR commands completely planned, you are now ready to … perform TSPITR. The following steps are required: Step 1: Start the Auxiliary Instance in NOMOUNT Mode … TABLESPACE Command Step 1: Start the Auxiliary Instance in NOMOUNT Mode Before beginning RMAN TSPITR … . Do not create a control
Naming TSPITR Auxiliary Set Data Files → not specify an auxiliary set file location that is different from its original location, then TSPITR … files is to specify an auxiliary destination for TSPITR. However, RMAN supports the following … Files in TSPITR\". 4 AUXILIARY DESTINATION argument to RECOVER TABLESPACE when using an RMAN-managed … data files, then TSPITR
TSPITR Restrictions, Special Cases, and Limitations → Some database problems cannot be resolved with TSPITR. The following list explains when you cannot … perform TSPITR: If there are no archived redo logs or if the database runs in NOARCHIVELOG mode. If … TSPITR is used to recover a renamed tablespace to a point in time before it was renamed, you must … use the previous name of
Performing TSPITR with Your Own Auxiliary Instance: Scenario → illustrates the following features of RMAN TSPITR: Managing your own auxiliary instance Configuring … To use TSPITR with your own auxiliary instance: Prepare the auxiliary instance as described in … \"Preparing Your Own Auxiliary Instance for RMAN TSPITR\". Specify a password for the auxiliary instance … a RUN block to set up
Renaming TSPITR Recovery Set Data Files with SET NEWNAME → takes the following actions: Restores each specified data file to the new location during TSPITR. Uses … detects a conflict, then TSPITR fails and RMAN reports an error. The valid data file is not overwritten.
Preparing Your Own Auxiliary Instance for RMAN TSPITR → parameters described in Table 21-5. Note: For TSPITR, the target and auxiliary database instances must be on the same host.
Using Image Copies for Faster RMAN TSPITR Performance → You can enhance TSPITR performance by redirecting RMAN to use existing image copies of the recovery … image copy to perform TSPITR, and the data file copy is uncataloged from the target control file. Using … SET NEWNAME with Recovery Set Image Copies During TSPITR, RMAN looks in the specified NEWNAME … image copy, then RMAN uses
Customizing Initialization Parameters for the Automatic Auxiliary Instance in TSPITR → auxiliary instance when performing TSPITR. If the file is not found, then RMAN does not generate an
21 Performing RMAN Tablespace Point-in-Time Recovery (TSPITR) → the following sections: Overview of RMAN TSPITR TSPITR Restrictions, Special Cases, and Limitations … Planning and Preparing for TSPITR Running RMAN TSPITR: Performing Fully Automated RMAN TSPITR … Overriding Defaults for RMAN TSPITR with an RMAN-Managed Auxiliary Instance Performing
Preparing RMAN Commands for TSPITR with Your Own Auxiliary Instance → for TSPITR to be long. This situation can occur when you allocate a complex channel configuration for … auxiliary set files. You may want to store the series of commands for TSPITR in an RMAN command file … \" Planning Channels for TSPITR with Your Own Auxiliary Instance When you run your own auxiliary instance … the RECOVER TABLESPACE
Step 1: Select the Right Target Time for TSPITR → It is extremely important that you choose the right target time or SCN for your TSPITR. As noted in … \"TSPITR Restrictions, Special Cases, and Limitations\", after you bring a tablespace online after … TSPITR, you cannot use any backup from a time earlier than the moment you brought the tablespace … online. If you have a recovery
Performing RMAN TSPITR Using Your Own Auxiliary Instance → TSPITR. One reason that you might want to create your own instance is to exercise control of channels … used in TSPITR. The automatic auxiliary instance uses the configured channels of the target
Overriding Defaults for RMAN TSPITR with an RMAN-Managed Auxiliary Instance → You can customize the following aspects of RMAN TSPITR while still mostly following the procedure … described in \"Performing Fully Automated RMAN TSPITR\": Rename or relocate your recovery set data … locations after TSPITR. This may be necessary if the disk that originally contained the tablespace is not … usable. This task is