oracle 9i ORA-00376: ORA-01110: para undotbs
Hola, recientemente tengo un problema y espero me puedan ayudar.
Las consideraciones generales son:
– DB: Oracle 9i
– No hay archives
El problema es el siguiente:
Cuando quiero levantar la base de datos me la tira, el alert marca lo siguiente:
[sql]SMON: enabling tx recovery
SMON: about to recover undo segment 1
SMON: mark undo segment 1 as needs recovery
SMON: about to recover undo segment 2
SMON: mark undo segment 2 as needs recovery
SMON: about to recover undo segment 3
SMON: mark undo segment 3 as needs recovery
SMON: about to recover undo segment 4
SMON: mark undo segment 4 as needs recovery
SMON: about to recover undo segment 5
SMON: mark undo segment 5 as needs recovery
SMON: about to recover undo segment 6
SMON: mark undo segment 6 as needs recovery
SMON: about to recover undo segment 7
SMON: mark undo segment 7 as needs recovery
SMON: about to recover undo segment 8
SMON: mark undo segment 8 as needs recovery
SMON: about to recover undo segment 9
SMON: mark undo segment 9 as needs recovery
SMON: about to recover undo segment 10
SMON: mark undo segment 10 as needs recovery
Fri Aug 10 03:00:34 2012
Errors in file …..\ORA02524.TRC:
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: ‘….\UNDO01.DBF’
Fri Aug 10 03:00:34 2012
Error 376 happened during db open, shutting down database
USER: terminating instance due to error 376
Instance terminated by USER, pid = 2524
ORA-1092 signalled during: alter database open…
[/sql]
Al ver el status del datafile me marca con «RECOVERY», al intentar restaurarlo
al intentar restaurarlo me marca
[sql]ORA-00279: change 96253276 generated at 06/16/2012 03:00:36 needed for thread 1
ORA-00289: suggestion : …\WAT51_7748.ARC
ORA-00280: change 96253276 for thread 1 is in sequence #7748[/sql]
Ese archive no lo tengo, intenté colocar un arch anterior y me marcó falla (utilicé recover datafile ‘…..’)
¿Qué puedo hacer?
Me podrían apoyar, he leído que hay que poner el UNDO_MANAGEMENT en MANUAL y crear otro datafile, pero francamente me pierdo y no se eso solucione el problema.
Espero me puedan ayudar.
Gracias.