RE: Stand-by database implementation ...
Lizz - Given the amount of effort you are going to invest in this, I would seriously study the features in 9i Data Guard (new Standby name) and ask if there was any way that I could invest that effort in 9i. Many sites feel that the switchover to standby is so cumbersome in 8i (you must rebuild the other site), that in fact they only switch as a last resort. With 9i you can switch back and forth easily. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 29, 2002 9:24 AM To: Multiple recipients of list ORACLE-L Looks like I'm gonna implement a stand-by database on Windows 2000 using Oracle 8.1.7.4 Anyone have any good article, how-tos, caviots I need to consider or read up on? Lizz __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lizz Pena INET: [EMAIL PROTECTED] 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: [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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [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: Stand-by database implementation ...
On Tue, Oct 29, 2002 at 07:23:33AM -0800, Lizz Pena wrote: > Looks like I'm gonna implement a stand-by database on > Windows 2000 using Oracle 8.1.7.4 > > Anyone have any good article, how-tos, caviots I need > to consider or read up on? -- caveat, from Latin, let him beware. Ain't English great, never a dull moment. I think the oracle docs cover it well, amazingly. leave it to you to manage the archivelogs, so you need to write some scripts. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] 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: [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: Stand-by database implementation ...
One of the best sources of information is a white paper by Lawrence To called Graceful Switchover and Switchback for Standby Databases (Metalink note 90817.1) Another one under the White papers sectiopn is note 91570.1 but I have not looked at that John -Original Message- Sent: 29 October 2002 15:24 To: Multiple recipients of list ORACLE-L Looks like I'm gonna implement a stand-by database on Windows 2000 using Oracle 8.1.7.4 Anyone have any good article, how-tos, caviots I need to consider or read up on? Lizz __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lizz Pena INET: [EMAIL PROTECTED] 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: [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 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: [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: Stand-by database implementation ...
Look out for the Pentium 4 bug. Other than that I've found it to be pretty straightforward. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] 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: [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: Stand By Database !!
you need to create the datafile in ur standby and then apply the logs... see the alter database create datafile AS command... > -- > From: Prasad Dash, Saroj (CAP, > GCF)[SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 03, 2002 9:00 AM > To: LazyDBA.com Discussion > Subject: Stand By Database !! > > Suhen , > > After adding a datafile in Primary database .In the day end I am planning > to > apply the archive logs into stand by database. > Did I require to refresh the controlfile . > > Hello all, > > My standby database is in manual mode. > > I came to know that if you will apply the archive logs then you will hit > the errors below. > ORA-283, ORA-1670, ORA-1157, ORA-1110 > > STANDBY DATABASE> svrmgrl > STANDBY DATABASE> connect internal > STANDBY DATABASE> recover standby database Press Enter Key > > then i will hit those errors > ORA-283, ORA-1670, ORA-1157, ORA-1110 > > My standby database is in manual mode.Everyday I transfer the archive logs > manually and recove the dataase manually. > > > So please tell me what will be the detail procedure of adding a datafile > in > stand by databse. > > I know about this command. > > Svrmgrl> connect internal > svrmgrl> simple i will put the below command. > > ALTER DATABASE CREATE DATAFILE '/db/orcale/docimage.dbf' > AS '/db/orcale/docimage.dbf'; > > svrmgrl> then recover standby database > > HIt the Enter Key the appply the logs. > > > > > Please tell me the detail procedure. > > Regards, > Saroj. > > > Oracle documentation is here: > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage > To unsubscribe: send a blank email to [EMAIL PROTECTED] > To subscribe: send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > By using this list you agree to these > terms:http://www.lazydba.com/legal.html > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul 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).
