Below are the steps for renaming an ASM diskgroup with database files present inside for a running database. EXAMPLE: In this article we will rename the diskgroup +DATATST to +NEWTST. The database present inside the diskgroup is TESTDB2 . 1. Check configuration of the database: srvctl config database -d TESTDB2 srvctl config database -d […]
Category: ORACLE 11G
Steps for Copy ASM File From One Server To Another Server
In the world of Technology, we all know COPY and PASTE how much helpful for making any business operations. But in the field of Database, it is not same as in another area. Some different steps we have to use. Let’s have look on those steps which we use for Copy ASM File From One Server To Another Server. Copying file between […]
Move Datafile From File System To ASM Disk In 11g
Today, we are going to learn about those steps which use to move Datafile from file system to ASM disk in Oracle 11g.Being an Oracle DBA we have deep knowledge of Datafiles. We know there importance of Datafiles in the database. Somes lines explain about the technical definition. A data file is a file that is […]
Recover from a loss of the SYSTEM tablespace on different location
This post is about the steps used for recover as from a loss of the SYSTEM tablespace on a different location. As DBA we all are aware of system tablespace that it always contains the data dictionary tables for the entire database. In particular, this example will restore the lost tablespace to another location, just […]
Oracle 11g Architecture Diagram with Explanation
Oracle 11g Architecture Diagram with Explanation. In below flash video, you can get all Dynamics Views, Background Components and Background Processes. For Flash Video: 11g Interactive in Flash To Download in PDF : 11g Architecture in PDF Soon I will upload for Oracle 12c also. Cheers !!!!
Different ways to find spfile location in Oracle RAC
1. By using SqlPlus $ sqlplus / as sysasm SQL> show parameter spfile NAME TYPE VALUE —— —— ————————————————- spfile string +DATA/ASM/ASMPARAMETERFILE/registry.253.822856169 SQL> 2. By using ASMCMD find command $ asmcmd find –type ASMPARAMETERFILE +DATA “*” +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 3. By using spget command ASMCMD> spget +DATA/ASM/ASMPARAMETERFILE/REGISTRY.253.822856169 […]
Installing Oracle Statspack
I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: – This article is about Oracle Statspack. We are going to learn what is Oracle Statspack? how does it work, why do we need of Oracle Statspack? Statspack is a performance tuning tool provided by Oracle with the Oracle9i database distribution. […]
Archive Redo log
As DBA We all know backups play an important role in business operations but in some case backup also get corporate than we can not make database alive. To solve this kind of issue Oracle recommends us to keep a database in archive log mode. To preserve redo information, create archived copies of redo log files […]
ORA-01031: insufficient privileges(Add) user in group
In this article we are going to learn about the privileges . The ORA-01031: “insufficient privileges” error occurs when you attempt to execute a program or function for which you have not been granted the appropriate privileges. For the DBA, the ORA-01031 can happen if the target OS executable do not have read and execute permissions (e.g. […]
Scenario 1 – Recover a Member of a Multiplexed Online Redo Log Group
Please follow the below steps. Steps : 1. Shutdown immediate; 2. Physically remove redo log member(no redo log group) by using OS level command. 3. Startup; 4. SELECT GROUP#, STATUS, MEMBER FROM v$LOGFILE WHERE STATUS=’INVALID’; 5. Check alert log file. Steps for Recovery : 1. Drop the damaged member ALTER DATABASE DROP LOGFILE MEMBER ‘D:\app\admin\oradata\orcl\REDO01.LOG’; […]