Blog Aggregator - Amardeep Sidhu

Oracle University has confirmed two 11g New Features courses just last week:
So I will definitely deliver five days of Oracle 11g New Features for Adminstrators in:
Brussels October 15th. -19th
Istanbul October 22nd. - 26th.
Looking forward to seeing you there!
=;-)

This week I am delivering RAC 10g for CERN  
I am teaching a group of 16 DBAs
who are responsible for the Oracle clusters @ CERN.
The training takes place at the in the
  World Trade Center in Geneva
where Oracle Education still has some facilities.
At the end of the course Philipe,
 one of these hackers surprised me with
SIX different kinds […]

Yesterday I was invited into the IT department @ CERN. 
A bunch of DBAs showed me the data center where the clusters including the tape libraries for the experiments are hosted.
This was really impressing.
I have taken a few pictures there, enjoy the slide show!
=;-)

Following my last post, here is some more feedback on our Peoplesoft world.

As I mentioned before, we’re in the middle of a major rollout of new functionality on our payroll systems. Mostly to do with finally letting folks access their own information as well as letting managers preview and better plan for annual and other leave, reviews, promotions, new employees, etcetc.

In simple words:

Doug Burns has started an interesting blog thread about the Oracle Database 11g PARALLEL_IO_CAP_ENABLED parameter in his blog entry about Parallel Query and Oracle Database 11g. Doug is discussing Oracle’s new concept of built-in I/O subsystem calibration-a concept aimed at more auto-tuning database instances. The idea is that Oracle is trying to make PQ more […]

There is a new book on RMAN by
Sam R. Alapati, Darl Kuhn, Arup Nanda.
It is titeled RMAN RECIPES and is published by APRESS.
 These authors have already proven their expert competency by publishing a lot of highly interesting white papers in OTN and other books in the past. (Just search for their names in OTN!).
Here are the […]

I’ve never seen that one before. I don’t do the Google AdSense thing so it looks like those two retailers got a freebie. What do I get?
NOTE: You may have to right click-> view to get a good look.

You wanna create an Oracle Dataguard configuration working in Maximum availability. This configuration uses of course standby redo log files. These files must be available on the primary and standby side (because of switchover : primary database becomes standby database). In your setup process you decided to create the standy redo log files before duplicating the primary database. After the creation of the Dataguard configuration, the standby database seems to miss the standby redo log  files.

RFS[3]: No standby redo logfiles created
RFS[3]: Archived Log: '/u00/app/oracle/admin/DG/arch/DG_1_86_599565590.arc'

Below the description of the problem and the solution.

First of all you create the standby redo log files on the primary database :

alter database add standby logfile group 4
('/u00/oradata/DG/sredog4m1DG.dbf',
 '/u01/oradata/DG/sredog4m2DG.dbf') SIZE 6M reuse;
alter database add standby logfile group 5
('/u00/oradata/DG/sredog5m1DG.dbf',
 '/u01/oradata/DG/sredog5m2DG.dbf') SIZE 6M reuse;
alter database add standby logfile group 6
('/u00/oradata/DG/sredog6m1DG.dbf',
 '/u01/oradata/DG/sredog6m2DG.dbf') SIZE 6M reuse;
alter database add standby logfile group 7
('/u00/oradata/DG/sredog7m1DG.dbf',
 '/u01/oradata/DG/sredog7m2DG.dbf') SIZE 6M reuse;

Backup your primary database for standby with RMAN :

Start (nomount) the standby side :

SQL> startup nomount;
ORACLE instance started.

From the primary server, start RMAN to duplicate for standby :

RMAN> connect target /
connect connected to target database: DG (DBID=1512896598)

After the duplicate verify the status on the standby database :

The standby redo log files have been correctly duplicated, but the files are NOT created on the filesystem.

Now you can create your dataguard configuration with dgmgrl from the primary side :

connect sys/manager

On the standby side , following occured (extract of the alert.log file of the standby database) :

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE  THROUGH ALL SWITCHOVER DISCONNECT  NODELAY
Sun Sep 23 14:52:54 2007
Redo Shipping Client Connected as PUBLIC
– Connected User is Valid
RFS[3]: Assigned to RFS process 7535
RFS[3]: Identified database type as 'physical standby'
RFS[3]: No standby redo logfiles created
RFS[3]: Archived Log: '/u00/app/oracle/admin/DG/arch/DG_1_85_599565590.arc'
Sun Sep 23 14:52:55 2007
Media Recovery Log /u00/app/oracle/admin/DG/arch/DG_1_85_599565590.arc
Media Recovery Waiting for thread 1 sequence 86
Sun Sep 23 14:54:39 2007
RFS[3]: No standby redo logfiles created
RFS[3]: Archived Log: '/u00/app/oracle/admin/DG/arch/DG_1_86_599565590.arc'
RFS[3]: No standby redo logfiles created
RFS[3]: Archived Log: '/u00/app/oracle/admin/DG/arch/DG_1_87_599565590.arc'
Sun Sep 23 14:54:40 2007
Media Recovery Log /u00/app/oracle/admin/DG/arch/DG_1_86_599565590.arc
Media Recovery Log /u00/app/oracle/admin/DG/arch/DG_1_87_599565590.arc

After having enabled the Dataguard configuration, the standby redo log disappeared :

SQL> select group# from v$standby_log;

The standby database complains in the alert.log file :

The solution is easy, stop the log apply mode and create the standby redo log files on the standby database :

On the primary database (in dgmgrl) :

On standby side (see the script above) :

On the primary database (in dgmgrl) acivate the standby site again :

To verify, in sqlplus on the primary side :

System altered.

On the standby side , the database doesn't complain anymore and uses the standby redo log files :

Note also that even if the mode is still Maximum Performance and the transport mode ARCH, the standby redo log files will be used to store the archived files from the primary.

Not much to blog about. No, actually, I have an Olympic-sized swimming pool full of things to blog about, but I can’t. No time.
Since I’m working on a future Oracle product I’ve got RASUI on my mind. I thought this video seemed appropriate.
Polls Are Useless Without Critical Mass
Have all you readers participated in my (yet […]

There was a question at the OTN Database-General forum today about a problem when trying to describe the view dba_tablespaces.

The poster was getting an ORA-04043 error.

SQL> desc dba_tablespaces
ERROR:
ORA-04043: object dba_tablespaces does not exist

The first thing I thought about this was that the instance might have been in mount mode. I tried it on a database in mount stage and I got the