Full Export With Users Logged on
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Full Export With Users Logged on

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,

    We take a cold backup of our database every day and also do a full export. But the problem is that the users might be connected to it when the export is taken.

    Is it OK to have the users connected and some transactions going on when the full export is taken. It does not matter to us if a little amount of data is inconsistent or is lost.

    Thanks
    Anurag

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yes, users can be connected while the export is going on. As you say, you will have inconsistent data if you ever need to restore. If you are looking for consistent data, make sure you use the CONSISTENT=Y flag in export.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Sep 2000
    Posts
    362
    Thanks for the help.
    Does this mean that export with Consistent = Y is as good as no users being connected and no transactions occuring on the database during the export.

    Can the users still connect and work on the database if it is consistent = Y.

    Thanks Again
    Anurag

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yes, it is as good as with no activity on the database. Yes, the users can still be connected.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Apr 2001
    Posts
    54
    what kind of a performance hit does the CONSISTENT=Y flag cause though?

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by mcslain
    what kind of a performance hit does the CONSISTENT=Y flag cause though?
    It's definitely slower. Your RBS will have more usage during the export as things are done in a transaction.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #7
    Join Date
    Feb 2001
    Posts
    123
    You will also find that the likelihood of the 'snapshot too old' error increases with user load when running a consistent export.

  8. #8
    Join Date
    Apr 2001
    Posts
    108
    You also need to know that running an export in consistent mode does not mean that your entire database is consistent. It only means that the tables are consistent within themselves.

  9. #9
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by justadba
    You also need to know that running an export in consistent mode does not mean that your entire database is consistent. It only means that the tables are consistent within themselves.
    No, CONSISTENT=Y means exactly what it says - the *whole* export dump is consistent to a single point in time when export started, no matter of the other transactions that happens during the export. You can't get inconsistent database when CONSISTENT=Y. The whole export is either consistent or the export failed because it was unable to assure consistency.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #10
    Join Date
    Jun 2000
    Posts
    55

    It's good to know all these.

    Thanks a bunch!

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