Followers

Monday, July 15, 2019

Essbase BSO and ASO Cube and Backup Scripts

BSO Cube =
exec_maxl "alter database ${APP}.${DB} archive to file '${BACKUP_PATH}/${APP}_${DB}.arc';" "1056023";

ASO Cube =
exec_maxl "export database ${APP}.${DB} level0 data to data_file '${BACKUP_PATH}/${APP}_${DB}.txt';" "1013270";

Do not forget the artifacts:
/usr/bin/zip-q -D ${BACKUP_PATH}/${APP}_${DB}_${TIME_STAMP}.zip  ${ARBORPATH}/app/${APP}/${DB}/* -x *.pag *.ind *.tct *.inn *.pan *.otn *.app *.dmf *.dbb *.db *.esm *.apb *.dat *.org *.dbd  *.jar  *.xml *.keep


No comments:

Post a Comment