An interesting situation with Standby database.

We have a data warehouse database sized more than 2TB using Oracle 9i on HP Superdom machine.

Couple of days back, I have come across of a very tricky situation with its standby database. Yes, you read it correctly. We have the standby database in place for the this database. For god sake, don’t argue with this as there are N number of reasons behind having a standby database for the data warehouse database.

The situation was that the mount point, which has all the standby database files, on standby database server became 100% full and the media recovery background process died/crashed (whatever you say) and archive applying was stopped. I went to the UNIX team and asked them increase the size of the mount point. They gave me a big surprise, saying that the mount point is already 2TB size and on HP Superdom the mount can’t exceed 2TB size. Therefore, increasing the size of the mount point was not possible.

After hearing their comments, I have initially thought that I can open the standby database in READ ONLY mode, move some datafiles to a new mount point in order to have some free space on this mount point. The idea doesn’t work as I was not able to open the database. Oracle was complaining about the media recovery when I tried to open the database in read only mode.

I was in a impression that this would be a dead end and I have ended of recreating the standby database again. Again a standby database which is more than 2TB…. Uffffssss

One of our UNIX admin guy gave me an idea. It was like moving few datafiles from the old location to the new location and creating the OS level link for the datafiles in the old location pointing to the new location.

I thought, I could try this and it worked beyond my imagination. I have shutdown the standby database, allowed him to move the datafiles (for him, it was like flat files) to new location and create the links for the files in the old location pointing to the new location.

I was bit worried while bringing the standby database up and starting media recovery process. The idea worked out and Oracle started applying archived logs on the standby database from the point where they were stopped.

I felt like in my career, every problem is a learning experience and give new ideas to deal with the situation.

That’s all now,

Happy reading,

Jaffar

V$ View Definitions Library - Metalink Note : 220021.1

Today, I have come across of a metalink note : 220021.1 that has all the v$ views with their defination.

The note put all the V$ views together at one place and moverover with their defination. Umm.. this could useful when you get everything at one place.

If you have not metalink aceess, well, Oracle documentation does has the same.


Visit Metalink Note : 220021.1

Happy Reading

Jaffar

Oracle Database Sql Expert beta exam

This morning I have attended the 1Z0-047 Database Sql Expert beta exam and expecting around 80% of it. The exam has 139 question with 3hrs of time. However, I have completed the exam just before the give time, i.e. within 2hr 45 minutes.

This was my first beta exam and I have felt that the duration of the exam is too long with plenty of . There were couple of questions with absolutely wrong choices(answers) and few of the questions were redundant.

But, the exam prepration has refreshed my sql basics once again and also helped me to learn new SQL aggregated function like, GROUPING, GROUPING_SETS, ROLLUP,CUBE, and other few new feature of SQL (WITH CLAUSE, Multitable Inserts, MERGE).

Well, I have to wait 2 or more months in order to receive the score sheet and ofcourse the result whether I am through or not.

In my opinion, this exam is more suitable for the Developer who are in touch with writing queries and upto date of sql funtion. Definately, a piece of cake for them with NO REALL CHALLENGES.

Happy reading,

Jaffar

Oracle ACE Director - Now includes Database and Development categories

Well, sometime back, Tim had discussed about the new look and feel of Oracle ACE page on the OTN and also about Oracle ACE Director Program at his blog http://www.oracle-base.com/blog/2007/07/23/oracle-ace-director/. His question was about the Oracle ACE Directors category and point out that none of the existing ACE Directors are nor Database neither Development community. All from Fusion Middleware community.

This morning I have noticed an email from the Oracle ACE Program team stating that the Oracle ACE Director is now opened for Database and Developers community as well.

“Not only will Oracle Fusion Middleware Regional Directors now be known as Oracle ACE Directors, but we have also opened it up to include Oracle Database performance/management and application development experts.”

What this means to you as an Oracle ACE
The Oracle ACE program will continue to be managed as it has been. The new benefit is that you may be eligible for the Oracle ACE Director level. Oracle ACE Directors are well known experts in their field and have committed to participating in a dialog with Oracle and their local technical community.

Well, its good to know that Oracle is considering critics, whether it is an open letter to Larry about the AWR licencing or including database and development categories for Oracle ACE Director program and taking quick actions.

Happy Reading,


Jaffar

Presenting RMAN 1 day seminar in Sweden and Denmark

I will be presenting one day seminar on RMAN basic and advanced concepts in Sweden and Denmark on 26th & 27th September respectively.

The course index is as follows:

Backup & Recovery Concepts

• What is backup and why backups are important?
• What is recovery?

Backups Methods

• Logical Backups (Export/Import and Data Pumps)
• Cold Backups Hot Backups (Consistent & Inconsistent Backups)

Recovery Manager (RMAN) Architecture & Concepts

• RMAN Introduction and Architecture
• Performing Backups using RMAN Recovery Catalog Maintenance

Different levels of Backups

• Mechanism of Incremental Backups
• Block Change Tracking Concepts

Flash Recovery Area (FRA)

• Introduction FRA Concepts and Benefits

Recover Database

• Recovering from different scenarios Instance/Crash Recovery
• Media Recovery
• Complete Recovery
• Incomplete Recovery

Block Recovery RMAN Advanced Topics

• Automatic Point-in-Time Recovery (TSPITR)
• Cloning Database
• Creating Standby Database/Rolling Upgrade
• Transportable Tablespaces from RMAN Backups Cross- Platform
• Transportable Tablespaces Cross Platform Database

Anyone wants to register for Denmark seminar, use the following url to register for the seminar.

http://www.oracle.com/education/emea_eblasts/local_campaign/dk/dk_syed_jaffar_hussain_1day_seminar_27_september_ballerup_120707_ol.html

Those who are in Sweden and willing to attend this seminar, can use the following url and register for the seminar.

http://education.oracle.com/pls/web_prod-plq-dad/show_desc.redirect?dc=D16314_955393&p_org_id=40&lang=S&source_call=

Since this is my ever first international seminar, I am bit nervous and at the same time excited about the opportunity.

Happy Reading,

Jaffar