RMAN Pet Peeves

Do you validate your backup and what command do you use?

Lately, I have been using restore database validate preview summary to kill 2 birds with 1 stone.

The issue is RMAN will skip validation of archived log backupset when archived log exists.

Does this seem wrong to you?

Please take a look at a test case here

What do you think?

Create Physical Standby Database using RMAN Restore

Normally, when I create physical standby database, the configuration has the same directory structures and name values as production with the exception of db_unique_name.

But this time was not the case as shown below.

ANGEL:(SYS@xmenstby):PHYSICAL STANDBY> show parameter name

NAME                      TYPE        VALUE
------------------------- ----------- ----------------------------------------
cell_offloadgroup_name    string
db_file_name_convert      string      /oradata/xmenprod, /oradata/xmenstby
db_name                   string      xmenprod
db_unique_name            string      angel_xmenstby
global_names              boolean     FALSE
instance_name             string      xmenstby
lock_name_space           string
log_file_name_convert     string      /oradata/xmenprod, /oradata/xmenstby
processor_group_name      string
service_names             string      xmenstby

I (more...)

Employees Who Stay In Companies Longer Than Two Years Get Paid 50% Less

I came across an interesting article Employees Who Stay In Companies Longer Than Two Years Get Paid 50% Less and thought to share with you.

Let’s use the rule of 72 as an example.

Basically, the rule of 72 is a simple method of determining the number of years an investment will double by dividing 72 by the rate of return.

With a 4% annual salary increase, salary will double in 18 years (72/4).

With an (more...)


Another wager lost to my daughter, this time an iPhone 5s.
Thank God she does not want the 6.

Learning the alphabets in school, A is for apple.
Earning straight A’s all the way through 8th grade.
Having dad pay for all the Apple toys – Priceless!

Learning RMAN is like learning to ride a bike

For almost five years, I have used RMAN very minimally.

Luckily, learning RMAN is like learning to ride a bike. One may not be able to perform wheelie, but one does not forget.

Please allow me to share the details on how to restore database to a new server, new database name, and new location using RMAN.


At source, database is using OMF and backup is located at /oradata/backup.
At target, database is not using (more...)

Headless VirtualBox on Windows 7

Recently I came to know about Headless features for VirtualBox and was curious as to how it works.

When using Headless, there is not a need to start VirtualBox GUI which is nice and removes clutters from Desktop.

Here’s a demo on how to start VirtualBox Headless.

List available VMs.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\dinh>cd "c:\Program Files\Oracle\VirtualBox"

c:\Program Files\Oracle\VirtualBox>VBoxManage.exe list vms
"arrow" {202d474e-7b00-4fce-a38a-844a650545b8}

Start (more...)

Rolling forward a standby database using RMAN Incremental Backup

I am not going to post on how to roll forward standby database as it has been written in many blogs already.

Instead, I am going to share what I have learned how it may have been done incorrectly using the wrong SCN.

Typically, select current_scn from v$database should work until it doesn’t.

But why take the chance and why not do it right the first time.

In reviewing Steps to perform for Rolling forward a standby (more...)

GoldenGate 12c Features Found in ???

I was curious if there was a way to add supplemental logging for ALL columns at the schema level.

Oracle GoldenGate Release Notes 12c (12.1.2) for Windows and UNIX April 2014

ADD SCHEMATRANDATA and ADD TRANDATA have been enhanced to support integrated Replicat for Oracle.

A new ALLCOLS option enables the unconditional logging of all of the key and non-key columns of a table.

Sounds great, but I am not on 12c and (more...)

Missing Password for Database Link Bug

So there I was, working on another database duplication project, the requirement is to save the existing database links.

Sounds pretty easy, right?


Wrong and I know why I am getting bald. Pulling my hair out.

After searching for hours, I found DBMS_METADATA.GET_DDL database link password missing

Another Bug.

I believe the bug was introduced when I modified user’s password as (more...)

Automating DataPump Export

Please click link here to read my blog at Pythian.