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'
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'
Комментариев нет:
Отправить комментарий