DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: HELP: I am new in this forum and appologise if i mistake

  1. 02-25-2008, 01:12 PM #1
    muyeen70
    muyeen70 is offline Junior Member
    Join Date
    Feb 2008
    Posts
    10

    Angry HELP: I am new in this forum and appologise if i mistake

    UBDOTBS2 needs recovery. And here is the alert log file for last few days. Last cold back up was on 2/8/2008. Need help how to recovery the database.
    I am new as DBA and i don't know where to go. Please accept my appology if i does any mostake. I include the alert log file as attachment.
    Thanks in advance.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 02-25-2008, 01:29 PM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    There is a well known process to fix your problem.

    You can access here a nicely worded step-by-step version of it:

    http://www.dba-oracle.com/oracle_tip...o_segments.htm
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  3. 02-25-2008, 01:36 PM #3
    muyeen70
    muyeen70 is offline Junior Member
    Join Date
    Feb 2008
    Posts
    10
    Do you think i need to create new control file, the reason i am asking is some one suggest me that my control file is corrupt, i believe you already sttudied my alert log file. I am very new as DBA and my database is down for few days.
    Reply With Quote Reply With Quote
  4. 02-25-2008, 01:37 PM #4
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Do you have space on D drive ?

    You can try increasing the size of the undo tablepsace no ?

    whats the size of this file ?

    D:\ORACLE\ORADATA\OPAPRD\UNDOTBS02.DBF

    do you need to have
    undo_retention = 10800

    Your alert logs says the database is already open

    Completed: alter database open

    whats the content of
    d:\oracle\admin\opaprd\bdump\opaprd_pmon_132.trc

    rgeards
    Hrishy
    Last edited by hrishy; 02-25-2008 at 01:40 PM.
    Reply With Quote Reply With Quote
  5. 02-25-2008, 01:53 PM #5
    muyeen70
    muyeen70 is offline Junior Member
    Join Date
    Feb 2008
    Posts
    10

    Here is what i did from the begaining..

    As i am very new i don't have enough confidence, if you look at the attachement you can see what i did...Last querry in the attachement was first i ran.
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  6. 02-25-2008, 01:53 PM #6
    muyeen70
    muyeen70 is offline Junior Member
    Join Date
    Feb 2008
    Posts
    10

    Here is what i did from the begaining..

    As i am very new i don't have enough confidence, if you look at the attachement you can see what i did...Last querry in the attachement was first i ran.
    Reply With Quote Reply With Quote
  7. 02-25-2008, 02:10 PM #7
    muyeen70
    muyeen70 is offline Junior Member
    Join Date
    Feb 2008
    Posts
    10
    Dump file d:\oracle\admin\opaprd\bdump\opaprd_pmon_132.trc

    Mon Feb 18 22:52:48 2008

    ORACLE V9.2.0.7.0 - Production vsnsta=0

    vsnsql=12 vsnxtr=3

    Windows 2000 Version 5.2 Service Pack 1, CPU type 586

    Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production

    With the OLAP and Oracle Data Mining options

    JServer Release 9.2.0.7.0 - Production

    Windows 2000 Version 5.2 Service Pack 1, CPU type 586

    Instance name: opaprd



    Redo thread mounted by this instance: 1



    Oracle process number: 2



    Windows thread id: 132, image: ORACLE.EXE





    *** 2008-02-18 22:52:48.125

    *** SESSION ID:(1.1) 2008-02-18 22:52:48.125

    error 204 detected in background process

    ORA-00204: error in reading (block , # blocks ) of controlfile
    Reply With Quote Reply With Quote
  8. 02-25-2008, 02:25 PM #8
    muyeen70
    muyeen70 is offline Junior Member
    Join Date
    Feb 2008
    Posts
    10
    I have not shut down the databse yet. Should i do that?
    Reply With Quote Reply With Quote
  9. 02-25-2008, 02:29 PM #9
    muyeen70
    muyeen70 is offline Junior Member
    Join Date
    Feb 2008
    Posts
    10
    D:\ORACLE\ORADATA\OPAPRD\UNDOTBS02.DBF is 204k
    Reply With Quote Reply With Quote
  10. 02-25-2008, 03:31 PM #10
    muyeen70
    muyeen70 is offline Junior Member
    Join Date
    Feb 2008
    Posts
    10
    Hrishy,
    Do you know any solution?
    Thanks
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width