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 … Читать далее
Flashback CDB Enable flashback: If the CDB is in ARCHIVELOG mode, there is no need to restart it. Restrictions: • You cannot flash back the root alone without flashing back the entire CDB. • Flashback Database operations on a CDB may not be permitted if point-in-time recovery has been performed on any of its PDBs. … Читать далее
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. … Читать далее
To set the operating system user for a PDB: 1. Log in to the root as a user and execute the DBMS_CREDENTIAL.CREATE_CREDENTIAL procedure to create an Oracle credential for the $user operating system user: 2. Connect to the PDB to set the PDB_OS_CREDENTIAL to the new credential: 3. Restart the CDB instance. 4. Test the … Читать далее