RE: Urgent! Online redo log files corruption

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Sun, 22 Oct 2000 07:38:30 -0700 (PDT)
Message-Id: <10657.119919@fatcity.com>

Hi Winne !

There is absolutely no problem in using the hidden parameter if your database is shutdowned using NORMAL/IMMEDIATE options.

The problem comes only when you have shutdowned using ABORT (with different scn in datafiles and system files). The parameter internally takes the LOWEST SCN and ignores the other changes after that.

One typical example can be SYSTEM tablespace is with scn x and data tabelspce with checkpoint scn > x. In this case (after opening the database with the hidden parameter) you may have the definition about the table in the dictionary but the table will not exist in the data tablespace.

Too much of travel in this week. have a nice weekend.. !

---

Warm Regards,
K Gopalakrishnan
Bangalore, INDIA

---

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. Received on Sun Oct 22 2000 - 09:38:30 CDT