Datafile recovery in datagaurd environment

From: hrishy <>
Date: Mon, 3 Mar 2008 14:18:57 +0000 (GMT)
Message-ID: <>

Hi All

Lets assume that one of my datafile on the primary database has been corrupted in a datagaurd environment.

Can i do these steps to recover the primary db.

1)On primary do
RMAN>sql 'alter database datafile 5 offline'

2)on Standby do
RMAN>copy datafile '/db/ARON/fs1/test_d01_0.dbf_copy' to '/db/tmp/test_d01_0.dbf_copy'

3)Copy the datafile in step 2 to primary server

4)On the primary catalog the copy
RMAN>catalog datafilecopy

5)RMAN>switch datafile 5 to COPY

6)RMAN>recover datafile 5 ;

7)RMAN> sql 'alter database datafile 5 online';

will this work


Sent from Yahoo! Mail.
A Smarter Inbox.
Received on Mon Mar 03 2008 - 08:18:57 CST

Original text of this message