RE: Recover Scenario - Solaris 10.2.0.2
Date: Thu, 11 Mar 2010 08:36:12 -0500
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F04F81A12_at_us-bos-mx022.na.pxl.int>
OH well, better than having to rebuild the entire database setup. Now you need to figure out who moved things causing the original problem & cut a hand or two off.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
From: Newman, Christopher [mailto:cjnewman_at_uillinois.edu]
Sent: Thursday, March 11, 2010 8:32 AM
To: Goulet, Richard; oracle-l_at_freelists.org
Subject: RE: Recover Scenario - Solaris 10.2.0.2
Hi Dick,
Turns out we had to rebuild the standby. Your theory is correct, but the standby stopped applying logs and was getting 600's when attempting to restart recovery, so the drop tablespace would never make it through, as it was stuck on the 'bad' redo.
- Chris
From: Goulet, Richard [mailto:Richard.Goulet_at_parexel.com]
Sent: Thursday, March 11, 2010 7:28 AM
To: Newman, Christopher; oracle-l_at_freelists.org
Subject: RE: Recover Scenario - Solaris 10.2.0.2
I'm going to assume that you have "standby_file_management=auto" on the standby in which case whatever you do to the primary will replicate nicely to the standby. Namely that as you drop the tablespace and datafile the same will occur there thereby making a rebuild unnecessary.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Newman, Christopher
Sent: Wednesday, March 10, 2010 7:57 PM
To: oracle-l_at_freelists.org
Subject: Recover Scenario - Solaris 10.2.0.2
Hello,
We've had datafile moved in our production box; then moved back. This has caused logical errors in the datafiles. These are all index tablespace related datafiles, so our plan there is to drop the tablespaces, recreate, and recreate the indexes.
My question... is there any way to manipulate this on the physical standby's, or is rebuilding the standby's the only logical move?
Errors look like this:
ORA-10564: tablespace GEN_LARGE_INDX
ORA-01110: data file 149: '/u07/oradata/BANPROD/gnli02BANPROD.dbf'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 70727
Wed Mar 10 18:15:59 2010
Media Recovery failed with error 600
I'm thinking rebuild is going to be our only option, as the standby's won't get past the 'bad' redo to be able to get to the fix.
Chris Newman
Database Specialist
AITS, University of Illinois
217-333-5429
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 11 2010 - 07:36:12 CST