Find corrupted objects in Oracle using sql query

Find corrupted objects in Oracle using sql query : When you find block corruption in your database use validate database or validate check logical database command of RMAN, it will populate v$database_block_corruption view with corrupted blocks. Then you can check corrupted segments , its partition name and more details using following script.

   

Read More

Archive log delete input and delete all input

Archive log mode :  This mode created backup of all transactions that have occurred in the database , so that you can recover your database to any point in time. These logs consumes space in respective destination. To utilize storage , we can remove archive log with RMAN command delete input or delete all input […]

Read More

check os process id of your session from sql prompt.

 Check os process id of your session from sql prompt.

My session

 

Read More

Create Database using DBCA silent mode

DBCA is great tool to create database using GUI , but sometimes when we don’t have access to GUI, we can still create database using DBCA silent mode creation where you need to pass silent option with dbca and some parameter values to create database. In following example we have used template General_Purpose ,   […]

Read More

RMAN maxpiecesize command

Use of RMAN maxpiecesize command To avoid large size of backupset we can set maxpiecesize of rman backup piece. I have taken following backup without setting any parameter :

By list backup command we can see all details of backup , here we can see my backup set size is 1013.84M.

now configure […]

Read More

ORA-16179 incremental changes to “log_archive_dest_10” not allowed with SPFILE

You might encounter ORA-16179 error while changing the archive destination.

There is syntax error in above command . It should be like log_archive_dest_n [n is a integer from 1 to 31]=’LOCATION=path_for_archive_log’ example :

Thank you for giving your valuable time to read the above information. If you want to be updated with all […]

Read More

Difference between .bashrc and .bash_profile

Difference Between .bashrc and .bash_profile : We use .bashrc and .bash_profile frequently to set environment for Oracle. Here is the difference between both files ,which file is used when . location of .bashrc : /home/username/.bashrc location of .bash_profile : /home/oracle/.bash_profile .bashrc : This file is executed for non-login shells . .bash_profile : This file is executed […]

Read More

Flashback Technology

Flashback Technology in Oracle : Oracle Flashback Technology is a group of Oracle Database features that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery. Today we will see following feature of Flashback Technology : 1. Oracle Flashback Query . 2. Flashback […]

Read More

Clone Database using RMAN on Windows 10

Cloning Database with RMAN : A cloning database is useful for a variety of purposes, most of which involve testing. You can perform the following tasks to clone database: Prerequisites: You should have 2 servers , both server should have Oracle Software installed on them. Oracle Version : 11.2.0.4.0 OS : Windows 10 Database Name […]

Read More

How to use Catalog start with command

Recovery Manager(RMAN) is an Oracle Database client that performs backup  and recovery tasks on your databases and automates administration of your backup strategies. It greatly simplifies backing up,restoring and recovering database files. If you have backup files in non-FRA location  , you can catalog your backup using catalog start with command of RMAN. Note : […]

Read More