wayne-lang.blogspot.com
Oracle DBA: March 2011
http://wayne-lang.blogspot.com/2011_03_01_archive.html
Diary from a DBA deals with Oracle technology. Monday, March 14, 2011. Saturday, March 12, 2011. Many faces of an Oracle data block. There are all kinds of data block in Oracle database, such as table segment block, index data block, undo segment block, or data file head block, to name a few. Let’s just talk about the table data block for now. Subscribe to: Posts (Atom). Many faces of an Oracle data block. View my complete profile. The Arup Nanda Blog. No Data Loss without Sync Data Guard.
wayne-lang.blogspot.com
Oracle DBA: February 2010
http://wayne-lang.blogspot.com/2010_02_01_archive.html
Diary from a DBA deals with Oracle technology. Tuesday, February 23, 2010. Solid State Disk as Oracle storage. In the blog, I present the IO testing result of SSD against SAN using ORION (Oracle IO Calibration tool). ORION result is more closely mimicking of Oracle database IO characteristics. Friday, February 19, 2010. First Impression of Oracle 11gR2 RAC. 11g Release 2 RAC has some major changes from 11g Release 1. Another new feature of 11g Release 2 is SCAN (Single Client Access Name) which binds rou...
wayne-lang.blogspot.com
Oracle DBA: Many faces of an Oracle data block
http://wayne-lang.blogspot.com/2011/03/many-faces-of-oracle-data-block.html
Diary from a DBA deals with Oracle technology. Saturday, March 12, 2011. Many faces of an Oracle data block. There are all kinds of data block in Oracle database, such as table segment block, index data block, undo segment block, or data file head block, to name a few. Let’s just talk about the table data block for now. Subscribe to: Post Comments (Atom). Many faces of an Oracle data block. View my complete profile. Spacewalk : My First Steps in Space. Kevin Closson's Oracle Blog. The Arup Nanda Blog.
wayne-lang.blogspot.com
Oracle DBA: MySQL replication
http://wayne-lang.blogspot.com/2012/01/mysql-replication.html
Diary from a DBA deals with Oracle technology. Friday, January 27, 2012. MySQL replication is easy to setup but very basic comparing to the Oracle replication. But my biggest complaint is that it allows user to setup Master-to-Master replication. Because MySQL replication is asynchronous, The ACID. Property of modern relational database is down to the drain with the MySQL Master-to-Master replication. The correct way for MySQL Master-to-Master is MySQL cluster setup. Subscribe to: Post Comments (Atom).
wayne-lang.blogspot.com
Oracle DBA: July 2011
http://wayne-lang.blogspot.com/2011_07_01_archive.html
Diary from a DBA deals with Oracle technology. Friday, July 29, 2011. RMAN backup test without downtime. Option 1: RMAN validate:. RMAN can validate the database restore at database level, backupset level, datafile level, and data block level. The RMAN validate checks the RMAN backup file is accessible and no physical and/or logical corruption. The following RMAN commands are used to perform validation. 8226; VALIDATE …. 8226; BACKUP . VALIDATE. 8226; RESTORE . VALIDATE. Option2: Restore to new location.
wayne-lang.blogspot.com
Oracle DBA: September 2011
http://wayne-lang.blogspot.com/2011_09_01_archive.html
Diary from a DBA deals with Oracle technology. Monday, September 5, 2011. This blog is about Oracle table compression. As we know Oracle offers table compression basic and table compression advanced. Let us compare them. Basic compression is included with Oracle EE license. Advanced compression is $11,500 per CPU. Assume 2x compression ratio, you need 22 TB database before the compression to justify the cost of license for advanced table compression with a one CPU server. Calculate the compression ratio:.
wayne-lang.blogspot.com
Oracle DBA: RMAN backup test without downtime
http://wayne-lang.blogspot.com/2011/07/rman-backup-test-without-downtime.html
Diary from a DBA deals with Oracle technology. Friday, July 29, 2011. RMAN backup test without downtime. Option 1: RMAN validate:. RMAN can validate the database restore at database level, backupset level, datafile level, and data block level. The RMAN validate checks the RMAN backup file is accessible and no physical and/or logical corruption. The following RMAN commands are used to perform validation. 8226; VALIDATE …. 8226; BACKUP . VALIDATE. 8226; RESTORE . VALIDATE. Option2: Restore to new location.
wayne-lang.blogspot.com
Oracle DBA: Oracle Goldengate
http://wayne-lang.blogspot.com/2012/01/i-always-laugh-at-oracles-sale-pitch.html
Diary from a DBA deals with Oracle technology. Friday, January 27, 2012. I always laugh at Oracle’s sale pitch for Oracle Goldengate. The conversation is like this:. We need to implement an ETL process …. Oracle Goldengate is just for that. We need a long distance disaster recovery solution …. Oracle Goldengate is great for it. We have RAC but facing downtime for no rolling patching …. Oracle Goldengate is a must. We need to pull data from other database vendor’s databases for real time BI ….
wayne-lang.blogspot.com
Oracle DBA: Change Database name
http://wayne-lang.blogspot.com/2012/01/change-database-name.html
Diary from a DBA deals with Oracle technology. Friday, January 27, 2012. We all know how to change the database name by recreating the control file. However, I consider this is a risky operation especially if you have a large database that takes many hours to recover. Start with Oracle 10g, we can use a new tool called nid. To do the same thing without do resetlogs operation, plus the DB ID is not changed. DBNEWID: Release 11.2.0.1.0 - Production on Wed Jan 25 10:43:08 2012. Control Files in database:.