Printable View
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.
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.
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.Quote:
Originally posted by mcslain
what kind of a performance hit does the CONSISTENT=Y flag cause though?
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.
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.Quote:
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.
Thanks a bunch!