There are two types of Undo Modes in 12.2 1) Shared Undo – The Undo tablespace is common, it is shared among the entire CDB. The Management of undo tablespace is similar to Non-CDB database. 2) Local Undo – The Local undo is local particular PDB or a container The benefits having local undo enables … Read more
Relocating an Online Data File Copying an Online Data File This example copies the data file to +DEV_DG and the old file is retained in the /rman_backup/backup directory. Relocating an Online Data File and Overwriting an Existing File This example moves the data file to /rman_backup/backup directory. If a file with the same name exists … Read more
11g When OMF is enabled and If a datafile location is incorrect the file gets created in dbs location 12c Oracle Managed Files will ignore the user provided datafile input and creates datafiles in OMF managed location
Managing tablespace in container database is similar to non-container database. Provided you are logged in as a privileged user and point to right container. Manage Tablespace in CDB Managing Tablespace in PDB Tablespace info in Multitenant: Temp tablespace details in Multitenant: Check to undo mode in Multitenant DB:
Common user password we can change from only cdb level .container class is optional.
From oracle 12c onwards the default user’s account passwords have to change from cdb container. container class is optional.
From 12c onwards we have new feature called lockdown profile to control the PDB level activities. It can be created in CDB container. Note: once we set this lockdown profile to PDB. Particular PDB will not support any of the alert system options except killing session.
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Roles: Collection of privileges called role. In 12c we have 2 different types of role. They are: 1) Common role 2) Local role Common Role: We have grant the common role to both common & local user. Granting … Read more
Privilege Management: Privilege management has been classified into 2 sub divisions. They are: 1) Grants 2) Roles Grants: oracle12c have two variant of grants. They are: 1) Common grants 2) Local grants Common grants: Common grants will be only applicable for particular user present in both CDB & PDB as well. Local grants: Local grant … Read more