-
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
-
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
-
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
-
Yes, it is as good as with no activity on the database. Yes, the users can still be connected.
Jeff Hunter
-
what kind of a performance hit does the CONSISTENT=Y flag cause though?
-
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
-
You will also find that the likelihood of the 'snapshot too old' error increases with user load when running a consistent export.
-
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.
-
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?
-
It's good to know all these.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|