The user_data tablespace is in backup. Some users are going to insert a few lakhs of records. What happens in between that? Is the data inserted and if it is inserted, then how?

    Requires Free Membership to View

If the tablespace is in BACKUP mode, users are still able to write changes to the tablespace's datafiles. This normally causes a problem because you could be backing up a datafile that is undergoing change. This makes the backup of that datafile "inconsistent." The backup of the file is not consistent with any point in time. Some parts of the backup may be older than other parts (which have changed more recently). This is not an issue since you put the tablespace in BACKUP mode. When in BACKUP mode, the database writes extra information to the online redo logs. When you restore from this inconsistent backup, Oracle uses this extra information to make the datafile consistent with the point in time right after the tablespace was taken out of BACKUP mode. So when you perfrom these hot backups, just anticipate a higher redo generation rate in your online redo logs.

This was first published in January 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: