April 2015 archive

OCM 11g Preparation - Use Recovery Manager to perform database backups

Creating an efficient backup strategy is important to reduce your recover time. If your system is critical, the backup procedure must be setup accordingly to meet the SLA requirements. For OCM exam, I have no idea what they will ask. Keep in mind to trace some plan to restore/recover what you need in the most …

Continue reading

OCM 11g Preparation - Create and manage LOB segments

In OCM exam they can ask you to do all sort of operations using LOBs. So, be prepared for them. In the docs there are some example PL/SQL blocks that can be used as template. However, read everything and keep in mind: Differences between Empty and Null LOB Inline and Out-of-Line LOB Storage How to …

Continue reading

Oracle Data Guard error - Force closing the keystore for standby rekey.

I have a Primary 11g Oracle Database with a single Physical Standby. Those days I tried to create an encrypted column inside one table for testing purposes. I end up accidentally messing the things: Force closing the keystore for standby rekey. Please re-copy the keystore from primary before re-open as needed. Apply redo for database master …

Continue reading

OCM 11g Preparation - Implement securefile LOB

Securefile LOBs are a new way of storing LOBs that allows us to enable compression, deduplication, or encryption. In the exam, we need to know how to manage them: Using CREATE TABLE with SecureFiles LOBs Using ALTER TABLE with SecureFiles LOBs Initialization Parameter db_securefile for SecureFiles LOBs PL/SQL Packages for SecureFiles LOBs "Database File System …

Continue reading

OCM 11g Preparation - Maintain indexes on a partitioned table

Now that you know how to manage the partitions, start working with their indexes: Rebuilding Global Index Partitions Rebuild each partition by issuing the ALTER INDEX ... REBUILD PARTITION statement (you can run the rebuilds concurrently). Drop the entire global index and re-create it. This method is more efficient because the table is scanned only …

Continue reading