Please visit www.oracle-class.com for Videos, Free posts, Books, Webinar and Free forum … ALL about Oracle!

May 21, 2011

11gR2 RAC – run ADDM report

Filed under: Uncategorized — orawiss @ 3:38 pm

Introduction:
From 11g, ADDM report is including RAC cluster analysis as a part of the overall ADDM database analysis process.
You can use the package DBMS_ADDM to run, analyze and get ADDM reports.
You can call the procedure analyze_db of the DBMS_ADDM package to analyze the RAC database, or you can use the procedure analyze_inst procedure to analyze a specific instance within the RAC. The procedure analyze_partial of the DBMS_ADDM package can be used to analyze a set of instances.

How to get an ADDM report of the overall database?
First, we will get the list of valid snapshots from the wrm$_snapshot view;
Read the complete article here: THE ARTICLE

Advertisements

April 22, 2011

11gR2 ASM – Inside story – Part5 (Read database file from OS)

Filed under: Uncategorized — orawiss @ 11:34 am

Introduction:
In the previous post of “11gR2 ASM – Inside story – Part4 (ASM Preferred Read Failure Group)”, we have seen how to configure the ASM instance with a list of preferred disk failure group names to use when accessing ASM disks.
In this section, we will see how to access to the database file managed within the ASM instance via OS command.
In this note, we will use the undocumented X$KFFXP table, which contains the physical allocation table for files managed via an ASM instance.

The demonstration:

In this demonstration, we will try to read the content of the spfile managed by the ASM instance, using the dd command.
First, we query the view V$ASM_FILE to get the diskgroup number and the file number. Then, we will get the disk number where the spfile is located (Query the view X$KFFXP). Once we get the disk numbers, we query the view v$asm_disk to get the OS path, where exactly the spfile is located,. In the end, using the OS command “dd”, we will read the 10 first lines of the spfile, starting from the offset 717M, which is the result shown in AU_KFFXP for the disk number 0.

Read the complete article here: http://wp.me/p1hlba-w5

March 11, 2011

11gR2 ASM – Inside story – Part4 (ASM Preferred Read Failure Group)

Filed under: Uncategorized — orawiss @ 11:34 pm

Introduction:
In the previous post of “11g ASM – Inside story – Part3″, we have seen how to to create a datapump dumpset within ASM diskgroup.
In this Part4 of the story, we will see how to configure the ASM instance with a list of preferred disk failure group names to use when accessing ASM disks.
This new 11g parameter is really useful especially for Real Application Clusters (RAC) instances on disks miles apart.
You can configure each instance to be able to read from the closest ASM disk.

Read the complete article here: oracle-class.com

11g ASM – Inside story – Part3 (Export Datapump)

Filed under: Uncategorized — orawiss @ 11:33 pm

Introduction
In the previous post of “11gR2 ASM – Inside story – Part2″, we have seen how to restore a diskgroup after a failure.
In this part 3, we will create datapump export dumpsets within ASM diskgroup.
The procedure is valid for 10g Oracle database,

We should follow the steps below:
1- Create a directory from ASM.
2- Create a directory object in the database.
3- Create log file directory. The datapump log file cannot be stored within ASM.
4- Run the datapump export.
5- Verify the file within the ASM diskgroup.
Read the complete article here: oracle-class.com

March 8, 2011

10g vs 11g add a column with not null default value

Filed under: Uncategorized — orawiss @ 12:31 pm

Introduction:
Prior to Oracle database 11g, adding a new column with a default NOT NULL value were a challenge. Especially, when the concerned table contains thousands or millions of records. Oracle 10g updates ALL the rows of the concerned table with the new default value. In my busy real time OLTP databases, I had to create another intermediate table with the same structure plus the new default not null column. This solution needs a switch to the second table and a rename table operation.
As you can Imagine, this solution takes time, resources, space, loads, locks.
Oracle database 11g offers a new quick, easy, instant solution; instead of updating ALL the rows of the table, Oracle 11g now updates the metadata only.

Read the complete article here: www.oracle-class.com

March 5, 2011

11gR2 ASM – Inside story – Part2 (Diskgroup restore)

Filed under: Uncategorized — orawiss @ 3:43 pm

Introduction
In the previous post of “11gR2 ASM – Inside story – Part1″, we have seen how to install grid infrastructure for standalone server and how to setup and configure an ASM instance.
In this Part2 of the story, we will see how to restore a diskgroup after a failure.

Read the complete article here: http://www.oracle-class.com/?p=1930

March 1, 2011

11gR2 ASM – Inside story – Part1 (including grid infrastructure installation)

Filed under: Uncategorized — orawiss @ 8:26 pm

Introduction:
This is a series of articles which contains several important enhancements to Automatic Storage Management in Oracle 11gR2.
In this part1, we are going to prepare, install our 11gR2 ASM environment.
In this ASM inside story articles, we are going to use Oracle Linux 5 as the guest operating system, Oracle 11gR2 as database version.
Oracle VirtualBox is our virtualization software.

Oracle Linux Installation
Download and install Oracle Linux.

Read the complete article here: http://www.oracle-class.com/?p=1908

February 25, 2011

11g Data Recovery Advisor DRA

Filed under: Uncategorized — orawiss @ 9:05 pm

The new 11g data recovery advisor (DRA) is a new diagnostic tool provided to identify, suggest and repair the database after a failure.
Types of failures can be a block corruption, loss of a datafile…. In general, media failure. You can access to the DRA using enterprise manager or RMAN tool.
In this quick demonstration, we are going to present some of the capabilities offered by this DRA tool.

First, we are going to use RMAN to backup our database. The database version is 11gR2.
read the complete article here: http://www.oracle-class.com/?p=1801

February 13, 2011

11g Oracle Flashback Data Archives

Filed under: 11G,administrador,oracle tips — orawiss @ 7:22 pm

Introduction
With Oracle 11g, Oracle have improved the Flashback technologies and now it’s a solid part of the recovery solutions Oracle provides.
Oracle flashback data archives provides the ability to track changes made on a table over its lifetime.
Now, You can stop using your logging scripts built on previous versions of Oracle, and start using the flashback data archives.The flashback data archives can also be used for data analysis and within a decision support system (DSS) environment.
In this article, we are going to setup the Oracle flashback data archives and then how it can be used.

Read the complete article here: http://www.oracle-class.com

February 3, 2011

Oracle Enterprise Manager Grid Control Installation 11g Release 1 (11.1.0.1.0) on fedora Linux 14

Filed under: Uncategorized — orawiss @ 9:13 pm

This article describes how you can install Enterprise Manager Grid Control using an existing, certified Oracle Database and Oracle Weblogic Server. In particular, this section covers the following:

1- Prerequisites
2- Java installation procedure
3- Weblogic Installation procedure
4- Apply patches using the Oracle Smart Update utility (if exists)
5- Oracle Enterprise Manager Grid Control Installation 11g Release 1 installation
6-Verify the installation

Read more about the article : click here!

Next Page »

Create a free website or blog at WordPress.com.