DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: open standby database at specific time

  1. #1

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    yes, just recover it till the time you want

    it will then stop applying logs

  3. #3
    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.

  4. #4
    Could anybody verify my previous reply, please? Thanks.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why not do it yourself

  6. #6
    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
  •  


Click Here to Expand Forum to Full Width