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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
Sent: Wednesday, April 15, 2015 12:25 PM
To: oracle-l@xxxxxxxxxxxxx
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.
