Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot restore controlfiles in hpux

Glenn Joseph Andal
Frequent Advisor

Cannot restore controlfiles in hpux

Can someone help us on this?
We are restoring our full database thru a filesystem level backup but unfortunately two of our control files control01.ctl and control03.ctl are both receiving the same error file is active/unrecoverable during this retry completed. Can someone help us address this.

Thank you ver much
5 REPLIES
Yogeeraj_1
Honored Contributor

Re: Cannot restore controlfiles in hpux

hi,

You can just copy the good one to the corrupted ones.

i.e.
cp -p control02.ctl control01.ctl
and
cp -p control02.ctl control03.ctl

NB. You can always rebuild the control files if you really need to if you have backed it up to trace (but doing so requires you to use the RESETLOGS option).


regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: Cannot restore controlfiles in hpux

hi again,

if you still unsure about what to do, you can read more on that issue on metalink note:
1014504.6 - Recovering From A Lost Control File

alternatively, you can also create a Tar for further assistance from Oracle.

best regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Indira Aramandla
Honored Contributor

Re: Cannot restore controlfiles in hpux

Hi Glenn,

Yes as other said, if you have lost the current control file, or the current control file is inconsistent with files that you need to recover, you need to recover either by using a backup control file command or create a new control file. You can also recreate the control file based on the current one using the 'backup control file to trace' command which will create a script for you to run to create a new one.

Recover database using backup control file command must be used when using a control file other that the current. The database must then be opened with resetlogs option.

Indira A

Never give up, Keep Trying
Steven E. Protter
Exalted Contributor

Re: Cannot restore controlfiles in hpux

I would shut the database and copy and modify the one good control file left.

Your backup was done with the database down? Otherwise it is fuzzy and is of little recovery value.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Glenn Joseph Andal
Frequent Advisor

Re: Cannot restore controlfiles in hpux

tnx