If you are running Oracle EE, there are many books on Data Guard. However, for Oracle SE and manual standby, have fun searching.
I wanted to get a better understanding of registering logfile.
Depending on how the standby environment is monitored, not registering logfile may yield incorrect results when checking standby lag.
When logfile is not registered, v$archived_log is not updated.
STANDBY: check status
$ sqlplus / as sysdba @stby.sql
SQL*Plus: Release 11. (more...)
You may be thinking, why clone Goldengate and why now just download it?
The exact version and patch level might not be available.
Too lazy to search for it and many other reasons you can come up with.
Why use rsync and not tar – scp? I wanted to refresh memory of using rsync.
local source /u01/app/ggs01/ and remote target arrow:/u01/app/ggs03/
rsync -avh --delete --dry-run --exclude 'dirdatold' /u01/app/ggs01/ arrow:/u01/app/ggs03/
rsync -avh --delete --exclude (more...)
When using Goldengate to instantiate target database from an Oracle source database, replicat process can be started to concide with extract based the method used for instantiation, e.g. RMAN or datapump.
ATSCN is used to start replicat if RMAN is used to instantiate target.
From Database Backup and Recovery Reference, UNTIL SCN specifies an SCN as an upper limit.
RMAN restore or recover up to but not including the specified SCN.
AFTERSCN is used (more...)
Purpose is to demonstrate how to create HA for Bi-Directional Replication Goldengate installed on ACFS with RAC cluster using XAG.
XAG simplifies the process since there are no requirements to create action scripts.
Please review REFERENCE section for versions used in test case and versions requirements.
Goldengate is installed on ACFS for simplicity; otherwise, at a minimum the following directories br, dirchk, dirdat, dirtmp will need to be on shared storage with symbolic links if (more...)
I am losing the luxury of using GUI since clients typically may not have X-Windows or VNC Server installed
Adapt or die and re-learning command line again.
Better to verify before installation than to clean up a problematic install.
Use runcluvfy to verify DB install:
runcluvfy.sh stage -pre dbinst -n rac01,rac02 -r 11gR2 -d /u01/app/oracle/product/184.108.40.206/db_1 -osdba dba -fixup -fixupdir /tmp -verbose
Use runInstaller -executePrereqs to verify responseFile for silent install and detect issues:
My typical VirtualBox network configuration is: eth0 (NAT), eth1 (Host Only), eth2(Internal)
runcluvfy.sh stage -pre crsinst -n rac01,rac02 -r 11gR2 -fixup -fixupdir /tmp – FAILED
Node connectivity passed for subnet "10.0.2.0" with node(s) rac02,rac01
PRVF-7617 : Node connectivity between "rac01 : 10.0.2.15" and "rac02 : 10.0.2.15" failed
TCP connectivity check failed for subnet "10.0.2.0"
Node connectivity passed for subnet "192.168. (more...)
Sometimes I get excited over simple things. Today, I learned something new, something about human behaviors.
Basically, there are 4 quadrants for human behaviors.
If one does not understand the other person’s behavior, then communication can be very difficult.
To find more about human behaviors, read The DISC Model of Human Behavior – A Quick Overview.
Which quadrant are you in, versus your manager?
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?