Table 6-1 FMS Database Support Tasks
| Database Support Task | Description | Risk | Customer Managed | Oracle Hospitality CruiseManaged | Oracle Hospitality CruiseManaged Access Required | Oracle Hospitality CruiseManagedRequirement |
|---|---|---|---|---|---|---|
|
Performance tuning |
Investigating and resolving performance issues as reported by the customer. |
Slow performance |
Shared |
Oracle Hospitality Cruise |
Full database, O/S, ESX |
Technical architecture if customer supplied environment. |
|
Resolving database errors |
Researching and providing solutions for database errors as reported by the customer. |
Performance issues or downtime depending on severity of the problem. |
Shared |
Oracle Hospitality Cruise |
Full database, O/S |
|
|
Adding storage to database |
Adding tablespaces or providing scripts to onboard IT to add tablespaces. |
Downtime until storage is added. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
O/S access is for disk storage free space only. |
|
Troubleshooting Sql*net connection errors |
Investigating and resolving connection issues as reported by the customer. |
Downtime as clients are unable to connect, sporadic connection problems. |
Customer |
Shared |
Full database, O/S, specific clients with issues. |
|
|
Proactive performance tuning |
Routine checking of performance statistics and implementing tuning modifications when necessary |
Slow performance. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S, ESX |
|
|
Proactive monitoring of database space usage. |
Routine checking storage of objects in the database, the tablespaces, and database data file sizing. Ensuring enough space is available for database objects to grow. |
Unplanned downtime as a result of the database unable to extend. Emergency storage requests. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
|
|
Proactive monitoring Operating System space usage. |
Routine checking storage of objects in the database, the tablespaces, and database datafile sizing. Ensuring enough space is available for database objects to grow. |
Unplanned downtime as a result of the database unable to extend. Emergency storage requests. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
|
|
Proactive monitoring Operating System space usage. |
Routine checking physical storage on the server and virtual machine. Ensuring that operating system and oracle installation drives have sufficient space for normal operations. Ensuring database drives have adequate room for expanding the database if necessary. |
Downtime as a result of the database unable to extend or unable to log activity or write archive logs. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
|
|
Monitoring export backups |
Routine checking that database exports are being performed successfully and are suitable for recovery of the database (if the primary recovery is export file). |
Inability to recover the database from media failure. Data loss and downtime. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
Oracle Hospitality Cruise setup and configuration of database exports. |
|
Monitoring hot RMAN backups |
Routine checking that hot RMAN backups are being performed successfully and are suitable for recovery of the database if necessary. |
Inability to recover the database from media failure. Data loss and downtime. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
Oracle Hospitality Cruise setup and configuration of RMAN hot backups and archive logging. |
|
Monitoring archive log space |
Routine checking of archive log storage space and that backup procedures are successfully removing obsolete archive logs. |
Unplanned downtime as a result of the database unable to write archive logs. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
Oracle Hospitality Cruise setup and configuration of RMAN hot backups and archive logging. |
|
Proactive monitoring and resolving database errors |
Routine checking for database errors, searching and providing solutions for database errors. |
Performance issues or downtime depending on severity of the problem. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
|
|
Monitoring Data guard |
Routine checking of data guard server to ensure logs are consistently applied to data guard and the standby database is up to date. |
Data guard not functional and no redundancy if primary host is lost. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
Oracle Hospitality Cruise setup and configuration of data guard standby database. |
|
Database recovery after media loss using export file. |
Creating a new database and restoring the database from the latest export. |
Downtime and lost data. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
Oracle Hospitality Cruise setup and configuration of database exports. |
|
Database recovery after media loss using hot RMAN backup. |
Restoring a new database from the backup files and recent archive logs. Recovery to point in time just before failure. |
Downtime and lost data. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
Oracle Hospitality Cruise setup and configuration of RMAN hot backups and archive logging. |
|
Switchover to Data guard standby |
Performing switchover from primary database to data guard standby database. |
Downtime while primary database is unavailable. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
Oracle Hospitality Cruise setup and configuration of data guard standby database. |
|
Forecasting future storage requirements |
Routine analysis of storage usage and identifying future physical storage required. |
Downtime as a result of the database unable to extend. Emergency storage requests. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
|
|
Managing and Installing Oracle Critical Patch Updates |
Installing latest tested Oracle Critical Patch Upgrades. |
Exposure to audits requiring patches are up to date. |
Customer |
Oracle Hospitality Cruise |
Full database, O/S |
On-site upgrades |