A pluggable database is a self-contained, fully-functional Oracle database. We often need to move the pluggable database from one CDB to another CDB. This will be a unplug/plug operation where outage will depend on the location of source and destination CDB (1) When moving between servers with shared storage, such as is typically the case …
PDB Relocate in Oracle database 12c Release 2 Read More »
Introduction Refreshable PDB is a new feature introduced in Oracle database from 12.2 onwards i.e 12.2/18c/19c . It builds upon hot clone capability in Oracle Database 12.2. It basically means we can refresh the remote PDB from source PDB on regular intervals by just applying the incremental redo This feature eliminates the need to re-create …
In Oracle database release 12.1, in order to clone a PDB, The source PDB must be quiescent(read only mode) for the duration of the clone operation. So it was called a “cold clone” operation because it involved an outage (from a transactional perspective) in the source database. This applies for both the same CDB clone …
Here are the Important Oracle Database Health check Database, Datafile and Backup select name,open_mode,log_mode,database_role,force_logging,flashback_on from v$database;select * from v$recover_file;select distinct status,count() from v$datafile group by status;select name, RECOVER from v$datafile_header where RECOVER != ‘NO’;select name, ERROR from v$datafile_header where ERROR is NOT NULL;select name, ts# from v$datafile where upper(name) like ‘%MISSING%’;select NAME, FILE# from v$datafile …
Introduction to Cloud Computing Cloud computing is a type of Internet-based computing that provides shared computer processing resources and data to computers and other devices on demand. It is a model for providing on-demand access to a shared pool of configurable computing resources (Example computer networks, servers, storage, applications, and services) which can be rapidly provisioned …
We already know how to create user and grant privileges in a traditional non-CDB database. Check the below detailed post to learn about it Create User in Oracle Let’s find out now, how to create a user in oracle 12c. In a non-CDB, a user name or Roles cannot begin with C## or c## How …
How to create Users and Roles in Oracle database 12c Read More »
