ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would GET error below ORA-01194: file 1 needs more recovery TO be consistent ORA-01110: DATA file 1: '+GPI/gpi/datafile/system.789.232322323'
DB mit dem folgenden Parameter „_allow_resetlogs_corruption=true“ öffnen:
Set this parameter:
startup mount; recover DATABASE USING backup controlfile until cancel; # Answer cancel ALTER DATABASE OPEN resetlogs;
Alternativ bis zur letzen SCN die in den Headern der Datendateien zu erkennen sind:
SELECT STATUS,checkpoint_change#,checkpoint_time, resetlogs_change#,resetlogs_time,fuzzy FROM v$datafile_header; -- scn aus obigen Statement eintragen ALTER DATABASE RECOVER UNTIL CHANGE <SCN> USING BACKUP CONTROLFILE;
ALTER SYSTEM SET "_allow_resetlogs_corruption"= TRUE SCOPE = SPFILE; ALTER SYSTEM SET undo_management=MANUAL SCOPE = SPFILE; startup mount ALTER DATABASE OPEN resetlogs; CREATE UNDO TABLESPACE undo1 datafile '<my _data_path>UNDO02.dbf' SIZE 200m autoextend ON maxsize unlimited; ALTER SYSTEM SET undo_tablespace = UNDO02 SCOPE=spfile; . ALTER system SET undo_management=auto scope=spfile; shutdown IMMEDIATE startup
siehe http://neerajoracledba.blogspot.de/2014/07/ora-01194-file-1-needs-more-recovery-to.html