RMAN Backup With Archivelog

RMAN plays an important role n Oracle RDBMS. Let’s have look on the steps are used by Oracle during the “RMAN Backup With Archivelog” RMAN> run { allocate channel c1 type disk; backup database; backup(archivelog all); } RMAN> backup archivelog all delete input; Note: This will backup all archivelog file and delete those from target location. If […]

Read More

ASMCMD-8102: no connection to ASM; command requires ASM to run

Let’s have a look on the steps which we use to resolve the issue “ASMCMD-8102: no connection to ASM; command requires ASM to run”. [grid@oraclehelpdb1 ~]$ asmcmd Connected to an idle instance. ASMCMD> ls ASMCMD-8102: no connection to ASM; command requires ASM to run Solution: [grid@oraclehelpdb1 ~]$ export ORACLE_HOME=/opt/grid/product/11.2.0.3/ [grid@oraclehelpdb1 ~]$ export PATH=/opt/grid/product/11.2.0.3/bin/ [grid@oraclehelpdb1 ~]$ […]

Read More

Recovery Scenario of Database

Here we will simulate recovery scenario of database.First we will create crash situation and then we will try to recover from that. Check backup is available for your database Now connect your pluggable database Create one tablespace in pluggable database . Create one user and grant quota on this tablespace to that user. Now lets […]

Read More

Creating a Backup Schedule

Being a DBA it is your key responsibility to set a proper backup strategy. Today we will see how we can schedule backup : Step 1 : Create script to take backup , Here I have created linux shell script Check above backup script , I have used quite a few RMAN parameters to make […]

Read More

Set TIME and DATE Format in RMAN

To simulate , I took fresh RMAN backup using following command. Step 2 : Check backup using list backup command . Let’s add some parameter to set time format in RMAN. Add following parameter in your .bash_profile which resides in home directory of oracle user. Now , run .bash_profile file to give effect Now , […]

Read More

Restore Encrypted Backup

Here we will see how we can password based encrypted backup. I am taking a fresh backup using password based encryption. To know more about password based encryption of RMAN go through following article http://oracle-help.com/backup-and-recovery/password-based-encryption-in-rman-backup/ Step 1 : Take encrypted backup using following command in RMAN Note : I gave “orarmanbkp” password for encryption. Check […]

Read More

Recover Password File

Password file in the Oracle database is must to login remotely for sysdba privileges. Oracle creates password file automatically while creating database using DBCA by asking us what password to set for sys and system users. Here we will see how we can recover from the situation when we lost our password file. It can […]

Read More

How Select Statement Works

When Oracle receives a sql query, it requires to run some pre-tasks before actually being able to really run the query. Combination of these tasks is called parsing. During parsing the below operations used to perform. Database validate the syntax of the statement whether the query is valid or not.For example, the following statement fails […]

Read More

Use of Basic RMAN commands

RMAN : RMAN is an Oracle Database client and every DBA’s favorite tool for backup and recovery of the database. We have many RMAN related posts which can help you in all scenarios . However, today we will see a basic RMAN commands that will show what RMAN offers you. This post is mainly for […]

Read More