-
Corrupted Archieve Logs
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
nvkchaitanya
- Dec 7th, 2010
In this critical situation I had a pritical example which follows this.SQL> recover database until cancel using backup controlfile;ORA-00279: change 9867098396261 generated at 03/21/2008 13:37:44 n...
Kamran Agayev A.
- Sep 8th, 2009
In this situation you're not able to recover the database. Of course, it can be done by using nonsupported and nondocumented parameter "_ALLOW_RESETLOGS_CORRUPTED" but you HAVE NOT to us...
-
Reading Oracle Control file content
Can we read Control file? If yes, then how?
lakshmi143.e
- Oct 14th, 2009
SQL> ALTER DATABASE BACKUP controlfile TO trace;
You can find the trace file which is backup of control file in udump directory.
narendra05
- Oct 2nd, 2009
Control file is the metadata of data and the information is stored in binary format. Some part of the control file can be seen by tracing it to trace (struncture of database can be seen by tracing th...
