Restore datafile from full RMAN backup
- From: "Wojciech Skrzynecki" <wojciech.skrzynecki@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 7 Nov 2006 15:29:46 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
