Datafile crashed [message #171736] |
Thu, 11 May 2006 05:32 |
Bharath Kumar ,V
Messages: 18 Registered: February 2004
|
Junior Member |
|
|
Hi all,
I've a tablespace which has 50 datafile spread across 5 disk, today one of my disk got crashed can you please tell me the steps how do I recover the data from the crashed disk(my server is running in ARCH mode)?
TIA
Regards
Bharath.
|
|
|
Re: Datafile crashed [message #171739 is a reply to message #171736] |
Thu, 11 May 2006 05:37 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
First restore the "crashed" files from backup. When done, you can start the recovery process.
Here is an RMAN example:
RMAN> SQL 'ALTER TABLESPACE ... OFFLINE';
RMAN> RESTORE TABLESPACE ...;
RMAN> RECOVER TABLESPACE ...;
RMAN> SQL 'ALTER TABLESPACE ... ONLINE';
|
|
|
|
|
|