|
-
Hi, please tell me whether my understanding on this issue is correct or not:
When doing recovery for a corrupted datafile, Oracle needs two things, one is the datafile itself, the other is redo log files. The process is that Oracle will open the datafile that you backed before. Then it applies redo log changes to the datafile. So in the redo log, it contains something like the SQL commands you executed before in the temporal order. If there is a commit in the redo log, Oracle will commit it. After finishing, if there is no commit for some DML, Oracle will roll back those transactions.
Is this understanding correct?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|