Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Restore datafile from full RMAN backup

Restore datafile from full RMAN backup

From: Wojciech Skrzynecki <wojciech.skrzynecki_at_gmail.com>
Date: Tue, 7 Nov 2006 15:29:46 +0100
Message-ID: <e44afebe0611070629i2ca3e920l29912be8299089c7@mail.gmail.com>


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-l
Received on Tue Nov 07 2006 - 08:29:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US