Apres un arret brutal de la base , la base de donne , s;arrte en mode mount et ne veut pas
s'ouvrir en mode open , si-joint les messages d'erreur :
SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs ;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1:
'/apps/oracle9i/OraHome1/database/datafiles/owexp/systemowexp.dbf'C'est base de donnees Oracle 9iSQL> recover datafile '/apps/oracle9i/OraHome1/database/datafiles/owexp/systemowexp.dbf'
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
Merci
Partager