RMAN Differential Incremental Backups

December 11, 2009 at 10:15 am | In Advanced Implementation of EBS, Oracle DBA Tricks, Tips and Tricks | Leave a Comment
Tags: , , ,

Dear Readers,

There will be always a misconception about Incremental Backups of RMAN between level 0 and level 1. The level 0 backup is not a full database backup as it was understood widely. Level 0 backups can be incremental backups which backs up all changed blocks since the last level 0 backup. Level 1 backups are incremental backups either on top of level 0 or level 1 backups , level 1 backups can be differential or cumulative . when i say differential it means rman will backup only the changed blocks from last level1 backup or level 0 but when it is cumulative it backups the entire changed blocks since the last level 0 . The following picture explains the backup strategy for differential backup.

Differential level 1 RMAN Incremental Backups

The following command performs a level 1 differential incremental backup of the database:

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;

————
The following command performs a cumulative level 1 incremental backup of the database:

RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; # blocks changed since level 0

Your Comments and Queries are welcome.
–Vivek

Using Oracle Active DataGuard for Real Time Reporting

October 23, 2009 at 1:54 pm | In Advanced Implementation of EBS, Oracle DBA Tricks | Leave a Comment
Tags: , , ,

Dear Readers,

Its an interesting subject to discuss the above. can we use Oracle 11g Active DataGuard for Real time Reporting. Real time reporting -what i mean is the data should be always in sync with the primary(no longer time delays). Yes You can but only in Oracle 11g Active DataGuard.There will be a lot of confusion if you look at the terms.viz Active DataGuard, Snapshot standby etc., Active DataGuard is the new feature in 11g though which you can open the dataguard database in “read only ” mode when still it is recovering the data from primary.Previously in 10g and before versions,you can only open the dataguard in read only mode but your recovery will not happen in the background.If you use Active DataGuard in RealTime Apply Mode(RTA), then Yes you can use Active Guard for Real time Reporting,there will be no loss of data in the standby and it will be always in sync with the primary, no need to worry that what will happen if some thing wrong happened in primary, in 11g you have the flash back,so always you can flashback the data.And ofcourse to use ActiveDataGuard You need to buy separate license from Oracle apart from the Oracle Database License.It has some hindrances also ,you can not use right now active data guard for e-business suite since this is not certified,before deciding to go for active dataguard for realtime reporting you need to test whether it will work for your application

Your comments are most welcome
–Vivek

How To Install Siebel CRM (Siebel Business Applications) 8.0.0 in Windows 2003 Server

September 30, 2009 at 7:00 am | In Oracle Apps Tips and Tricks | 2 Comments
Tags: , ,

Dear Friends,
In this post I will discuss about how to install siebel crm(siebel business applications)8.0.0 in windows 2003 Server.
1.Download all the required zip files from http://edelivery.oracle.com
2.Make a Network Install Image using windows Image creator for the required application either sba or sia.
3.Install 2003 windows server and on top of that install service pack 2.
4.create a user in windows called sadmin with password sadmin with administrator priveleges.
5.Install IIS webserver in windows 2003 server.
6.Install Oracle database version 10.2.0.2
7.create siebel_data tablespace with 10gb space.
8.Install Siebel Gateway Server,Siebel Enterprise Server,Database configuration utilites and Management server
9.run database configuration utility against the oracle database you installed.
10. then install Siebel web server extension and apply the configuration
11.Now the installation is complete.
To access the application first time you need to install siebel web client (install it in the same server) and apply license.

then access the application with url like http://servername/calllcenter_enu. or http://servername/sales_enu or http://servername/marketing_enu or which ever module you have applied licenses.

Siebel Installation made easy :) .

Your comments are welcome.

– Vivek

How To find which HRMS Family Pack level in 11i Instance.?

August 26, 2009 at 9:43 am | In Oracle Apps Tips and Tricks | Leave a Comment
Tags: ,

Dear Readers,
Running the following query will tell you which family pack of HRMS you are on in 11i.

SELECT ‘HR_PF.’ ||
DECODE (BUG_NUMBER,’2115771′ ,’A(2115771)’,
‘2268451′ ,’B(2268451)’,
‘2502761′ ,’C(2502761)’,
‘2632500′ ,’D(2632500)’,
‘2803988′ ,’E(2803988)’,
‘2968701′ ,’F(2968701)’,
‘3116666′ ,’G(3116666)’,
‘3233333′ ,’H(3233333)’,
‘3127777′ ,’I(3127777)’,
‘3333633′ ,’J(3333633)’,
‘3500000′ ,’K(3500000)’,
‘5055050′ ,’K RUP1(5055050)’,
‘5337777′ ,’K RUP2(5337777)’,
‘6699770′ ,’K RUP3(6699770)’,
‘7666111′ ,’K RUP4(7666111)’) ||
‘ patchset is installed ‘ “HR Family Pack”,
to_char(last_update_date,’DD-MON-YYYY HH24:MI:SS’) “DATE APPLIED”
FROM AD_BUGS
WHERE BUG_NUMBER in (‘2115771′,’2268451′,’2502761′,’2632500′,’2803988′,
‘2968701′,’3116666′,’3233333′,’3127777′,’3333633′,’3500000′, ‘5055050′,
‘5337777′,’6699770′,’7666111′)
ORDER BY BUG_NUMBER DESC
/

– Vivek

what is maintenance wizard in R12 and why we should use it?

August 25, 2009 at 1:48 pm | In Oracle Apps Tips and Tricks | 1 Comment
Tags: , ,

Dear Readers,
Oracle Recently release Maintenance wizard.It is a usefull tool ,
through which we can record the timings of a test upgrade run or dry run upgrade,
or production upgrade .Since we record problems when its happened in the first run,
we can review it later to reduce the downtime.We can load certain sql scripts and
execute those from the maintenance wizard,even we can run shell scripts from
maintenance wizard and schedule it.

Your comments are welcome.
– Vivek

Recover the Applications context file if it is lost or deleted accidentally

August 24, 2009 at 2:00 pm | In Oracle Apps Tips and Tricks | 2 Comments
Tags: ,

Dear Readers,

To Recover xml file in applications R12 follow these instructions

The Applications context file can be retrieved by running the adclonectx.pl script.

To retrieve the applications tier context file,

Execute the following command on the applications tier.

perl /clone/bin/adclonectx.pl retrieve

select the option of retrieving the applications tier context file that has been lost and retrieve it to the default location specified by the script.
The above command can be used only when the is still intact.

In case the has also been lost accidentally, the applications tier context file may be retrieved as follows:
Execute the following command on the database tier:
perl /appsutil/clone/bin/adclonectx.pl retrieve
On being prompted for the context file to be retrieved, select the option of retrieving the applications tier context file that has been lost.

While confirming the location for the context file, set it to any existing directory with write permission.
Once the context file has been generated in the specified location, move it to the location specified for the context file in the context variable ’s_contextfile’.
To retrieve the database tier context file,

Execute the following command on the database tier:
perl /appsutil/clone/bin/adclonectx.pl retrieve
On being prompted for the context file to be retrieved, select the database tier context file and retrieve it to the default location specified by the script.

– Vivek R

Oracle Configuration Manager and R12 Upgrade

August 21, 2009 at 8:09 pm | In Oracle Apps Tips and Tricks | Leave a Comment
Tags: , , ,

Dear Readers,
In this post I am going to discuss about OCM. Oracle Configuration Manager Integrates with My Oracle Support (previously metalink) and uploads diagnostic details of the registered instances with oracle support so that the supporting analyst no need to ask too many questions about the environments and can do the troubleshooting to assist SR’s easily.
It has become mandatory that when you upgrade R12.0.x to 12.1.1 you need to conditionally upgrade the OCM to the latest version.OCM can be configured easily if you digg metalink a little bit and you should not install with runInstaller or setup.exe in R12 ,instead you should use autoconfig to install in EBS environments. also you should install it only in database and in IAS ORACLE_HOME’s and not in 8.0.6 or 10.1.2 ORACLE_HOME.whether it is a useful tool or not we need to know about this tool
since its an R12 conditional Upgrade Step.

Your comments are welcome.
– Vivek

Oracle Apps How to do Performance Tuning for Interfacing Programs

August 19, 2009 at 8:07 pm | In Oracle Apps Tips and Tricks | Leave a Comment
Tags: , , ,

Dear Readers,

Most of the times we face Performance issue in the customised concurrent programs,especially apps interface concurrent programs.Since oracle corp does not support customisation in apps ,its the job of the technical consultant and Apps DBA to tune these concurrent programs. Now the question comes as what we can do for concurrent programs and most of us will look into other aspects of tuning inspite of tuning the conc program itself. the best method is to enable the raw trace of such concurrent programs and do a tkprof on it and then according implement the recommendations.To enable the trace in the concurrent program do the following.Open the Define Concurrent Programs Forms and query that concurrent program and tick the checkbox “Enable Trace” and save it.Ensure that the database parameter TIMED STATISTICS is enabled.Now if you run the interface program then it will generate a raw trace in the udump location in the server.and do not forget to disable the Tracing after the trace file is generated.Mostly the bottleneck will be missing index in the interface tables or due to improper coding standards.

Your Questions/Comments are welcome.
– Vivek R

How to Integrate Oracle Apps with Other ERP(SAP,Siebel,JDEdwards)

August 13, 2009 at 4:54 pm | In Oracle Apps Tips and Tricks | Leave a Comment
Tags: , ,

Dear Readers,
In this post i will discuss about the AIA technology of Oracle .
Oracle Has released Integration Pack for most of the other ERP’s so that it can be integrated with Oracle Apps.
A good example is Siebel CRM PIP Integration Pack- which supports Order to Cash functional flow.In this CRM part i.e Orders Maintenance is done in Siebel CRM and Financial part is handled in Oracle Apps. To achieve this basically we need to apply the mandatory patches for oracle apps for AIA and then we need to install AIA(Application Integration Adapter) Foundation Pack and then SOA suite then on top it we need to apply the integration Pack and then configure the flow.Looks very simple but in real we should have the understanding of all the technologies.
Thanks
– Vivek

RapidClone for Mission Critical Apps Systems

August 11, 2009 at 7:28 pm | In Oracle Apps Tips and Tricks | Leave a Comment
Tags: , , ,

Dear followers,
In this post I am going to explain about cloning in mission critical environments.

Generally the Rapid Clone Procedure always talks about cloning with Cold Backups.
But question arises as how to clone mission critical apps environments.

Preclone procedure is the same for mission critical systems — as you can execute preclone when the system is online.
you can use the hotbackups either manual or by RMAN to restore the apps database.

after copying the db stack in the target system run adcfgclone.pl dbTechstack to
make the target dbms_oraclehome ok, then use the standard recovery procedures either manually or using RMAN
to recover the database.

You can very well copy the apps filesystem while the system is up as this will not cause any issues.
and you can finish the clone by running adcfgclone.pl appsTier.

So It is always possible to clone mission critical environments with hotbackup and RMAN backups.

Your comments are welcome.
– Vivek R

Next Page »

Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.