|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Export backup [message #689458 is a reply to message #602191] |
Tue, 09 January 2024 03:18  |
 |
fk7881@gmail.com
Messages: 1
Registered: January 2024
|
Junior Member |
|
|
Hello here is a proper answer thanks to ai:
Yes, you can take an export backup of a schema while users are active in the same database. Oracle's Data Pump utility (expdp for exports) is designed to be able to perform consistent exports even when users are actively using the database. This is achieved by using a mechanism called "consistent read."
Here's a brief explanation of how it works:
Consistent Read: When you initiate a Data Pump export, the utility uses a consistent read mechanism to ensure that the exported data is consistent as of a specific point in time. This point in time is determined at the beginning of the export, and it ensures that the exported data is consistent even if changes are being made to the database during the export operation.
Flashback Query: Data Pump uses Oracle's Flashback Query feature to achieve a consistent read. Flashback Query allows a query to be executed against a specific point in the past, providing a consistent snapshot of the data.
Impact on Users: While the export is in progress, users can continue to work with the database. However, keep in mind that there might be a slight impact on performance, as the export process may consume some system resources. The impact is usually minimal, and the export is designed to be non-disruptive to normal database operations.
Data Consistency: The consistent read mechanism ensures that the exported data is a consistent snapshot, even if changes are being made to the database by other users.
It's important to note that while exporting a schema, the tables and data being exported might not be in a fully consistent state with respect to each other. However, each table's data is consistent within itself.
To summarize, taking a Data Pump export of a schema while users are active in the database is generally safe and has minimal impact on users. Oracle's mechanisms for consistent reads and Flashback Query help ensure that the exported data is in a consistent state, providing a reliable and non-disruptive way to perform exports.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
