Home » RDBMS Server » Backup & Recovery » control file corrupted (10g)
control file corrupted [message #317401] Thu, 01 May 2008 01:17 Go to next message
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?
Re: control file corrupted [message #317402 is a reply to message #317401] Thu, 01 May 2008 01:19 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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.
Re: control file corrupted [message #317404 is a reply to message #317402] Thu, 01 May 2008 01:30 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

that i know . i want the exact step.
Re: control file corrupted [message #317406 is a reply to message #317401] Thu, 01 May 2008 01:34 Go to previous messageGo to next message
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
Re: control file corrupted [message #317409 is a reply to message #317406] Thu, 01 May 2008 01:53 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

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


Current Time: Tue Dec 06 10:07:06 CST 2016

Total time taken to generate the page: 0.05354 seconds