Monday, September 27, 2010

Oracle OpenWorld-2010: Session Downloads

I received an email from Oracle Content Team saying the OOW-2010 sessions are now available for download from OpenWorld and JavaOne and Oracle Develop On Demand.

Login to the portal using your username/password and enjoy wealth of information.

Sessions are available in Flash Audio, MP3 Audio, PPT, and PDF format. I noticed few sessions tagged as "Coming Soon". Do check back your favorite session again.

I have received many email requests from the attendees of my session asking for a place to download my OOW presentation. You may download it from the above link. Below is an example screenshot:


Anonymous said...

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 future

Sohail Siddiqui said...

I would like to thank to Mr.Asif Momen for his great presentation on Backup and Recovery

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

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

Here the steps

Sat Feb 12 11:28:44 2011
Errors in file p:\oracle\ora92\rdbms\trace\gotsprd1_ora_3756.trc:
ORA-00600: internal error code, arguments: [2256], [1705], [1073741824], [1705], [1912594680], [], [], []

Solution :
Formula is as follows: level_num = (1024 * 1024 * 1024 * 4 * Arg [c]) + Arg [d]) / 1024 * 1024 * 1024
Then alter session set events '10015 trace name adjust_scn level level_num ';

(1024 * 1024 *1024 * 4 * 1705) + 1912594680) / 1024 * 1024 * 1024 = 6821.781242601573
= 6822

alter session set events '10015 trace name adjust_scn level 6822';

Finally this event alter the session and then I could able to open my database and recover the table

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

Sohail Siddiqui
Oracle DBA
Saudi Customs