By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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?
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.