Este un blog que cambio de rumbo... antes era relacionado a "n" temas ahora será exclusivo para detallar todo lo que pude aprender en Oracle =)

Mostrando las entradas con la etiqueta sybex.. Mostrar todas las entradas
Mostrando las entradas con la etiqueta sybex.. Mostrar todas las entradas

miércoles, 14 de octubre de 2009

RECUPERANDO BD EN ORACLE - cuando pierdes UN control file(resumen sybex)

Losing one of the multiplexed control file immediately aborts the instance.
1- shutdown abort
2- copy one of the good copies of the control file to the location of the corrupted or missings control file.
if the corrupted Cfile resided on a failed disk , copy it to another suitable location and update the initialization parameter to update the cfile reference or you can remove the reference from this initialization parameter until you find a suitable location.
you must have at least two control files in your Db.
3-start the instance with startup.

you´ll change the initialization parameter control_file using the alter system set scope=spfile when the instance is started in no mount mode.