Re: 8i Standby Media Corrupt Blocks

  • From: JApplewhite@xxxxxxxxxxxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 29 Oct 2004 10:34:25 -0500

That would be good if this were a 9i database, but it's not an option for 
8i.  It's not in the docs and fails when issued, so it wasn't back-ported 
to 8.1.7.4.

Thanks for the suggestion, I'll keep it in mind for when we upgrade - if 
the vendor's code becomes less stupid and allows us to upgrade.

Jack C. Applewhite - Database Administrator
Austin (Texas) Independent School District
512.414.9715 (wk)
512.935.5929 (pager)

   May have come a long way, but we got a long way to go.
                                    -- B.W. Stevenson






Andy Rivenes <arivenes@xxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
10/28/2004 10:27 AM
Please respond to arivenes

 
        To:     JApplewhite@xxxxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
        cc: 
        Subject:        Re: 8i Standby Media Corrupt Blocks


Don't know if your corruption is related to NOLOGGING or not, but as part 
of the standby setup you should have run the following command on the 
primary database:

SQL> ALTER DATABASE FORCE LOGGING;

That should eliminate that problem if it exists.



Andy Rivenes
Email: arivenes@xxxxxxxx

--
//www.freelists.org/webpage/oracle-l



--
//www.freelists.org/webpage/oracle-l

Other related posts: