Hello,
i am trying to restore a table 3 days back based on Oracle log the process goes ok then suddenly the following error is thrown in the log.
using restore table point in time recovery method in Oracle 12cR1 on Red Hat Linux OS:
RMAN>run
{
RECOVER TABLE dummy.test1
UNTIL SCN 7836442
AUXILIARY DESTINATION '/home/oracle/app/data/'
DATAPUMP DESTINATION '/tmp/dumpfiles/'
DUMP FILE 'dummy_test1_table.dmp'
notableimport;
}
The Error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/16/2018 14:18:30
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01180: can not create datafile 1
any suggestions ??