Shanmugam T
New Member
Hello Experts,
After Image is enabled on Production database and Log switch happens once the AI extends becomes full. Archival of these full AI extends are taken care by our scripts and shipped to DR server automatically.
On DR server, AI files are applied to hot-spare database which takes significant amount of time to roll forward all the transactions. Ex: it takes approximately 10 minutes to roll forward 2000 transactions. Sometimes it takes more than one hour to roll forward single AI file if there were more than 20,000 transactions.
Is there any parameters to be passed with roll forward utility to improve the performance like -B, -bibuf and -aibuf etc., ?
I found few articles in KB suggest to upgrade the progress version which is not possible for me right now.
Also i found few old threads which is not helping me.
Is there any other way to improve the performance of AI roll forward? please suggest.
OS: AIX 6.1 & OE: 10.1B
After Image is enabled on Production database and Log switch happens once the AI extends becomes full. Archival of these full AI extends are taken care by our scripts and shipped to DR server automatically.
On DR server, AI files are applied to hot-spare database which takes significant amount of time to roll forward all the transactions. Ex: it takes approximately 10 minutes to roll forward 2000 transactions. Sometimes it takes more than one hour to roll forward single AI file if there were more than 20,000 transactions.
Is there any parameters to be passed with roll forward utility to improve the performance like -B, -bibuf and -aibuf etc., ?
I found few articles in KB suggest to upgrade the progress version which is not possible for me right now.
Also i found few old threads which is not helping me.
Is there any other way to improve the performance of AI roll forward? please suggest.
OS: AIX 6.1 & OE: 10.1B