-
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.
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|