Schedule Start and Stop Times for an Autonomous Database Instance
Describes the steps to schedule daily start and stop times for an Autonomous Database instance.
When you enable Auto Start/Stop Schedule on an Autonomous Database instance, the instance automatically starts and stops according to the schedule you specify. This allows you to reduce costs by scheduling shutdown periods for times when a system is not in use.
Perform the following prerequisite steps as necessary:
-
Open the Oracle Cloud Infrastructure Console by clicking the next to Oracle Cloud.
- From the Oracle Cloud Infrastructure left navigation menu click Oracle Database and then, depending on your workload click one of: Autonomous Data Warehouse, Autonomous JSON Database, or Autonomous Transaction Processing.
-
On the Autonomous Databases page select an Autonomous Database from the links under the Display name column.
To set the Auto Start/Stop Schedule, do the following:
To remove start and stop times for a day from an Auto Start/Stop Schedule, edit the schedule and deselect the schedule for that day. To remove all scheduled start and stop times and disable Auto Start/Stop Schedule, deselect the start and stop check boxes for all days in the schedule.
Notes for Autonomous Database Auto Start/Stop Schedule:
-
A scheduled stop works the same way as a manual stop; when the scheduled stop occurs, any running database sessions are stopped.
-
You can perform a manual start for a database, if necessary, after a database has stopped due to a scheduled stop.
See Start Autonomous Database for more information.
-
You can perform a manual stop for a database, if necessary, after a database has started due to a scheduled start.
See Stop Autonomous Database for more information.
-
The Lifecycle State must be Available to view or to edit the Auto Start/Stop Schedule.
-
Always Free Autonomous Database does not support Auto Start/Stop Scheduling.
-
A database that has been scheduled stopped, remains stopped until the next scheduled start time or until you start the database. Likewise, a database that has been scheduled started, remains running until the next scheduled stop time or until you stop the database.
-
When an Autonomous Database remains stopped for over 7 days it may take a few minutes or longer to start up, depending on the size of the database. To avoid this extra startup time, Oracle recommends starting your Autonomous Database instance once every 7 days.
Parent topic: Lifecycle Operations