Monday, August 1, 2011

Oracle 11g Release 2: Viewing Logical Content of OCR (OCRDUMP Utility)

The ocrdump utility is used to view the logical conent of the OCR. This is used mostly for troubleshooting. The ocrdump utility enables to view the logical information by writing all/limited amount of content to a file. If ocrdump command is executed without any parameter the default file OCRDUMPFILE will be created to the current directory.

As I have stated above that it writes all/limited amount of content because the information contained within the OCR is organized by the keys that are associated with privileges. Below are the statement to get the content of OCR in a viewing format
  • [root]$ ocrdump filename_full_result.txt
  • [grid]$ ocrdump filename_limited_result.txt
So if ocrdump is excuted with root we get all the output and if it is executed with grid we get limited output.

To check the changes in the OCR you can use below method.
  1. Take the logical backup of OCR by ocrdump -backupfile week.ocr
  2. After a week see the difference by executing ocrdump -stdout - packupfile week.ocr | diff - OCRDUMPFILE
Please let me know if you have any issues or need any more help.

1 comment: