Differences
This shows you the differences between the selected revision and the current version of the page.
erhdr:start 2012/05/23 16:53 | erhdr:start 2012/05/23 16:58 current | ||
---|---|---|---|
Line 18: | Line 18: | ||
This is an easy one to miss especially if the machines are in different timezones | This is an easy one to miss especially if the machines are in different timezones | ||
+ | |||
+ | |||
+ | |||
===== Logged and Unlogged Smart Spaces ===== | ===== Logged and Unlogged Smart Spaces ===== | ||
+ | Back in the day the smart spaces didn't need to be unlogged but that is no longer the case so how do you fix it. It's an easy fix | ||
+ | |||
+ | * Create raw disk space and create soft link in the chunks directory. | ||
+ | * Create the new smart blob space as logged | ||
+ | * Shutdown the db engine and then bring back to quiescent mode | ||
+ | * Ensure all ER transaction are cleared from the existing sbspace. | ||
+ | onstat –g ddr | ||
+ | onstat –g rqm BRIEF | ||
+ | onstat –g smb lod | ||
- | 1. Create raw disk space and create soft link in the chunks directory. | + | * Shutdown db engine and edit onconfig parameter to point to new sbspace |
- | 2. Create the new smart blob space as logged | + | * Restart db engine and ensure start-up is clean by monitoring logs on server and ER targets. |
- | 3. Ensure Friday night archive is complete to provide ‘last ditch’ fall-back. | + | |
- | 4. Shutdown the db engine and then bring back to quiescent mode | + | |
- | 5. Ensure all ER transaction are cleared from the existing sbspace. | + | |
- | a. Onstat –g ddr, onstat –g rqm BRIEF, onstat –g smb lod | + | |
- | 6. Shutdown db engine and edit onconfig parameter to point to new sbspace | + | |
- | 7. Restart db engine and ensure start-up is clean by monitoring logs | + | |
- | on server and ER targets. | + | |
- | 8. Run some test updates/reversions and check ER is correctly | + | |
- | replicating to targets. | + | |
- | 9. Restart continuous log backup. (if required) | + | |
- | 10. Perform database archive. | + | |
===== Dropping Deletion Tables ===== | ===== Dropping Deletion Tables ===== |