Post reply

Refresh of database

  • November 23, 2011 at 2:20 am

    #250999

    What is Refresh of database

    Thanks

  • November 23, 2011 at 2:43 am

    #1412011

    in terms of?

    what we call a refresh in our organisation is a copy of the live database, being placed onto the DEV/UAT/SYSTEST environment so that development have a like for like copy of the live environment to start developing new features in the applications.

    this is also useful for when a live release is ready to be deployed, refresh the staging environment and release all scripts to have a trial run and fix any errors or missing scripts before the actual go live date.

  • November 23, 2011 at 2:54 am

    #1412016

    I mean to say refresh of already running production database.

    Thanks

  • November 23, 2011 at 3:19 am

    #1412025

    can i ask why you would want to do that.

    surely that means that the database is not production as you would never want to go back to a point in time on a live environment

    if you wanted to restore data by an accidental update,delete,truncate you would create a new db and restore your backup into that then transfer the data across or update back to original values.

  • November 23, 2011 at 3:21 am

    #1412027

    Actually I am taking handover from a dba and he has written refresh of database in his kt so I am not getting it ....

    Thanks

  • November 23, 2011 at 3:25 am

    #1412029

    your best asking the person doing the handover what they mean by refresh, once you know it might be obvious, if not we are here to help

  • November 23, 2011 at 3:28 am

    #1412031

    He is saying To clean the buffer,Cache,Close the existing connections.

    May I Know how to close the existing connections in command...

    Thanks

  • November 23, 2011 at 3:37 am

    #1412035

    to close existing connections you can set the database to single user which will close all connections to that db but leave the connection issuing the command in the db.

    alter database DBNAME set single_user with rollback immediate

    then

    alter database DBNAME set multi_user

    you could also set the database as offline

    alter database DBNAME set offline with rollback immedate

    then

    alter database DBNAME set online

    how is the person doing this so called "refresh" is it drop the DB, create new DB, restore the DB?

Viewing 8 posts - 1 through 7 (of 7 total)

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