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 TSPITR


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


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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Limitations of TSPITRAfter 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Overview of RMAN TSPITRTo 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.

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Troubleshooting RMAN TSPITRA 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Purpose of RMAN TSPITRRecovery 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Basic Concepts of RMAN TSPITRThe 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Planning and Preparing for TSPITRThis 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Performing Fully Automated RMAN TSPITRIn 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Executing TSPITR with Your Own Auxiliary InstanceWith 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Naming TSPITR Auxiliary Set Data Filesnot 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

TSPITR Restrictions, Special Cases, and LimitationsSome 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Performing TSPITR with Your Own Auxiliary Instance: Scenarioillustrates 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Renaming TSPITR Recovery Set Data Files with SET NEWNAMEtakes 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.

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Preparing Your Own Auxiliary Instance for RMAN TSPITRparameters described in Table 21-5. Note: For TSPITR, the target and auxiliary database instances must be on the same host.

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Using Image Copies for Faster RMAN TSPITR PerformanceYou 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Customizing Initialization Parameters for the Automatic Auxiliary Instance in TSPITRauxiliary instance when performing TSPITR. If the file is not found, then RMAN does not generate an

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Preparing RMAN Commands for TSPITR with Your Own Auxiliary Instancefor 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Step 1: Select the Right Target Time for TSPITRIt 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Performing RMAN TSPITR Using Your Own Auxiliary InstanceTSPITR. 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

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

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Overriding Defaults for RMAN TSPITR with an RMAN-Managed Auxiliary InstanceYou 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