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: [EMAIL PROTECTED]
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: [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: Martin Kendall
> 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).
>
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: [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).
