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 […]
Monthly Archives: May 2019
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 ~]$ […]
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 […]
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 […]
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 , […]
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 […]
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 […]
Steps to recover the standby database’s datafile using a backup of the primary database’s data file
Recently we have faced an issue for one of our data guard environment, we will discuss those steps here which we followed to fix this issue. For our Physical standby database, one of the filesystems (/u01/data/) got corrupted, due to which when we added datafiles in primary, the changes not applied on the standby and […]
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 […]
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 […]