Post reply

Drop connections when doing a restore

  • October 9, 2003 at 7:25 pm

    #82436

    Howdy I'm wondering how I might go about dropping any connections to our standby databases when doing a restore?

    They are being used for reporting rather

    than the primary. However the open connections are preventing the logs from being applied? (N.B. Not using enterprise edition)

  • October 13, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • October 13, 2003 at 9:55 am

    #478021

    Do the following before restoring:-

    alter database dbname set single_user with rollback immediate

  • October 14, 2003 at 1:09 am

    #478076

    I used the alter database but now I cannot apply any logs or diffs to the database.

    Edited by - growl on 10/14/2003 01:30:57 AM

    Edited by - growl on 10/14/2003 01:31:40 AM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply