|
-
 Originally Posted by jhmartin
I disagree. Oracle will have to perform crash recovery as the database was not closed in a consistent state. The checkpoint means that only a fairly small amount of redo will have to be applied, but it still has to be recovered. Oracle background activities can generate redo, so redo is generated even if there is no users in the database.
When you do a FAST CHECKPOINT all dirty buffers with current or below SCN value will be written to data files regardless if it is commited or uncommited. At this state, the only thing that needs for instance recovery is the uncommited data which is actually a transaction recovery(rolling back) in order for the database to be in a consistent state. And the SCN information needed for this transaction recovery is recorded also in the redo log.
That's why I mentioned in my previous post:
unless there were pending/ongoing process executed during those commands that will generate new redo blocks
This means pending(NOT commited/NOT rolled back) or ongoing process.
Or let me clear it PENDING transaction.
I hope this clears out.
---------------
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
|