OpenVMS: RMAN TSPITR (Recover Tablespace ... Until...) fails with RMAN-03002 error (Doc ID 1309427.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
***Checked for relevance on 09-Apr-2013***

Symptoms


Attempting to use RMAN TSPITR to recover a tablespace results in the following errors.

RMAN> recover tablespace tools until time '10-feb-2011 17:00:00' AUXILIARY DESTINATION '$DISK1/TEST/TSPITR';
     ...
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/17/2011 13:40:48
RMAN-04014: startup failed: ORA-01078: failure in processing system
parameters
RMAN-04017: startup error description: LRM-00109: could not open parameter file 'aaa_329466'


If a DCL logical is defined for the parameter file, so that it can be opened, then the following errors will occur when the parameter file is read.


RMAN-03002: failure of recover command at 02/17/2011 13:46:16
RMAN-04014: startup failed: ORA-01261: Parameter db_create_file_dest destination
string cannot be translated
ORA-01262: Stat failed on a file destination directory
HP IPF VMS Error: 2: no such file or directory


Changes

First attempt to use RMAN TSPITR.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms