Tutorials

Oracle Database Administration

🔴 Introduction to Oracle Database

Creating Oracle Database

🔴 Creating Oracle 11g / 10g Database using SQL commands
🔴 Creating Oracle Container Database in 12c using DBCA
🔴 Creating Oracle Container Database in 12c using SQL commands

Managing Oracle 12c Container Databases

🔴 Creating User Accounts and Connecting to Oracle 12c Container and Pluggable Databases

🔴 Managing Pluggable Databases in Oracle 12c

🔴 Managing Tablespaces And Datafiles

🔴 Temporary Tablespace

🔴 Diagnosing And Repairing Locally Managed Tablespace Problems

🔴 Transporting Tablespaces

🔴 Managing REDO LOGFILES

🔴 Managing Control Files

🔴 Cloning an Oracle Database

🔴 Managing The UNDO TABLESPACE

🔴 SQL Loader

🔴 Export And Import

🔴 Using Import Utility

🔴 DATA PUMP Utility

🔴 Data Pump Import Utility

🔴 Oracle Flash Back Query

🔴 Using Oracle Flashback Database

🔴 Flashback Data Archive (Oracle Total Recall)

🔴 Log Miner

🔴 Backup and Recovery in Oracle

Recovery Manager ( RMAN )

🔴 Taking Offline Backups using RMAN
🔴 Recovering the Database running in NOARCHIVELOG mode using RMAN
🔴 Taking Online Backups using RMAN
🔴 Taking backups of particular tablespaces or datafiles using RMAN
🔴 How to take Image Backups in RMAN
🔴 Taking Incremental Backup using RMAN
🔴 Incrementally updating backup copy for fast recovery
🔴 View information about RMAN backups
🔴 Configuring Retention policy in Oracle RMAN
🔴 Configure various Options in RMAN
🔴 Maintaining RMAN Repository
🔴 Recovering from the loss of datafiles using RMAN (Archivelog mode)
🔴 Recovering from the loss of datafile by changing it's location
🔴 Performing Disaster Recovery using RMAN