NOLOGGING -"before backup" the datafile needs media recovery
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 20 Aug 2005 10:55:25 -0400
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.
Other related posts:
- » NOLOGGING -"before backup" the datafile needs media recovery
