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

Switchover Dataguard under Cloud Control 12c fails

During a switchover test in Enterprise Manager Cloud Control 12c, I got the error:

--------------------------------------------------------------------------------

Session Information Unavailable

Enterprise Manager is unable to proceed. The most likely cause of this is that database session information could not be retrieved or that EM was unable to process a user-invoked bookmark. Press OK to continue.

--------------------------------------------------------------------------------


The switchover did not take place, even though under DGMGRL it works fine, and the Verify Configuration in Cloud Control reveals no errors.

This appears to be a stupid bug in IE9. It runs fine under Chrome! See Doc ID 1512567.1 under Oracle Support.

This really makes me ....