On test server I had to restore database (3TB).
Due to network issue RESTORE (not recovery) process failed. In normal situation I have to start restore process from beginning once again but I already have almost 2.5 TB restored. How to use this data?
Database is in mount mode and in view V$DATAFILE_COPY we have information about file_id and datafile name (this information is needfull if OMF is used).
select 'set newname for datafile '||FILE#||' to '''||name||''';' from V$DATAFILE_COPY where name is not null order by file#;
This query generate set newname for all datafiles already restored.
Due to network issue RESTORE (not recovery) process failed. In normal situation I have to start restore process from beginning once again but I already have almost 2.5 TB restored. How to use this data?
Database is in mount mode and in view V$DATAFILE_COPY we have information about file_id and datafile name (this information is needfull if OMF is used).
select 'set newname for datafile '||FILE#||' to '''||name||''';' from V$DATAFILE_COPY where name is not null order by file#;
This query generate set newname for all datafiles already restored.
run {
set until time "to_date('2015-01-05 00:11:00','yyyy-mm-dd hh24:mi:ss')";
<generated set newname>
<generated set newname>
restore database;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
recover database DELETE ARCHIVELOG MAXSIZE 90G;
}
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
recover database DELETE ARCHIVELOG MAXSIZE 90G;
}
and if we run this script, rman continue restore process.
If in v$datafile_copy you don't have information for some datafiles, then RMAN not restored then already and for these datafiles you have to created fake name.
