open standby database at specific time

[feroz]

Hi,

I have a standby database. Can I apply archive log until specific time like recover database until specific time? Or I need to activate standby database and recover database using until specific time.

Thanks.

[davey23uk]

yes, just recover it till the time you want

it will then stop applying logs

[feroz]

Nice one. No need to recover after activate standby database. Something like this would work?

startup nomount;
alter database mount standby database;
alter database recover automatic standby database until '2010-01-25:17:30:00';
alter database activate standby database;


Thanks.

[feroz]

Could anybody verify my previous reply, please? Thanks.

[davey23uk]

why not do it yourself

[feroz]

Hi,

I dont have extra space to try it at the moment. I'm still waiting for it. I thought somebody out there have done this before.

Thanks.