When a user's password expires in one of the databases that I manage, some users complain that it is an application user and the password should never expires. Thus, if the schema really should be used only by the application, I've created a process that will control this access based on the user session information, …
January 2015 archive
Jan 14
OCM 11g Preparation - Course requirements
There are 2 things to remember here that are very important: "Courses used to fulfill the OCP training requirement may not be used again to fulfill the OCM training requirement." "Courses can be instructor-led in-class (ILT), a live virtual class (LVC) or training on demand (TOD). Self-study CD and online courses are great preparation tools, …
Jan 09
Resume an Oracle DUPLICATE database that failed on RECOVERY of datafiles
A time ago, the problem that I used to face was the failure of the recovery part of the duplicate script for any problems (like forgetting to set the db_recovery_area_dest_size big enough to hold the archives that will come from duplicate) and I ended up having to start the DUPLICATE command all over again. The recovery …
Jan 09
OCM 11g Preparation - Mantain recovery catalogs
Catalogs are the best place to keep your database records, as you can keep a long history and also be safe about your backup locations in case you lose your controlfile. The catalog also allow you to share the backup across the data guard instances. You need to do all sort of operations that involve …
- 1
- 2
About
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
