   Oracle 12c database administration培訓

Oracle architecture overview
Instance and database
New instance features in Oracle 12c
Multitenant architecture
Container databases
Pluggable databases

System security, instance and database configuration
Server access management and database access for SYSDBA role users
Initialization parameters - binary and text parameter file
Starting and shutting down the instance
Opening and closing the database
Opening and closing of pluggable databases (PDBs) in Oracle 12c
Status of the instance and databases (container and pluggable ones)
Permissions
Roles
Profile management

Oracle Net
Call descriptors
Network services
Listener server process
Oracle Net Manager
Serve and client configuration for remote connection

Logical storage structure
Tablespaces
Segments
Extents
Blocks

Database users
Database architecture
Schemas and their objects
Global and local schema in Oracle 12c
User management in Oracle 12c

Logical database structure
Tabels
limitations
Indexes
Views
Profiles
Sequences
Synonyms
Directories

Managing the physical database structure
Initialization parameters and passwords
Alert.log file and trace files
Controlfiles management
Adding and moving control files
Redo.log files management
Mirrorig, adding and moving redo files
Switching the database mode and the difference between the ARCHIVELOG and NOARCHIVELOG modes
Archivelog file management
Mirroring, adding and moving archivelog files
Data file management and free space on disks
Moving data files
Database files in Oracle 12c containers
Automatic Storage Management architecture

Disk space management
Problems with free space in tablespaces
Free disk space management
Providing space for temporary segments
Fragmented tablespaces and segments
Multiple files tablespaces
Segment advisor
Undo Advisor
Use of indexes

Memory structures within instances
SGA area
PGA area
Area of ??executable code
Secondary processes
Dynamic memory management
ASMM since 10g and AMM since 11g

Creating a database
Differences in the creation of non-PDB and PDB databases
Selecting and updating data (how SQL commands are processed)
Ensuring consistency and concurrency of transactions
Database structure management
Tablespaces
Types of tablespaces
OFA (Optimal Flexible Architecture) architecture
System tablesspace
SYSAUX tablespace
TEMP tablespace
UNDO tablespace
USERS table space
EXAMPLE table space
Tablespace management
Resizing table space
Segments in tablespaces
Moving tables to different tablespaces or to the same tablespace vs HighWaterMark vs Indexes

Archiving and database recovery:
Hot and cold backup
Backup of datafiles and control files
Restoring and recovering the database
RMAN - Recovery Manager
Backup using the RMAN tool
Restoring and recovering database using the RMAN tool

Oracle Flashback
Flashback Query - retrospective queries
DBMS_FLASHBACK package - moving the session back and forward in time
FlashbackVersions Query - querying data versions over time
FlashbackTransaction Query - monitoring of all DML commands in database
FlashbackTable - moving tables back and forward in time
Flashback Drop - retrieving dropped tables back
Flashback Database - moving the database back in time

National language support
Oracle Scheduler and the DBMS_SCHEDULER package
Control system resources