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

(Doc ID 1309427.1)

Last updated on DECEMBER 12, 2017

Applies to:

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


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
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


First attempt to use RMAN TSPITR.


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