Could someone give me a nutshell description of what happens with undo/rollback, redo, and temp files during a database hot backup.
Thanks,
Nathan
Printable View
Could someone give me a nutshell description of what happens with undo/rollback, redo, and temp files during a database hot backup.
Thanks,
Nathan
nothing happens with them, the continue doing there job as usual
redo and temp file don't get backed up
What about the undo? What if someone does a rollback during a hot backup?
Nathan
what about it? the transaction gets rolled back
I am having a mental lapse or something. So undo, temp, and redo are written to during a hot backup?
Nathan
of course (if we are talking rman here)
No RMAN.
1) alter database begin backup;
2) copy data files to another disk
3) alter database end backup;
4) alter system switch logfile;
5) copy archived redo logs to another disk.
6) backup control file
This is our procedure in a nutshell. In this scenario what is happening?
Thanks,
Nathan
Now that is a quality document. Thanks for posting it.
Nathan