OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » Datafile crashed

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Re: Datafile crashed [message #171739 is a reply to message #171736]

Thu, 11 May 2006 05:37

Frank Naude
Messages: 4579
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';

Report message to a moderator

Re: Datafile crashed [message #171785 is a reply to message #171739]

Thu, 11 May 2006 08:05

Bharath Kumar ,V
Messages: 18
Registered: February 2004

Junior Member

Thanks for your reply. Sorry unfortunately I've not configured RMAN can you please explain normal method to recover the data.

--
Bharath.

Report message to a moderator

Re: Datafile crashed [message #171914 is a reply to message #171785]

Fri, 12 May 2006 04:29

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Hi,
it would probably be most advantageous for you to do a bit of research before you go leaping in:

http://otn.oracle.com/pls/db92/db92.drilldown?levelnum=2&toplevel=a96572&method=FULL&chapters=0&book=&wildcards=0 &preference=&expand_all=&verb=&word=media+recovery+#a96572

for Oracle documentation on User Managed backup and recovery

Jim

Report message to a moderator

Re: Datafile crashed [message #173115 is a reply to message #171914]

Fri, 19 May 2006 08:28

lakher
Messages: 14
Registered: April 2006

Junior Member

use os command copy crashed" files from backup,use sqlplus
alter tablespace offline
recover tablespace
alter tablespace online

Report message to a moderator

Previous Topic:	data block corruption
Next Topic:	oracle error ORA-01200

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:51:47 CDT 2024