open standby database at specific time

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.

yes, just recover it till the time you want

it will then stop applying logs

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.

Could anybody verify my previous reply, please? Thanks.

why not do it yourself

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.