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:

at

2 comments:

  1. Anonymous12:53 AM, October 02, 2010

    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

    ReplyDelete
  2. Sohail Siddiqui1:39 PM, February 13, 2011

    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 ';

    Example
    (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

    ReplyDelete