DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DataBase Administration

  1. 01-21-2004, 05:30 AM #1
    imranmemon
    imranmemon is offline Junior Member
    Join Date
    Jan 2004
    Location
    Sukkur - Sindh (Pakistan)
    Posts
    1

    Lightbulb DataBase Administration

    Dear DBAs
    I am facing a problem that is "Data Block #xxx Corrupt". The infected file is "sysorcl.ora". Please give me solution.
    Reply With Quote Reply With Quote
  2. 01-21-2004, 06:03 AM #2
    aspdba
    aspdba is offline Member
    Join Date
    Aug 2002
    Posts
    115
    is this file ur system datafile?

    Start srvmgr or sqlplus as SYSDBA

    1. Startup Mount
    2. Recover Database;

    If you still get above error.

    1. SHUTDOWN IMMEDIATE;
    2. Backup current database regardless of state.
    3. Locate all your archive logs.
    4. Restore corrupted system datafile
    5. startup mount
    6. recover database

    HTH
    Reply With Quote Reply With Quote
  3. 01-21-2004, 05:21 PM #3
    kris109's Avatar
    kris109
    kris109 is offline Professor Kris
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    RMAN and 9i? Use BMR.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA
    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