Results 1 to 2 of 2

Thread: redolog

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: redolog

    Hi friends,

    My database is crashed with redo log status(1 redo log active,2 redo current).

    So I will loose data from both of these redo log files?

    pls explain
    regrds
    sudheer

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Hi Sudheer,

    If you mean database crash (Not instance), i.e, media failure then...

    (1) If your database was operating in NOARCHIVELOG mode, then you lost your data and you have to restore from the last recent backup.

    (2) But if your database was in ARCHIVELOG mode, then complete recovery is possible provided you have all the archived redo logs available. In this case, you are not lossing any data.

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

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