CDB and PDB View • CDB_xxx: All of the objects in the CDB across all PDBs • DBA_xxx: All of the objects in a container or PDB • CDB_pdbs: All PDBs within CDB • CDB_tablespaces: All tablespaces within CDB • CDB_users: All users within CDB (common and local) • V$PDBS: Displays information about PDBs associated … Читать далее
A database operation is: • One or more SQL or PL/SQL statements • A series of statements done from on or more sessions A database operation can: • Be monitored • Produce active reports A DB operation is an operation that the database server runs to accomplish tasks. It can be either simple or composite. … Читать далее
Available Redaction Methods Type Description None No redaction is performed. Full Columns are redacted to constant values based on the column data type. Partial User-specified positions are replaced by a user-specified character. Random Data type is preserved and different values are output each time. Regular Expression A “match and replace” based on parameters is performed. … Читать далее
Oracle Database 12c offers a new package to analyze used privileges. Privilege Analysis requires Oracle Database Vault, which is a licensed option. good tutorial: Privilege Analysis Types and Conditions When creating an analysis, you first define the targeted objects to be analyzed in used privileges. You do that by setting the type of analysis: • … Читать далее
An Online Move data file operation is not compatible when: • The data file is an OFFLINE data file • A concurrent flashback database operation is executing • A media recovery is completing • A file shrink operation or tablespace offline/drop operation involving the same file is performing But it is compatible with: • Block … Читать далее
Heat Map and Automatic Data Optimization Heat Map and Automatic Data Optimization: Heat Map and Automatic Data Optimization (ADO) can be used to implement your Information Lifecycle Management (ILM) strategy, along with Partitioning, Advanced Compression, and Hybrid Columnar Compression. usefull links: *youtube Manage Automatic Data Optimization (ADO) with Enterprise Manager Cloud Control 12c Exploring Oracle … Читать далее
Media Failure CDB Temporary File Recovery • Automatic re-creation of temporary files at CDB opening • Manual re-creation also possible The CDB instance can start up with a missing temporary file. If any of the temporary files do not exist when the CDB instance is started, they are created automatically and the CDB opens normally. … Читать далее
quick way to make standby of small database is to make backup, copy it to destination and create standby backup on source: param file: copy to standby,modify audit dest and create spfile: restore database: configure standby: DGMGRL> show configuration;
script to monitor status of full and inc backup