OCP 12C – Information Lifecycle Management and Storage Enhancements

Information Lifecycle Management

Before reading this flashcard I recommend you to read my article on ILM.

Policy based data management
Let you define policies at :
- Tablespace level
- Segment level
- Row level
Policies can either compress data or move data to a different tablespace
Policies let you define when, what and where to move data
Heat Map collect statistics used to trigger ADO actions
Heat Map collects statistics on data utilization like:
- When does this row was last updated
- When does this table was last updated
- …
Policies let you define what to do with :
- Active data
- Frequently accessed data
- Infrequently accessed data
- Dormant data
Policies let you also define what to do with data when you encounter space pressure in a tablespace.

To make a database backup you need the SYSBACKUP or SYSDBA privilege.
You can backup the CDB and all the PDBs independantly, all together, or by specifying a list.
You can backup a PDB by connecting directly to it and use:
- RMAN> BACKUP DATABASE:
You can backup a PDB by connecting to the CDB and use:
- RMAN> BACKUP PLUGGABLE DATABASE MY_PDB;
To backup only the root (CDB$ROOT) connect to the CDB and use:
- RMAN> BACKUP DATABASE ROOT;
You can backup everything by connecting to the CDB and use:
- RMAN> BACKUP DATABASE;
You can backup only some PDBs by using:
- RMAN > BACKUP PLUGGABLE DATABASE PDB1, PDB2, PDB3;

You can backup tablespaces from several PDBs at the same time when connected to the root using:
- RMAN> BACKUP TABLESPACE PDB1:USERS, PDB2:TOOLS, PDB3:SYSTEM;
You can also backup tablespaces using the standard command when you connect directly to the PDB:
- RMAN> BACKUP TABLESPACE SYSTEM;
To backup datafiles for a PDB you can :
- Connect to the root and use : BACKUP DATAFILE 12,13,14;
- Connect to the PDB and use : BACKUP DATAFILE 12,13,14;

Connecting to a CDB or PDB is not different of connecting to a standard database.
When you create a PDB, it is automatically assigned a service which can be used to reach this specific PDB.
You can either use the EZ connect syntax, the Oracle Net Service syntax or the new : ALTER SESSION SET CONTAINER syntax.
The CDB_SERVICES view lets you view the services for each PDB.
The SHOW CON_NAME command can be used to identify the container your are connected to.

Only a common user can connect to CDB$ROOT.
To use the ALTER SESSION SET CONTAINER command, a common user must have the SET CONTAINER privilege.
All management tasks except PLUG/UNPLUG and STOP/START in a PDB are equivalent to a standard database.
You can use the CONTAINER=ALL clause in a DDL statement to execute it in all PDBs. This can only be done by a common user with the SET CONTAINER privilege.
By DEFAULT when you issue a DDL the CONTAINER clause is equal to CURRENT.
A common user name starts wth C##