|
-
Reason :
Database intentionally marks blocks corrupt during a recovery involving a nologging operation, it is because of this that we find corrupted blocks in sequence.
Suggestions :
If we want to find the exact file id and block number using the logfile then we would need to convert the number available as e.g. DBA = 277079327 to Block number and file ID. This can be identified using the dbms_utility package.
To Identify the File ID : dbms_utility.data_block_address_file(results);
To Identify the Block No. : dbms_utility.data_block_address_block(results);
Metalink Referance Note : Doc ID: Note:139425.1
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
|