Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2004
    Posts
    60

    Unanswered: Rebuilding Oracle Instance

    Hi,

    One of my Oracle 10g Server Crashed, but i have the data, control & other files copied to another system where i need to rebuild the Oracle instance using this files.

    Please let me know the steps to be followed in Order to get back my Oracle Instance & Data on the New System.

    Regards

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What happened?

    If the DB does not start using original files in original positions, then moving the files is useless.

    what clues exist within alert_SID.log file?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    It won't be easy. Is there a backup of the database that can be restored from?

    If the OS crashed, there is a probability that the files you have are not consistent. If you have the redo logs, and the most recent archive logs, you might be able to get the instance running again, but the effort involved is significantly higher than a simple restore from backup. The steps would be highly OS dependent as well.

  4. #4
    Join Date
    Oct 2004
    Posts
    60
    no backups. The old system crashed completely. All we have now is all the files but no backups. Some sort of Virus Attack and the old system is unsuable now. Wish it was SQL Server which crashed, All i had to do is just get the Database Files and Attach it to the new SQL Server.

    Yeah, I tried to recreate the Control File and i was able to create the DB but it is not letting me to open it.

    ERROR at line 1:
    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file 1: 'G:\ORACLE\PRODUCT\10.2.0\ORADATA\DB1\SYSTEM01.DBF '
    Last edited by edwin_fredrick; 08-07-12 at 12:28.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >no backups.
    Since data was not worth being backed up, it is not worth wasting time trying to recover.
    Without the old REDO files, the DB is inconsistent & won't open.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Oct 2004
    Posts
    60
    Thanks Everyone, I was able to clone DB to another server using old init.ora & the old trace file for creating control files with some modification and was able to bring it up.

Posting Permissions

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