Oracle Cloud: Oracle cloud database administration

Explore the basics of cloud computing and how Oracle Cloud delivers on-demand compute and storage resources through IaaS, PaaS, and SaaS, enabling scalable, cost-effective solutions.

Explore Oracle cloud database administration with 12c release 2 overview, a cloud first platform as a service that provisions a complete database via the Oracle cloud UI.

Learn how to register for an Oracle Cloud free account, claim $300 credit for 30 days, verify your phone, add a payment method, and manage billing after the trial.

Sign in to the Oracle cloud service console using your identity domain, username, and the temporary password from the welcome email to manage cloud services and databases.

Log in to the console and use the create instance wizard to provision an Oracle 12c r2 database, setting name, edition, single instance option, pluggable pdb1, and a complex password.

Specify the storage capacity and server size to balance disk space, CPU cores, and RAM for your Oracle Cloud database administration demo.

Configure ssh access to the oracle database by using a downloaded ssh key file for authentication, securely storing the key bundle, and completing the setup in the cloud wizard.

Configure Oracle cloud database backups with local, cloud storage, or cloud-only destinations, including creating cloud storage containers, and understand recovery implications when choosing none.

Use the cloud service console to view existing databases and their configurations, including server, memory, and storage. Start, stop, or restart databases and note the public IP address for access.

Connect to an Oracle Cloud database by unzipping the key bundle, setting private key permissions, retrieving the IP, and establishing a key-based SSH connection to verify the listener and PDB.

Discover how PDB resource management provides size control over IO utilization for individual pluggable databases in a consolidated Oracle Cloud database, isolating performance in multi-tenant environments.

Learn to configure PDB I/O resource management in Oracle Cloud by setting max IOPS and max MBBS for a pluggable database, applying limits to memory and the configuration file.

Explore pdb hot clone, a pluggable database feature that clones while the source remains open, eliminating downtime and enabling rapid creation of new databases for development or testing.

Verify environment readiness by enabling local undo mode, shared undo mode, and archive log mode for container databases, then confirm settings via sqlplus before PDB cloning.

Create and open a source pluggable database, then perform a hot clone to a new target PDB and verify it opens in read-write mode.

Explore PDB flashback to revert a pluggable database to a chosen time, enabling recovery from human error and unintended changes.

Ensure the container database uses the local undo option, then verify with a query against the database properties view. Close the alert and confirm flashback is enabled with another query.

Switch to the source pdb, close and reopen it after flashing back to a prior system change number, while creating a simple table and inserting rows.

Explore four partitioning features: convert a table to a partition table with one command, set partitions read-only, implement a foreign exchange partition command, and enable automatic partitioning for inserted rows.

Modify a non-partitioned sales table to a partitioned table online, with an automatically converted local partition index, and verify four partitions without downtime.

Explore how to set individual table partitions to read-only in Oracle Cloud databases, using a single alter table command to isolate read-only partitions without affecting others, and verify with inserts.

Learn how to create a dedicated exchange table to enable fast exchange partition operations, ensuring identical table structures for seamless data loading and improved performance.

Learn how automatic list partitioning creates new partitions on insert when the partition key changes, eliminating manual table management, demonstrated on a sales table partitioned by region.