Cold backup Container database with pluggable databases - open after backup

Hi,
Just a simple script to backup a 12c database, cold, and make sure to open the pluggable databases afterwards.

run {
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
BACKUP AS COMPRESSED BACKUPSET DATABASE INCLUDE CURRENT CONTROLFILE;
}
ALTER DATABASE OPEN;
ALTER PLUGGABLE DATABASE ALL OPEN;
BACKUP VALIDATE DATABASE;
CROSSCHECK BACKUP;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;

This will keep your users happy the next morning :-)

SQL*Developer now supplied with Oracle 12c

You will never have to search and download SQL*Developer. It's allready supplied in the 12c RDBMS home!

cd $ORACLE_HOME/sqldeveloper
./sqldeveloper.sh

Make sure you run in graphical mode (or use Xming, WinX-32 or something like that).

I found it was very slow on XMing to a remote database on vpn.... so maybe I won't use it much.

[oracle@myhost sqldeveloper]$ pwd
/opt/oracle/product/12.1.0/dbhome_1/sqldeveloper
[oracle@myhost sqldeveloper]$ ls -l
total 136
drwxr-xr-x.  4 oracle oinstall  4096 Sep 10 09:47 dataminer
-rw-r--r--.  1 oracle oinstall  1404 Nov  1  2012 icon.png
drwxr-xr-x.  8 oracle oinstall  4096 Sep 10 09:47 ide
drwxr-xr-x.  3 oracle oinstall  4096 Sep 10 09:47 javavm
drwxr-xr-x.  3 oracle oinstall  4096 Sep 10 09:47 jdbc
drwxr-xr-x.  6 oracle oinstall  4096 Sep 10 09:47 jdev
-rw-r--r--.  1 oracle oinstall    49 Nov 30  2011 jdev.label
drwxr-xr-x.  2 oracle oinstall  4096 Sep 10 09:48 jlib
drwxr-xr-x.  2 oracle oinstall  4096 Sep 10 09:48 jviews
drwxr-xr-x. 12 oracle oinstall  4096 Sep 10 09:48 modules
drwxr-xr-x.  3 oracle oinstall  4096 Sep 10 09:47 rdbms
-rw-r--r--.  1 oracle oinstall 36022 Nov  1  2012 readme.html
drwxr-xr-x.  3 oracle oinstall  4096 Sep 10 09:47 sleepycat
drwxr-xr-x.  8 oracle oinstall  4096 Sep 10 09:47 sqldeveloper
-rwxr-x---.  1 oracle oinstall 32768 Nov  1  2012 sqldeveloper.exe
-rwxr-x---.  1 oracle oinstall    71 Nov  1  2012 sqldeveloper.sh
drwxr-xr-x.  3 oracle oinstall  4096 Sep 10 09:47 sqlj
drwxr-xr-x.  2 oracle oinstall  4096 Sep 10 09:48 timingframework
-rw-r--r--.  1 oracle oinstall  2979 Nov 22  2011 view-source-paths.lis

Cannot add a second redaction policy using EM Cloud Control

Hi,

Using EM Cloud Control 12.1.0.3.0, I added a Redaction Policy (DBMS_REDACT) to a PAUL schema in a pluggable database. This worked fine and my social security numbers could not be read by user BOB.

        ID NAME      SS_NUMBER          INDATE
---------- --------- ------------------ ------------------------------
       100 matt      XXX-XX-1234        10-OCT-13 09.02.43.082299 AM
       110 bob       XXX-XX-3333        10-OCT-13 09.02.43.086830 AM

Now I wanted to add a second policy on another of PAUL's table. But the EM Cloud Control does not show the PAUL schema anymore, I cannot select the schema while for creating a policy.

I think this is a bug, reported it to MOS.

I'm curious if someone can replay this error. You will need 12.1 database, with container and pluggable database, and 12.1.0.3 EM Cloud Control.

Regards,
Paul