We take a file level backup of our Essbase applications in prod.
We are now trying to create Essbase app copy from prod to development using the backup. Our key steps as below:
1. Create a copy of the application from production - app to dev - bk_app
2. Stop the application
3. Copy contents of the file backup from app/db folder to the bk_app/db folder
Now when we try to start the app we are getting an error saying the DB cannot be started.
We checked the log file and error is:
“Error: 1053001 Cannot open object file: /hypprd/apphome/Oracle/Middleware/user_projects/prd_server/EssbaseServer/essbaseserver1/app/app/db/ess00001.ind”
where /hypprd/apphome/Oracle/Middleware is the production location for index files.
Dev location for index file is instead:
/hypdev/apphome/Oracle/Middleware/user_projects/dev_server/EssbaseServer/essbaseserver1/app/bk_app/db/ess00001.ind”
Normally this process works on Windows. How do we get this to work on Unix as well?