Oracle 12C database Administration - Oracle dba

Learn how to change the sys and system passwords in Oracle 12c as part of Oracle DBA training.

Learn how to start and stop Oracle 12c databases, connect to container and pluggable databases, and perform essential administration tasks.

Connect to a pluggable database in Oracle using sqlplus, verify the listener is up and running, and confirm a successful connection with a sample user.

Learn to migrate a non-container database to a pluggable database with practical steps, including readiness checks, creating manifest files, data copy, compatibility verification, and post-migration validation.

Learn how to migrate a non-container database to a pluggable database in Oracle 12c, including shutdown, compatibility checks, manifest creation, and data transfer steps.

Learn how to drop a pluggable database in Oracle 12c using SQL*Plus and the DBCA utility, including connecting to the container database, verifying PDB status, and safely removing data files.

Learn how to back up pluggable databases using a utility, with two approaches: connect to the container database and back up all data files, or back up specific pdbs manually.

Use RMAN to back up a tablespace in Oracle 12c. Connect to RMAN, identify datafiles, and perform a tablespace backup, optionally including the fast recovery area.

Learn how to back up the root database in Oracle 12c, including full backup versus pluggable database backup, monitor progress across channels, and verify backup files and tags.

Learn how to back up an Oracle container database, connect to the target with privileges, back up data files and control files, and verify the backup in the designated path.

Learn how to back up Oracle data files using file names or file numbers, covering system tablespace data files and control files.

Create a common user and a local user in Oracle 12c, using the prefix see hashcash to validate usernames and grant needed privileges for secure database access.

learn the oracle datapump introduction: compare traditional export-import, perform logical backups of schema objects and tablespaces, and move data between databases and schemas without downtime.

Learn to export a table with Oracle datapump, creating a directory, granting necessary privileges, and generating a logical backup file for easy restore and import.

discover how to restore a dropped Oracle 12c table using datapump impdp by pointing to the backup, specifying the table name, and verifying the restored data after import.

Learn to export a schema with expdp, capture all schema objects into a dump file, and address permissions and required disk space for the export.

Drop the schema, restore from backup, and import the schema using the datapump utility to re-create all objects. Create the user, authenticate, and verify that all objects are restored successfully.

Take a full database export by backing up, performing a data dump, processing objects, and transferring the export to another server for import into Oracle database, ensuring sufficient space.

Master the include and exclude parameters in datapump to selectively export a schema or specific tables, while excluding unwanted objects during backup and export operations.

Demonstrates writing export details to both log file and console using the logtime parameter, capturing object names and time stamps for each exported database object.

Explore how to use the content parameter to export data, back up schema objects, and selectively include table data such as the employee table across schemas.

Explore how to query specific data from a table with where conditions using the query operator, and export either a full database or a single table.