Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: recover database

    In my database 2 redolog files. but both are corrupted. so i cannot start the database. If i create these 2 redo, it also cannot start the DB. My DB is in noarchivelog mode. Help me how i can start?

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    without being in archivelog mode you are out of luck. restore your last cold backup. Since no one would run a production database without archivelog then it must be a test database and you can rebuild the database from scratch.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Jul 2011
    Posts
    5

    Wink do you have the export file?

    If you have export dump file, you might reinstall your database and import your schema back to your new database.
    In that case you can recover your database till when you backup your export file.

Tags for this 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
  •