Re: oracle error message

From: giridhar <tgiridhar_at_yahoo.com>
Date: 7 May 2003 07:18:17 -0700
Message-ID: <c7b5ba55.0305070618.6455745d@posting.google.com>

Error: ORA 333
Text: redo log read error block <num> count <num>

---

Cause: An error occurred while reading the redo log file.

        Other messages will accompany this message and will give the name of 
        the file.

Action: Restore access to the file or get another copy of the file.

you may need to reciver the db.

1. connect internal
2. startup mount
3. recover database until cancel

If "recovery complete" is not returned and you are prompted for an archivelog which DOES NOT exist, then apply the online redologs.

At the prompt enter the full path name to a member of your oldest online redolog group. Apply a member of all other groups if prompted for further recovery.

If "recovery complete" is not returned and you are prompted for an archivelog which DOES exist, then apply the archivelogs and if necessary, the online redologs as above.    

At the prompt press return.

4.alter database open resetlogs

5. Take a cold backup of the database since you have just opened the

   database using the resetlogs option. Received on Wed May 07 2003 - 09:18:17 CDT