Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> NOLOGGING -"before backup" the datafile needs media recovery

NOLOGGING -"before backup" the datafile needs media recovery

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sat, 20 Aug 2005 10:55:25 -0400
Message-ID: <f09dd62805082007552e0f226f@mail.gmail.com>


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-l
Received on Sat Aug 20 2005 - 09:57:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US