PRCD-1119 : Failed to create database

I was doing some testing with data guard and cascading databases and came across the following error whilst trying to create a 2nd standby on the same server as the first:- oracle:tst_pstby2 >srvctl add database -d tst_pstby2 -n tstlive -o

Posted in Uncategorized

Connection To RMAN Auxiliary Fails With ORA-01031: INSUFFICIENT PRIVILEGES

Symptoms I am trying to build a dataguard configuration and when attempting to connect to the auxiliary instance RMAN fails with ORA-01031 errors. RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges I then tried connecting directly via sqlplus sqlplus “@

Posted in Uncategorized

Error when upgrading RMAN catalog to 12c

Been looking upgrading to 12c recently and with that comes the upgrade of the rman catalog. The current plan was to leave the RDBMS at 11g but upgrade the catalog to 12.1.0.2 to cover the new databases. From experience it

Tagged with: , , ,
Posted in RMAN

Upgrading an RMAN catalog – Without upgrading the RDBMS software

Until recently I was not aware that this was even a thing, but the version of the catalog database that you use can be higher than the RDBMS version running the CATALOG database. How is is this achieved i hear

Posted in Uncategorized

Creating a RMAN catalog

Been doing alot of RMAN related work and realised that I’ve not got anything up here to reference so here is the start of a few RMAN articles. This article assumes that you know what RMAN is and understand what

Tagged with: , , ,
Posted in RMAN

Slow logon time to OUEL 7 Boxes

Just started messing around with OUEL7 installations before going on site to help install a new RAC cluster. One issue that I noticed almost straight after the installation completed was it took AGES to login to the terminal using ssh.

Tagged with: , , ,
Posted in DBA Admin, Installation, LINUX Admin

Removing old tape backups from RMAN

Hit a problem yesterday, working on a new site reviewing database configurations when i discovered tape backups listed from 2008. After a bit of investigation it turned out they hadnt backed up to tape since 2010 so these bad boys

Tagged with: , , , , , ,
Posted in DBA Admin, RMAN