Hi,
I am using oracle database 10g (10.2.0.1) in OEL 5.I am trying to perform TSPITR and performed it successfully using the below command.
run
{
recover tablespace USERS until time "to_date('28-JAN-14 21:30:00','dd-mon-rr hh24:mi:ss')"
auxiliary destination '/u01';
}
Now i am trying to perform TSPITR UNTIL 20:00:00 but it shows the error
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "USERS"
1.)Does TSPITR is performed successfully we cannot perform TSPITR again on same tablespace to time earlier than it was done before????
2.)Does TSPITR uses backups or only archive log is enough??
Regards,
007