Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> NOLOGGING -"before backup" the datafile needs media recovery
Fortunately this happened in our dev environment but still I am trying to
recover the data if possible.
Version :9.2.0.6 <http://9.2.0.6>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: 'Z:\ORADATA\TOSHDB\CRMF01.DBF'
SQL> alter database open;
Database altered.
SQL> select count(*) from t_nologging;
select count(*) from t_nologging
*
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 4, block # 12692) ORA-01110: data file 4: 'Z:\ORADATA\TOSHDB\CRMF01.DBF' ORA-26040: Data block was loaded using the NOLOGGING option
I loaded data using NOLOGGING option on Friday (10/19/05) and BEFORE I DO BACKUP the datafile(CRMF01.DBF- where nologging table resides) got lost. Now I restored CRMF01.DBF from Wednesday's (10/17/05) Full database backup and recovered.
There are some LOGGING DMLs happened on the subject table between 10/17/05
and 10/19/05.
How to recover those transactions?
I don't concern about Friday's work because I can load them again.
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 20 2005 - 09:57:22 CDT
![]() |
![]() |