Rman Restore Table Fails with ORA-29283 RMAN-06962 RMAN-06960 ORA-31626 in 12c

(Doc ID 2231855.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Rman restore table fails with Below error during the export phase of the recovery table

When trying to restore a table the following error occurs

Could not delete auxiliary instance file tspitr_test.dmp
ORACLE error from target database:
ORA-29283: invalid file operation

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/06/2017 10:21:10
RMAN-06962: Error received during export of metadata
RMAN-06960: EXPDP> ORA-31626: job does not exist
ORA-31637: cannot create job TSPITR_EXP_test for user SYS
ORA-39062: error creating master process DM00
ORA-31613: Master process DM00 failed during startup.


Script used :-

RECOVER TABLE scott.sales UNTIL SCN 60678405 AUXILIARY DESTINATION '/u03/backup/datafiles/aux' REMAP TABLE 'scott.'sales':'sales_new';


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