Dick,
I've never duplicated a system by breaking a mirror, so
please excuse my ignorance.
When the mirror(s) is/are broken, how does this affect the
online redo log? Is it possible that the SCN in one or more
of the data files ( I'm guessing it's a SYSTEM file ) file exceeds
that in the redo log?
Could this be do to a difference in the time of the break on the
data filesystem versus the time of the break on the FS
containing the redo?
And if so, maybe you need the most recent archived log
to finish recovery on the mirror?
HTH
Jared
[EMAIL PROTECTED]
om To: [EMAIL PROTECTED],
[EMAIL PROTECTED]
cc:
12/07/01 01:11 Subject: Re[2]: Creating a reporting DB
PM
Jared,
Now, Now are we bad mouthing another vendor? I thought MicroSlop was
the
prime bad boy. But seriously I understand as we use another lame Lotus
product
for mail, CCMail.
To the topic, we tried that & the darn thing just keeps looking for
additional logs past the point. Personally I believe it's due to our
trying to
do the entire job in one blast.
Dick Goulet
____________________Reply Separator____________________
Author: [EMAIL PROTECTED]
Date: 12/7/2001 12:55 PM
Dick,
First, those of us with lame MUA's ( Lotus Notes in this case )
may not be able to dig the address of your coworker out of
the address header.
As for the archive log, feed it the online redo logs until it gets
the one it wants, which should be the most recent one. If you're
not copying the online logs, then you'll need to add this into
your routine.
I've had to do this when doing much the same thing.
Then you can proceeed with the 'open resetlogs'
Jared
[EMAIL PROTECTED]
om To: Multiple recipients of
list
ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] Subject: Creating a reporting
DB
om
12/07/01 12:15
PM
Please respond
to ORACLE-L
Folks,
I'm sure that someone on the list has done this in the past or at least
can
"see the forest through the trees". I've been a little too close to this
and
lost the perspective.
Anyhow, what we're trying to do is create two replica's of our
production
PeopleSoft database on a separate machine using the hot backup method
(otherwise
known as EMC TimeFinder). Now that's two HP 9000 and three instances of
Oracle.
It does not take a wizard to understand that there is going to be a SID
conflict somewhere. SIDs around here are two characters in place and range
from
'02' to '09' (Please don't ask why, it's a VERY long story).
We start out with Dudley:02 and want to end up copying that to
Schroeder:06
and Schroeder:05. BTW, the mount points are not the same so we have to not
only
change the database name, but the file paths too. We've figured out the
file
renaming part just fine & getting the SID changed. The problem comes with
recreating the control file. Oracle recommends using the 'create
controlfile
set database 06 resetlogs' which sets the sequence in V$log to 0, but
leaves us
with a database that is looking for an archive log that does not exist.
The sequence of events we're using is:
1) Place production DB into hotbackup mode.
2) Break the mirror.
3) End backup on production.
4) Mount the mirror on the second machine.
5) Startup nomount the new instance, but under a different SID.
6) Rebuild the control file with a new name while renaming datafiles,
including the online redo.
7) Recover the database. This is where the trouble commences.
Anybody have an idea??? BTW: We're trying to do this as a complete
scripted
operation that the SA can just run.
Dick Goulet
OH, Also please include my companion in crime (listed in the address area)
as
I'm off next week.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
