RE: Creating a reporting DB
Dick, This is a classic Hot backup problem which has a mirror-split and lots of active datafiles. The reason you are being asked for additional archive logs is this: (and I bet this was for recovering the system.dbf file?) When a tablespace is either put into backup mode or taken out of backup mode, a redo entry that records this event is made in the online redolog. When you break the mirror while still in hot backup mode and copy off the datafiles, SYSTEM.DBF records that you put these tablespaces as being in hot backup mode. On account of the database rename via CCF/RESETLOGS, the online redo logs can now *not* be used and thus the redo vectors that record the fact that the tablespaces came out of hot backup mode are now not available. When the database is opened now with RESETLOGS, all datafiles need to come up to the maximum SCN amongst themselves - details of which is present only in the first archive logs generated *after* the backup completed on the source system. You will then have to apply at least this one archivelog with a CANCEL based recovery before opening the database. If you copied out your archivelog destination via a mirror copy, then you need to add code to the script to 'archivelog current' on the source *after* the hot backup/mirror script is complete and then FTP the last archivelog to the destination server, as well as script the cancel based recovery. There could also be another deeper problem - if the mirror does not contain all the datafiles or parts of the mirror are stale, you will be asked for archivelogs starting from the time the missing datafiles were created or they went stale because of an invalid resilvering or missed filesystems (Been there and been bitten by such an issue, since another DBA created datafiles on non-mirrored filesystems :) Hope this helps - I did not find any 'companion in crime' listed in the address since the Listserv chops it off. I am sending this directly to you in case you have set an autoreply and left for the week - I can then get your alternate contacts. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Wanna know the reason for the season? Click on 'http://www.needhim.org' ** The opinions and statements above are entirely my own and not those of my employer or clients ** > 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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).
RE: Creating a reporting DB
Step 3.1 Switch archive logs and copy to 2nd machine Rename the datafiles to new location and recover until cancel using the Old sid THEN Recreate the controlfile with the new SID Let me know if I missed anything, or I can give you or Henry (? no 2nd addressee in your post) more details. Mike Hand Polaroid Corp. -Original Message- Sent: Friday, December 07, 2001 3:15 PM To: Multiple recipients of list 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: Hand, Michael T 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).
RE: Creating a reporting DB
Dick, I would try: steps 1 thru 4 as you stated. But then, I would: Startup nomount; alter database (rename the data files to the new locations). Recover the database using the old (existing) sid name. Once it is recovered, issue a new backup controlfile to trace and use it to create the new controlfiles using the new sid name. The only difference here is recovering before the renaming. I think you lose the recoverability when you create the new control files. Sorry - didn't see the other persons email in your mail. Good luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 07, 2001 3:15 PM To: Multiple recipients of list 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: Mercadante, Thomas F 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).
Re: Creating a reporting DB
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 mess
