OraFAQ Forum: Backup & Recovery » control file corrupted

Home » RDBMS Server » Backup & Recovery » control file corrupted (10g)

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

control file corrupted [message #317401]

Thu, 01 May 2008 01:17

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

hi all,

i have 2 control files in which 1 is corrupted and need to recover to up the database.

below are the control file directories:

/dev/rd/dbrep/rdsk/d104

/dev/rd/dbrep/rdsk/d105

can anybody tell me the steps to recover my corrupted control file in order to up the database?

Report message to a moderator

Re: control file corrupted [message #317402 is a reply to message #317401]

Thu, 01 May 2008 01:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i have 2 control files in which 1 is corrupted and need to recover to up the database.

Use the 1 which is not corrupt.

Report message to a moderator

Re: control file corrupted [message #317404 is a reply to message #317402]

Thu, 01 May 2008 01:30

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

that i know . i want the exact step.

Report message to a moderator

Re: control file corrupted [message #317406 is a reply to message #317401]

Thu, 01 May 2008 01:34

prashant.pawar
Messages: 6
Registered: May 2008

Junior Member

1. Shutdown the instance
2. cp /xx/good_copy_01.ctl /xx/new_copy_02.ctl
3. make both entries in pfile or spfile
control_files=/xx/good_copy_01.ctl,/xx/new_copy_02.ctl
4. start the database using pfile or spfile

if you are using raw devices then use dd command to copy.

-Prashant

Report message to a moderator

Re: control file corrupted [message #317409 is a reply to message #317406]

Thu, 01 May 2008 01:53

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

thanks prashanth

Report message to a moderator

Previous Topic:	Can Flashback function recover tablespace that I dropped?
Next Topic:	How do we identify the corrupted block through RMAN?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 10 10:52:56 CDT 2024