Incomplete Restore

First time I actually did this:

A dev DB was faulty and the Developers asked me to restore it to one week before (05.08.2009 - 20:00)

Action plan:

- startup force mount
- Delete datafiles via asmcmd
- rman target /
- run {
set until time "to_date('2009-08-05:20:00:00','YYYY-MM-DD:hh24:mi:ss')";
restore database;
recover database;
}

Easy =)

OERR: ORA-31696 unable to export/import %s using client specified %s method

During a full import of a DB with Datapump, I got an ORA-31696 for a table.

Woraround for this error is simply to import it afterwards with tables=owner.table_name and table_exists_action=replace (since the table is created but no data is imported)

via Lazydba