Category: SCRIPTS

RMAN: Basic RMAN Commands

Published February 19, 2014 By Brijesh Gogia

Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performant, manageable backup and recovery, for all Oracle data formats.

RMAN provides a common interface, via command line and Enterprise Manager, for backup tasks across different host operating systems.

Below are some of the commonly used RMAN commands which you can run through RMAN command line.

6 Comments

Frequently used SQL Queries for ASM

Published November 18, 2012 By Brijesh Gogia

Few frequently used SQL queries related to ASM : 1) Create Disk Group: Create Disk groups using the CREATE DISKGROUP statement and specify the level…

3 Comments

Automatic Storage Management (ASM) FAQ

Published November 17, 2012 By Brijesh Gogia

Few good questions on Automatic Storage Management (ASM) 11gR2: (Oracle ASM Interview questions) Q 1 Can an ASM file be contained in more than one disk groups…

4 Comments

User and responsibility Query

Published September 14, 2012 By Brijesh Gogia

Some useful scripts related to Oracle Apps (11i,R12) are listed. The list is updated regularly so keep coming back for updated version of this webpage.…

Adding new user in Oracle Apps (EBS) from back end

Published September 13, 2012 By Brijesh Gogia

Application users in Oracle Apps (EBS) can be created from the front end as well as back end. The back end method for user creation can be used when you don’t have sysadmin access to the applciation or also it can be used to speed up the process when there are many userids to be created.

You will require apps access to connect to database to run the package fnd_user_pkg.

5 Comments