Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Restore datafile from full RMAN backup
Hello
I have a question about RMAN and recovery. In my product database I have
two files with the same name but other localizations. I use
duplication to prepare development environment on other server. Recently
after duplicating a big database (with the same name of files) error
occurred.
RMAN-06136: ORACLE error from auxiliary database: ORA-19563: header
validation failed for file.
Now I know that problem concern double-name files. RMAN recovered two
files with the same name to the one catalog (Unix). I tried to move
one file to other location and create new controlfiles with correct
path but I got an error:
ORA-01110: data file 120: '/u01/oracle/oradata/DENT/OREM_IDX_41.dbf'
ORA-01110: data file 120: '/x09/oracle/oradata/DENT/ OREM_IDX_41.dbf''
My question - is it possible to recover only one datafile using RMAN to
the new location?
Very important is that file must be from the same time as my script to
duplicate.
run
{
set until time "2006-11-03 15:00:00";
allocate auxiliary channel ch1 type 'SBT_TAPE'
parms'ENV=(NB_ORA_CLIENT=xxx.domain.com)';
allocate auxiliary channel ch2 type 'SBT_TAPE'
parms'ENV=(NB_ORA_CLIENT=xxx.doamin.com)';
.
set newname for datafile 120 to ''/u01/oracle/oradata/DENT/OREM_IDX_41.dbf';
.
set newname for datafile 129 to ''/u01/oracle/oradata/DENT/OREM_IDX_41.dbf'';
DUPLICATE TARGET DATABASE TO....
..}
Recover one file takes me 10-20 minutes, while database restore takes around 6 hours
Thanks for help
-- Wojciech Skrzynecki Database Administrator -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 07 2006 - 08:29:46 CST
![]() |
![]() |