tag:blogger.com,1999:blog-34560741.post6535784061479583366..comments2023-11-02T12:22:23.089+03:00Comments on The Momen Blog: Oracle OpenWorld-2010: Session DownloadsAsif Momenhttp://www.blogger.com/profile/08802175768050555784noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-34560741.post-43076138845303328792011-02-13T13:39:48.595+03:002011-02-13T13:39:48.595+03:00I would like to thank to Mr.Asif Momen for his gre...I would like to thank to Mr.Asif Momen for his great presentation on Backup and Recovery<br /> <br />Recently in my organization one of our developer dropped a history table which is on Oracle 9i and this table contains around 200 million records and next day he inform me about this drop then I start searching for backup which was took by RMAN So I copy the RMAN backup on system drive and then I decided to restore only those data files which contain this table including system & undo plus archive logs<br /> <br />I restore three datafiles which contain this table including system & undo plus archive logs but here I face a problem that I could not restore all archive log and this fails my recover because the recovery was looking for a archive log which was not listed when I issue (list archivelog all) and Even I could not try for other backup because after this backup the backups was not successfully copied on tapes So in this situation I remember that Mr.Asif Momen has given a presentation on a topic Recovering an Inconsistent Database So I start following his step which he mention in his document but in my case I got ORA-600 error with different arguments and even I try till LEVEL 10 and above but it could not open the database and every time it issue same error So how I solved I would like to share with him<br /> <br />Here the steps<br /> <br />Sat Feb 12 11:28:44 2011<br />Errors in file p:\oracle\ora92\rdbms\trace\gotsprd1_ora_3756.trc:<br />ORA-00600: internal error code, arguments: [2256], [1705], [1073741824], [1705], [1912594680], [], [], []<br /> <br /> <br />Solution :<br />Formula is as follows: level_num = (1024 * 1024 * 1024 * 4 * Arg [c]) + Arg [d]) / 1024 * 1024 * 1024<br />Then alter session set events '10015 trace name adjust_scn level level_num ';<br /> <br />Example<br />(1024 * 1024 *1024 * 4 * 1705) + 1912594680) / 1024 * 1024 * 1024 = 6821.781242601573<br /> = 6822 <br /> <br />alter session set events '10015 trace name adjust_scn level 6822';<br /> <br />Finally this event alter the session and then I could able to open my database and recover the table <br /> <br />I once again thanks to Mr.Asif Momen for his document and infact without his document I could not reach to this point so I am forward to see your helpful information in future<br /><br />Sohail Siddiqui<br />Oracle DBA<br />Saudi CustomsSohail Siddiquinoreply@blogger.comtag:blogger.com,1999:blog-34560741.post-32037229008568235882010-10-02T00:53:19.601+03:002010-10-02T00:53:19.601+03:00RMAN Backup and Recovery session presented by Asif...RMAN Backup and Recovery session presented by Asif, was one of the most helpful and informative sessions that I attented during Oracle Open World. The presentation was rich in content, easy to understand and well organized. Thank you, Asif, I look forward to see more of your presentations in the futureAnonymousnoreply@blogger.com