The Arup Nanda Blog: Restoring Controlfile When AUTOBACKUP Fail

The Arup Nanda Blog: Restoring Controlfile When AUTOBACKUP Fail: Allow me to present the snapshot of a day from the life of John--the DBA at Acme Bank. On this particular day a database John manages crashe...

Oracle Database 12c: RMAN Restore and Recover for Multitenant Architect...

Oracle Database 12c: RMAN Restore and Recover for Multitenant Architect...: In this demo I will show how to handle different types of RMAN restore and recover in a Multitenant environment. In a Multitenant envir...

Oracle Database 12c: RMAN Restore and Recover for Multitenant Architect...

Oracle Database 12c: RMAN Restore and Recover for Multitenant Architect...: In this demo I will show how to handle different types of RMAN restore and recover in a Multitenant environment. In a Multitenant envir...

Database administrator workshop: How to encrypt the data (tablespace or column's ta...

Database administrator workshop: How to encrypt the data (tablespace or column's ta...: To create a standard Oracle wallet and then add a master key to it you have to follow few basic steps: 1) Configure the sqlnet.ora file to ...

Database administrator workshop: How to configure Transparent Data Encryption using...

Database administrator workshop: How to configure Transparent Data Encryption using...: Oracle uses an operating system file to contains authentication and signing credentials: this file, named ewallet.p12, is the so called Orac...

Database administrator workshop: Steps to create, open and close an Oracle Wallet u...

Database administrator workshop: Steps to create, open and close an Oracle Wallet u...: It's possible to create the Oracle Wallet using the owm gui utility or from sqlplus with a new set of key management statements (ADMI...

Database administrator workshop: Steps to create, open and close an Oracle Wallet u...

Database administrator workshop: Steps to create, open and close an Oracle Wallet u...: It's possible to create the Oracle Wallet using the owm gui utility or from sqlplus with a new set of key management statements (ADMI...

Database administrator workshop: Software only installation of Oracle Database 12c ...

Database administrator workshop: Software only installation of Oracle Database 12c ...: In this post I'm going to install only the software of the Oracle Database 12c release 1. Download from Oracle website and extract it ...

Database administrator workshop: Installing Oracle Database 12c as Container Databa...

Database administrator workshop: Installing Oracle Database 12c as Container Databa...: Here is a video recorded during the creation of the first database. Go on if you want to see all the screenshots. So we have already ins...

Database administrator workshop: How to create a pluggable database by unplugging a...

Database administrator workshop: How to create a pluggable database by unplugging a...: So I want to create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and I w...

Database administrator workshop: How to unplug a PDB and plug it back into the same...

Database administrator workshop: How to unplug a PDB and plug it back into the same...: You have just unplugged a PDB and want to know how to eventually plug it back into the same container. Let's assume I have a pluggable ...

Database administrator workshop: How to create a PDB from a Non-CDB using DBMS_PDB ...

Database administrator workshop: How to create a PDB from a Non-CDB using DBMS_PDB ...: To test this scenario I have recently created using DBCA a non container database named ORCL. CDB001 and CDBTEST are instead two container d...

Database administrator workshop: How to create a PDB from a Non-CDB (12c) using Ora...

Database administrator workshop: How to create a PDB from a Non-CDB (12c) using Ora...: Beside the DBMS_PDB package you can use Oracle Data Pump to create a pluggable database from a non-container database: it consists to expo...

Database administrator workshop: Differences in default RMAN configuration settings...

Database administrator workshop: Differences in default RMAN configuration settings...: I wanted to write a post on configuring the RMAN environment using the SHOW and CONFIGURE commands in Oracle Database 12c, but after few c...

Database administrator workshop: How to recover a table in a pluggable database fro...

Database administrator workshop: How to recover a table in a pluggable database fro...: I'm going to test some useful recovery scenarios for the Oracle Database 12c release. An interesting option introduced with this releas...

Database administrator workshop: How to recover a table in a pluggable database fro...

Database administrator workshop: How to recover a table in a pluggable database fro...: I'm going to test some useful recovery scenarios for the Oracle Database 12c release. An interesting option introduced with this releas...

Database administrator workshop: How to identify which pdbs a backup set belong to

Database administrator workshop: How to identify which pdbs a backup set belong to: I want to see what useful information are returned by few RMAN commands such as report schema or list backup when using the default RMAN c...

Database administrator workshop: RMAN and SQL statement enhancements in Oracle Data...

Database administrator workshop: RMAN and SQL statement enhancements in Oracle Data...: One of the most useful enhancement Oracle has introduced within the release 12c in RMAN is the possibility to execute more SQL statements. ...

Database administrator workshop: How to rename everything on Oracle Database (redol...

Database administrator workshop: How to rename everything on Oracle Database (redol...: Few days ago I was wondering how many RENAME clauses are available on Oracle Database. I have summarized them here: Renaming redolog membe...

Database administrator workshop: How to use the new SYSBACKUP privilege to perform ...

Database administrator workshop: How to use the new SYSBACKUP privilege to perform ...: The SYSBACKUP is a new privilege introduced in the Oracle Database 12c release that allows a user to perform any backup or recovery operatio...

Brendan Tierney - Oralytics Blog: Something new in 12c: FETCH FIRST x ROWS

Brendan Tierney - Oralytics Blog: Something new in 12c: FETCH FIRST x ROWS: In this post I want to show some example of using a new feature in 12c for selecting the first X number of records from the results set of a...

MP Oracle Blog: Adaptive Plans in 12c

MP Oracle Blog: Adaptive Plans in 12c: Gestern habe ich im OTN Forum ein paar Fragen zum grundsätzlichen Verhalten der in 12c eingeführten Adaptive Plans gestellt, aber inzwisc...

elcarOnOsdnaH: 12c Pluggable DB Point In Time RecoveryWhile work...

elcarOnOsdnaH: 12c Pluggable DB Point In Time Recovery
While work...: 12c Pluggable DB Point In Time Recovery While working with pluggable database in our test environment, we came across situation where we...

Database administrator workshop: How to create a pluggable database by unplugging a...

Database administrator workshop: How to create a pluggable database by unplugging a...: So I want to create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and I w...

Database administrator workshop: How to unplug a PDB and plug it back into the same...

Database administrator workshop: How to unplug a PDB and plug it back into the same...: You have just unplugged a PDB and want to know how to eventually plug it back into the same container. Let's assume I have a pluggable ...

Database administrator workshop: Oracle 11gR2 RAC installation: install and configu...

Database administrator workshop: Oracle 11gR2 RAC installation: install and configu...: T his post will describe how to install and configure OCFS2, the Oracle Cluster File System, a shared disk file system developed by Oracle C...

Database administrator workshop: How to delete an Oracle VM virtual machine

Database administrator workshop: How to delete an Oracle VM virtual machine: Its' so easy to delete a Oracle virtual machine. Just expand your Server Pools and select your virtual machine you don't need anymo...

Database administrator workshop: Oracle 11gR2 RAC installation: kernel, ssh user eq...

Database administrator workshop: Oracle 11gR2 RAC installation: kernel, ssh user eq...: T his post will describe how to configure SSH user equivalency, set some kernel parameters, the network, sync the time between the two nodes...

Database administrator workshop: How to create a pluggable database by unplugging a...

Database administrator workshop: How to create a pluggable database by unplugging a...: So I want to create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and I w...

alt.oracle: Data Pump 12c – Pumping Data with the LOGTIME Para...

alt.oracle: Data Pump 12c – Pumping Data with the LOGTIME Para...: Since its release, Oracle Data Pump has been a worthy successor to the traditional exp/imp tools.  However, one area lacking with Data Pump...

Database administrator workshop: How to create a pluggable database by unplugging a...

Database administrator workshop: How to create a pluggable database by unplugging a...: So I want to create a new pluggable database into the CDBTEST container located into vsi08devpom machine (@vsi08devpom in this post) and I w...

Database administrator workshop: How to unplug a PDB and plug it back into the same...

Database administrator workshop: How to unplug a PDB and plug it back into the same...: You have just unplugged a PDB and want to know how to eventually plug it back into the same container. Let's assume I have a pluggable ...

The Infra Diary: How to grow aka extend ZFS datasets and Volumes?

The Infra Diary: How to grow aka extend ZFS datasets and Volumes?: ZFS Chapters: 1). How to Manage and Maintain ZFS file systems? 2). How to create ZFS file system and Volumes ? 3). How to set ZFS...