Re: Standby database switching between read-only and recovery modes question
Date: Wed, 15 Apr 2015 19:48:14 +0000
Message-ID: <1429127293991.10073_at_austinisd.org>
We do this with a Prod DB of about 200GB and moderately active. We've found that it takes less than two hours for the Standby to catch up with Prod, so we do a shutdown abort at 4am, put it in recovery mode until 6am, when we open it readonly. No complaints that a 4am cut-off is a problem
Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9250 (wk)
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Chris Taylor <christopherdtaylor1994_at_gmail.com> Sent: Wednesday, April 15, 2015 12:25 PM To: oracle-l_at_freelists.org
Subject: Standby database switching between read-only and recovery modes question
For those of you who switch your standby db between read-only and recovery mode (non active data guard), how do you manage it?
I've in the process of configuring a reporting database as a standby db, and I *think* I'm going to have to have a script that does 2 things (or 2 scripts).
1 - end recovery mode/open the db read-only during business hours 2 - close the db and put it back in recovery mode
I'm wondering about the "best" way to accomplish item #2. If there are users connected to the DB, I have to kill those sessions *if* I want to do an "alter database close". Should I just scratch that idea and do a shutdown abort on the standby and reopen it?
I'm basically curious how other people are managing the switch between read-only and recovery modes and if you're killing sessions or just shutting down the db to put it back in recovery mode?
Thanks,
Chris
Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student and/or employee information. Unauthorized use of disclosure is prohibited under the federal Family Educational Rights & Privacy Act (20 U.S.C. §1232g, 34 CFR Part 99, 19 TAC 247.2, Gov't Code 552.023, Educ. Code 21.355, 29 CFR 1630.14(b)(c)). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please call the sender immediately or reply by email and destroy all copies of the original message, including attachments.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 15 2015 - 21:48:14 CEST