Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-01578 data block corrupted on standby
Hi, all.
I'm trying to manually create a standby database on
Solaris 2.6 Oracle 8.0.5.2.1
The vendor for our application provided a script that
uses the command
alter index <idx> rebuild tablespace <tblspace>
NOLOGGING;
for all of their application indexes.
When I test the standby (copy datafiles, copy and apply redo logs, bring up database) and execute a query, I get the error message
ORA-01578: ORACLE data block corrupted (file # 17,
block # 150586)
ORA-01110: data file 17:
'/orastandby/u12/oradata/ent/adv_indexes01.dbf'
Metalink doc 164836.1 says that this can be fixed by
executing the command
alter index <idx> logging;
against all the indexes that were set nologging and
rebuilding the standby.
I tried this, and got the same corrupt block error message on my query.
Here's the order of things:
(1) alter indexes rebuild with nologging;
(2) immediately after rebuild, alter index logging;
(3) shut down database, cold backup to disk, rcp files
to standby
(database comes up without errors; redo logs are
applied successfully. There are no errors in alert
log)
Analyzing the indexes without the "nolog" option increases the time considerably, and we have a short maintenance window.
Any ideas?
TIA!
Barb
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker INET: barbarabbaker_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Mar 17 2003 - 12:14:21 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
![]() |
![]() |