When taking hot backups, it is recommended to back one tablespace at a time. When the backup is over, tablespaces are left with transactions in one table that do not correspond to transactions in another table. Has this ever caused problems for anyone after database recovery?
11-17-2000, 11:43 AM
That's what redo/archived logs are for :)
I've never run into a situation in a production environment where I've had to recover a hot backup, but in small tests there's never been a problem.
11-17-2000, 11:49 AM
If I had to recover from a hot backup, would I have to apply all redo/arc logs produced from the start of the backup?
If so Is oracle clever enough to know that certain transactions already exist on some tables but not on corresponding tables?