четверг, 14 февраля 2013 г.

RMAN-06094

If you don't backup tablespace because, it is test, for example:

CONFIGURE EXCLUDE FOR TABLESPACE 'dr2006';

You will get rman error then try to recover database:

RMAN-06094: datafile 32 must be restored

Just recover without it:

RMAN> recover database skip tablespace dr2006,dr2007,dr2008,dr2009,dr2010;

Before alter database open resetlogs

alter database datafile 31 offline drop;

ORA-01157: cannot identify/lock data file 31 - see DBWR trace file
ORA-01110: data file 31: '/u13/oradata/bp/dr2006.dbf'