RE: Real-life Stand-by DB implementation stories?

Hi Earl,

1. Sun Solaris 2.7
2. 8.1.6.0.0
3. The Standby is required for Reporting use during Normal Business Hours. So during that time frame day it is setup as READ ONLY. This requires a TEMPFILE Temporary Tablespace to allow things like Sorting in any queries as the SYSTEM Tablespace is READ ONLY. Outside of the normal Business Hours, the Standby is Shut Down then restarted as a STANDBY DATABASE, which allows for recovery but NOTHING ELSE, using the accumulated Arch. Redo files. The accumulated Arch. Redo files are manually sent from the Production DB to the Standby (ftp cron job - every minute)during the Business Hours. Once the Standby is recovered it is OPEN READ ONLY again for Reporting use.
4. I assume you mean: how long to implement above strategy ? Well, it is just a case of creating a Stanby Control file and then copying ALL the DB files from Prod. to Stby. Then starting the Standby in STANDBY mode to apply the initial Arch. Redo. files. So the time it will take is a function of the size of the DB. It took me half a day do do a 12GB Database.

You can see that although this is a robust solution, it STILL doesn't provide a recovery to the actual time of losing the Prod. DB. Since the cron Job is running every minute and NOT every time an Arch. Redo file is
written.

Hope this helps. If you need more info then just ask via the list so that more people can benefit/contribute
from/to our discussion.

Martin Kendall (still on that road to OCP and the ultimate enlightenment...)

-----Original Message-----
Sent: 27 April 2001 00:56
To: Martin.Kendall_at_Rubus.com

Thanks for the reply.

Questions:

1) OS
2) version of Oracle
3) your implementation plan (quick summary)
4) time from decision to PROD

Thanks so much,

Earl

On Thu, 26 Apr 2001 10:43:53
 Martin Kendall wrote:
>Hi Earl,
>
>The problem I have found recently is getting management to understand
>that a Standby DB has to be exclusively Standby for it to be as up to date
>as poss.
>
>-----Original Message-----
>Sent: 26 April 2001 17:06
>To: Multiple recipients of list ORACLE-L
>
>
>Anyone implemented SBDBs recenetly? A client is comparing them to a cluster
>solution involving Fail-Safe. We are recommending SBDB and trying to go to
>817 also (on 80521 now).
>
>Also this is NT if that makes a difference.
>
>Thanks,
>
>
>Earl
>
>
>Get 250 color business cards for FREE!
>http://businesscards.lycos.com/vp/fastpath/
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: The Oracle DBA
> INET: theoracledba_at_lycos.com
>
>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: ListGuru_at_fatcity.com (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: Martin Kendall
> INET: Martin.Kendall_at_Rubus.com
>
>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: ListGuru_at_fatcity.com (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).
>

Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Martin Kendall
  INET: Martin.Kendall_at_Rubus.com

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: ListGuru_at_fatcity.com (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).