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?
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
------------------------- ----------- ----------------------------------------
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
log_file_name_convert string /oradata/xmenprod, /oradata/xmenstby
service_names string xmenstby
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!
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...)
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
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...)
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...)
So there I was, working on another database duplication project, the requirement is to save the existing database links.
Sounds pretty easy, right?
SELECT OWNER, DB_LINK, DBMS_METADATA.GET_DDL('DB_LINK',DB_LINK,OWNER) as DDL FROM DBA_DB_LINKS;
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 126.96.36.199 Bug.
I believe the bug was introduced when I modified user’s password as (more...)
Please click link here to read my blog at Pythian.