Consistent Backup - Read only?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Consistent Backup - Read only?

  1. #1
    Join Date
    Oct 2008
    Posts
    69

    Consistent Backup - Read only?

    Hi There, we are doing a major upgrade to one of our systems which involves application/dbase upgrade and then a client roll out/upgrade.

    Before the upgrade we will shutdown the database and take an offline backup of the datafiles to get a consistent database backup.
    I was wondering if after the upgrade i can restart dbase in read only mode and and do the post upgrade backup this way. I presume this will still be a consistent database backup?
    If so it will allow us to proceed with the client roll out while the database is being backed up but still being able to test connectivty of the client saving us some time.

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    Cool Startup upgrade?

    If by "after the upgrade i can restart dbase in read only mode" you refer to having issued the "STARTUP UPGRADE" and executed all the necesary scripts, yes you could start the database in read-only while you do the post-upgrade backup.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Oct 2008
    Posts
    69
    Thanks for the (sarky) response
    I'm not talking about an oracle version upgrade, this is just a bought in application upgrade that happens to update some tables in the database (upgrading the database to the new application version as it were - remaining on a 9i database)
    Sorry if that was not clear.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Got it, some DDL and DML sent by the sofware vendor, isn't it?

    Do you want to be safe?

    After the app upgrade just shutdown the database, cleanly - then take another cold backup like the first one you took.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Apr 2007
    Location
    USA
    Posts
    110
    But why another backup immediately after the app upgrade? You took the before image, so that you can go back if app upggrade screws up. Once it is succesful, shouldn't you just return to your normal backup schedule? You still have the pre-upgrade copy, right?
    Looking for the greatest evil in the world? Look in the mirror.

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by Tuma View Post
    But why another backup immediately after the app upgrade?
    Too many reasons I don't even want to know. Poster wanted to know how to take a post upgrade backup, that's what he/she gets from me -after all I'm a DBA not a shrink
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  7. #7
    Join Date
    Oct 2008
    Posts
    69
    Really all i want to know is if i start a database in read only mode (after having been shutdown cleanly) and then backup the database while it is in read only mode, is this backup as consistent as an offline backup?
    LKBrown seems to think so (and i would agree)

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