Tuesday, August 19, 2008

Duplicate in Oracle 10 to a remote server

One of my fellow DBA's ran into a problem when trying to get duplicate working for restoring the database to another server.
After we resolved the issue and learned the lesson that a simple mistake can lead to hours of rman frustration . I thought it would be interesting to document .

The problem

Duplicate development database to new development server.

Tool Used

Rman command line


AIX 5.3

After the DBA took the backup and had the backup NFS mounted on the system. He was unable to run duplicate on the new node. All auxialliary setup was complete and had seemed perfect.
An Rman catalog was used and Rman kept complaining that there were no backups to restore.

We tried a couple of things

remounted the NFS with the options rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,vers=3,timeo=600,actimeo=0

based on Note:424785.1 which we thought didnt work

Looked at Note:356199.1 and set event="10298 trace name context forever, level 32"

This didnt help either

The duplicate script was simple

connect target test/test@test
connect catalog abc/abc@abc
connect auxiliary aux/aux@aux
run {
duplicate target database to aux

The commands were being executed from the auxiliary server and network config was testedto be valid.

The Solution

The problem turned out to be that the dev database was changed to be an archivelog database and the archive logs were not backed up as part of the backup process. Rman kept generating an SCN that was in the archivelogs that it could not find in the catalog at all( I'm guessing since it was connected to the target it got the info from there).
As soon as the archive logs were backed up and made available the duplicate worked like a charm.

Moral of the Story : Rman needs less cryptic messages

Technorati Tags: , ,

Monday, August 18, 2008

My First Openworld

Well thanks to the folks at Oracle I get to go to my First Oracle Openworld. While i have had the opportunity to go to IOUG and Hotsos have never had the chance to make it to Openworld.
Here is a list of the sessions i plan to attend based on my initial run thru of the schedule builder. I'm still hoping to get into the exam cram on sunday and maybe find more sessions of value

Sunday, Sep 21
08:30-10:00Remove From ScheduleOracle Real Application Clusters Scalability Panel
10:00-11:30Remove From ScheduleOracle Security Risks
13:00-14:30Remove From ScheduleSecurity Roundtable
16:00-17:30Remove From ScheduleStorage: A New Paradigm for Databases (IOUG)
Keynote: James Carville and Mary Matalin
Monday, Sep 22
Oracle Keynote: Charles Phillips and Chuck Rozwat
11:30-12:30Remove From ScheduleApplication Diagnostics for DBAs: Visibility into Your Application That the Middle-Tier Administrator Cannot Provide You

13:00-14:00Remove From ScheduleImplementing Oracle Active Data Guard 11g as an Active Standby Database for Production Reporting
14:30-15:30Remove From SchedulePerformance Fundamentals for Oracle Database 10g and Oracle Database 11g
16:00-17:00Remove From ScheduleOracle Database Performance: A Comprehensive View Including Linux, Scalability, New Platforms, and Solid State
17:30-18:30Remove From ScheduleHow to Prevent SQL Injections
Tuesday, Sep 23
09:00-10:00Remove From ScheduleInside Oracle Database 11g Optimizer: Removing the Mystery
Executive Solution Session: Intelligently Communicate with Customers and Optimize Billing Operations
11:30-12:30Remove From ScheduleAdvanced Performance Diagnostics: What the GUI Doesn’t Tell You
13:00-14:00Remove From ScheduleOracle Active Data Guard: Standby on Steroids, Disaster Recovery Included
Keynote: Paul S. Ottelini, Intel and Thomas Kurian, Oracle
17:00-18:00Remove From ScheduleAnalyze Oracle Data Guard 11g to Improve Its Operation and Performance
Wednesday, Sep 24
08:00-09:00Remove From ScheduleMorning How-To Session: Top 10 Things to Do to Green Your Life and Save Money
09:00-10:00Remove From ScheduleOracle Advanced Compression: Throw Away Half of Your Disks, and Run Your Database Faster
11:30-12:30Remove From ScheduleEncrypt All Application Data: Oracle Database 11g Tablespace Encryption
13:00-14:00Remove From ScheduleSQL Tuning Roundtable with the Experts
Keynote: Larry Ellison, Oracle and Mark Hurd, HP
17:00-18:00Remove From ScheduleChange, Change, Change ...
Thursday, Sep 25
08:00-09:00Remove From ScheduleMorning How-To Session: Treading Lightly on the Planet--How to Reduce Your Carbon Footprint
09:00-10:00Remove From ScheduleAdvanced Oracle Troubleshooting: No Magic Is Needed--A Systematic Approach Will Do
10:30-11:30Remove From ScheduleOracle ACE Director Birds-of-a-Feather Tips and Techniques Panel
12:00-13:00Remove From ScheduleOffloading Work to Your Standby Database in Oracle Database 11g (IOUG)
13:30-14:30Remove From ScheduleReal-World Database Performance Roundtable
15:00-16:00Remove From ScheduleReorganizing Objects

Thursday, August 07, 2008

Dataguard 11g - No more same hardware/software requirement(partially)

While trying to look at dataguard as a reporting environment i found a very neat and fundamentally cost saving feature added on to dataguard in Oracle 11.
According to the Docs

"As of Oracle Database 11g, Data Guard provides increased flexibility for Data Guard configurations in which the primary and standby systems may have different CPU architectures, operating systems (for example, Windows & Linux), operating system binaries (32-bit/64-bit), and Oracle database binaries (32-bit/64-bit).

This is very interesting and actually provide a lot of cost savings to companies that have systems using Windows based servers and can purchase cheaper linux boxes and make that available . The problem is based on the matrix in note 413484.1 pretty much only Windows and Linux can live in a mixed environment . AIX and Solaris can only live with the same architecture.

Google Search