Saturday, August 8, 2009

Redo log corruption and Recovery

You will see any of these errors, in case of redo log corruption

ORA-16038 log %s sequence# %s cannot be archived
ORA-367 checksum error in log file header
ORA-368 checksum error in redo log block
ORA-354 corrupt redo log block header
ORA-353 log corruption near block change time

Solution:- Try to clear the log file without shutdown the database.

You have to be careful when using 'alter database clear logfile', because the command erases all data in the logfile.

eg: alter database clear logfile group 1;
alter database clear unarchived logfile group 1;

Dropping/clearing the redo logs is not possible, if there are only two log groups and the corrupt logfile belongs to CURRENT/ACTIVE, it may be needed for instance recovery. You may receive ORA-1624 error.

If you receive ORA-1624 then you have to perform incomplete recovery stopping just before the redo log file which was corrupted.

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com/

4 comments:

  1. Donkey Kong Unblocked. is exciting action game about monkeys. Donkey Kong Unblocked. new to addition. A mini Super Mario Unblocked. action game genre through classic frontier version of Flash, is one of the best Mario Games around. We choose the best Car Racing Games , best Run 3 Unblocked and best Run 4 Unblocked or Run Unblocked for you to play. You will have a pleasant experience while playing games .Play it now.

    ReplyDelete
  2. Friv games as well as runtime mistakes are not most under towards choose one simply by shock anytime you're more unprepared play free on friv.run.Online video friv  games tend to be plenty different to off-line video games, although the majority of the off-line video games these days own the big event to play remaining on line gamers, it simply isn't exactly the same encounter. Using on line internet browser video games, options get much more community depending, as they carry exactly the same environment like on line forums do. There was a real feeling of community furthermore conversation in terms of online flash games, like you will find plenty active consumers on line at the same time. Furthermore, the option to chat during the action are an additional bonus out of on line gaming, since you might synergy with other players furthermore talk about techniques so that you can beat opponents furthermore progress your ranking higher.Friv games additionally adventure games incorporate battling games, adventure games additionally mystery games where in fact the gamer is necessary to obtain several objectives. Such games will tend to be saturated in cartoon and also feature a tale line.Browser problems are more then sufficient enough to cause you to set, in spite of how cautiously one tread inside online pursuit. Especially, when you're the techno-green horn, the very first your towards greet you're setting up, upgradation as well as setup. They might appear to be peaceful petite an nevertheless may possibly end up buttressing their effect resulting in serious browser malfunctioning

    ReplyDelete
  3. Frive games line with the developing seen in all internets games business, typical players take pleasure in primary generating choices games then fewer specialized 3D designs games. Ordinary gamers such as way more sophisticated games play free on frive.link .Friv games Online Tech help professionals may be immediately accessed any sort of time anytime because they are prepared to serve you 24/7/36 Your web web browser dilemmas are definitely managed expertise. In addition they look after any sort of secret dilemmas in your system that may posses escaped your very own vision towards lay dormant in your system plus hold off towards erupt with time. When you wave their green sign, their tech experts simply take use of one's body from another location plus erase down any sort of problems that's detected. In addition they have the your body guaranteed through implanting the most effective security strategy and/or upgrading the existing strategy towards impart best performance. And avail the most effective on line tech support and luxuriate in searching the internet web browser in an optimized pace.div.Although war as well as RPG games also capturing games might be clubbed with each other with regards to their violence showcase, theyre just known within their right. Capturing games are usually very popular with hardcore players, for that reason, shop for a distinctive explain too. Of all of the games, battling games will be the most famous video games

    ReplyDelete