S
SIBSANKAR PRADHAN
Guest
Hi All, Currently i am facing issue in our production database, one of the extent has reached it's maximum limit and we can't add any more extent due to it's version limitation . In our case ,we don't need data from the affected extent but for security purpose ,we have to keep all the records in that extent so, we can't delete any data to reduce the size . No application level data archiving policy configured in our database . Can you please suggest me urgently about the below suggestion - 1) Create a new Database - not possible immediately 2) Upgrade progress version - not possible immediately 3) Create a new data area and update the same in the .st file and load a new df into the database , so that new records can be stored in the new data area and old records also can be recoverable from the old data area by loading the old df ,if needed . Here i am planning to apply this solution in production Version and DB details: Progress version - 9.1E Database Size - 800GB Records per block - 128 DB Block size - 8k Please advise me regarding our ideas and also any other idea that can be feasible in this scenario.
Continue reading...
Continue reading...