Scripts

How to Perform ORACLE_HOME Backup?

by

Backup of the Oracle home can be taken using any preferred method. You can use any tool such as zip, tar, and cpio to compress the Oracle home. It is highly recommended to take a backup of the Oracle_Home binaries and Central Inventory prior to applying patchsets or patches. It should also be done as … Read more

Profiles

by

A profile is a collection of attributes that apply to a user.The profile is used to enable a single point of reference for multiple users who share theseattributes.You should assign a profile to each user. Each user can have only one profile. Profile resource limits are enforced only when you enable resource limitation for the … Read more

How to Decide if column should be indexed?

by

Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine index will really help to perform query faster? Q. Which columns should be indexed in oracle? Q. How to identify index will give benefit to optimizer to generate better access path? Q. How do i … Read more

RMAN Basic Commands

by

Oracle Recovery Manager (RMAN) satisfies the most pressing demands of performance, 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. The RMAN command for making backups is Backup. The RMAN BACKUP command supports backing up the following types of … Read more

RAC Basic Commands

by

Check the status of the cluster Check the status of the services on the cluster Stop crs on all nodes (only one node up in this example) Stop crs on specifc node Disable CRS from starting on reboot Enable CRS to start on reboot Start crs on specific node Check database status Stop an instance … Read more

Oracle Dataguard Scripts

by

1) Information of database (Primary & Standby). 2) To display current status for Physical Standby Database background processes. 3) Check for messages/errors 4) Show received archived logs on physical standby 5) To check the log status 6) To display various information about the redo data. 7) Verify the last sequence# received and the last sequence# … Read more

Oratop Utility

by

Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time for RAC and Standalone DB. oratop utility can be downloaded from http://support.oracle.com/ This tool is only available on Linux platforms for Oracle 11.2 and higher, but can connect to Oracle instances running on other platforms. … Read more