Re: going back to physical standby from logical standby
- From: K R <kp0773@xxxxxxxxx>
- To: "Mark W. Farnham" <mwf@xxxxxxxx>
- Date: Mon, 10 Jan 2011 10:59:37 -0800
Thanks Mark/Quiser
I guess I will keep doing the instantion . :)
On Sat, Jan 8, 2011 at 9:39 AM, Mark W. Farnham <mwf@xxxxxxxx> wrote:
> Exactly what your options are depends on exactly which bits of technology
> you are using and what you have in hand on the standby server.
>
>
>
> For example, (and this is probably NOT what you have), if you can had a
> roll your own physical standby on the standby server and you did physical
> backups on the standby server including a full datafile backup prior to the
> conversion from physical to logical and you still had all the relevant logs,
> you could simply slap the old files in place and start recovery. (Simple,
> but you have to get all the pieces right by yourself, and if you screw
> something up enjoy starting over.)
>
>
>
> If you’re using dataguard and RMAN, then you need to follow the exact rules
> of those products and there will be a similar “and” list of prerequisites
> for getting back to various points and rolling forward.
>
>
>
> Unless there is a very high dollar impact or reputation to just doing a 4
> hour re-instantiation you already know how to do and have tested, I would
> not recommend doing this as an experiment in real time on production. And
> that is even if someone can spoon feed you exact commands after you describe
> your exact situation (which I am not trying to pre-empt, and you might try
> whatever is forthcoming later on test systems after your crisis is over.)
>
>
>
> Regards,
>
>
>
> mwf
>
>
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *K R
> *Sent:* Friday, January 07, 2011 8:01 PM
> *To:* Oracle-L@xxxxxxxxxxxxx
> *Subject:* going back to physical standby from logical standby
>
>
>
> All,
>
>
>
> I have a situation.
>
>
>
> I created a physical standby database on 12/15
>
>
>
> and I converted it to logical standby database on 12/20
>
>
>
> there was a huge batch job on primary that ran on 12/22 which updated 2
> big tables of around 150G each .and the updates coming from that batch job
> is still running since then.
>
>
>
> I have been always doing the instantiation which normally takes like 4
> hour but this time I am thinking if there is a quicker alternative to it
> .not sure if incarnation will help here.
>
>
>
> So can I revert back to standby ( 12/19 ) and let the archive logs
> applied till 12/23 it will be a lot quicker . The database is on 10.2.0.4
>
>
>
> Thanks in advance.
>
>
>
> Kart
>
Other related posts:
