Re: rman fail on backup control file
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 16 Aug 2018 16:18:13 -0400
On 08/15/2018 07:21 PM, Jeff Chirco wrote:
I have an 10g XE database that is failing during rman backup.
ORA-19624: operation failed, retry possible
ORA-19599: block number 10014 is corrupt in control file
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE.ORA
I am not sure what SNCFXE.ORA is but I believe it is some snapshot
control file backup. Anybody know how to recover for this? Do I need
to do a full recovery from controlfile trace?
Hopefully, you have more than one control file? If you do, please copy
the correct one over the corrupt
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\SNCFXE.ORA file.
Check your control_files parameter in the instance. If you don't have
more than one, try dumping it to trace (ALTER DATABASE BACKUP
CONTROLFILE TO TRACE AS 'C:\temp\ctlfile.sql' NORESETLOGS) then shutting
down the instance and re-creating the control file.
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
//www.freelists.org/webpage/oracle-l
Other related posts: