No Archive Mode and corrupt system01.dbf
ORA-01578: ORACLE data block corrupted (file # 1, block # 39041)
ORA-01110: data file 1: 'E:\SV\DATAFILES\MPC\SYSTEM01.DBF'
Although the client had a backup of the system01.dbf file, since they were in no archive mode, I was not able to restore the datafile. Is there any other options available? The latest full, complete backup is quite old (don't ask).I did copy over the recent backup and found that system01.dbf needed logs:
SQL> select min(fhrba_Seq),max(fhrba_Seq) from X$KCVFH;
1734 1740
SQL> select hxfil FILENUMBER,fhsta STATUS,fhscn SCN, fhrba_Seq SEQUENCE,fhtnm TABLESPACE from x$KCVFH;