2013-09-05 13:28
LatchOracle SGA consists of numerous data structures such as Buffer Cache, Shared pool, Library cache, Dictionary cache, redo log buffer etc. Many oracle processes need to access these SGA d… Read More
Blog Directory > Software Blogs > Programming Blogs > Oracle Database Administration programming Blog >
2013-08-01 11:18
The segment shrink is done online. During shrink operation, the conventional DML operations can coexist but parallel DMLs cannot.During segment shrink, data will be moved as part of the comp… Read More
2011-02-10 11:46
Problem: I have lost some of the archivelog files without taking backup. If I run the rman to backup available archive logs, it throws error that the archivelog_seq# is not available.Solutio… Read More
2010-07-17 13:08
It has become easier to drop a database from Oracle 10g. Use the DROP DATABASE command to drop the database. It removes the datafiles, redologs, controlfiles and init parameter files.$ sqlpl… Read More
2010-03-02 11:12
RMAN Incremental Backups backup only the blocks that were changed since the lastest base incremental backups. But RMAN had to scan the whole database to find the changed blocks. Hence the in… Read More
2010-02-24 22:19
RMAN List Command queries the target control file or the recovery catalog for the historical information on the backups. The various options you can use with List command and their uses are… Read More
2010-02-24 19:46
The following are the commands you can type from the RMAN prompt.{allocatealterbackupbeginlineblockrecovercatalogchangeconnectcopycreatecrosscheckconfigureduplicatedebugdeletedropexitendinli… Read More
2010-02-09 22:41
Step 1: Set the following environment variablesORACLE_SIDORACLE_HOMENLS_DATE_FORMATStep 2: Access to privileged OS account or user with Sysdba privilege. Only users with Sysdba privilege can… Read More
2010-01-19 21:01
The password file is used to authenticate the users connecting to the database as Sysdba or Sysoper. The password file is created with the orapwd utility as follows,$ cd $ORACLE_HOME/dbs$ o… Read More
2010-01-08 13:36
The following V$views are used for managing ASM.View NameDescriptionInstanceV$ASM_DISKGROUPDiskgroups discovered by ASMDBV$ASM_DISKDisks discovered by ASM including disks that are not part o… Read More
2010-01-08 13:20
SyntaxALTER DISKGROUP diskgroup_name DROP FILE ‘filename’, ‘filename’..;Note: ASM drops all the aliases associated with the filename.Example 1SQL> Alter Diskgroup… Read More
2010-01-04 21:42
In order to use ASM filename aliases, you need to create Directories.Syntax:To add directoryALTER DISKGROUP diskgroup_name ADD DIRECTORY ‘filename’, ‘filename’..;To r… Read More
2010-01-04 21:41
Diskgroups are automatically mounted at ASM instance startup and dismounted at ASM instance shutdown. To manually mount and dismount the diskgroups use the following statements,Syntax:ALTER… Read More
2010-01-04 21:39
It checks the internal consistency of the diskgroup metadata. If any errors are found they are reported in the alert log.Instance: ASM InstancePrivilege: SysdbaSyntaxALTER DISKGROUP diskgrou… Read More
2010-01-04 21:37
Instance: ASM InstancePrivilege: SysdbaSyntaxALTER DISKGROUP diskgroup_name rebalance_diskgroup_clauseWhere,Rebalance_diskgroup_clause = REBALANCE POWER integer WAIT/NOWAITInteger – 0… Read More
2010-01-04 21:36
Note: Resizing disks in a diskgroup invokes implicit rebalancing of all the disks within the diskgroup.Instance: ASM InstancePrivilege: SysdbaSyntaxALTER DISKGROUP diskgroup_name RESIZE resi… Read More
2010-01-04 21:35
Note: To undrop a disk, the header_status from v$asm_disk view must be dropping. You cannot undrop a completely dropped disk.Instance: ASM InstancePrivilege: SysdbaSyntaxALTER DISKGROUP [ALL… Read More
2009-12-19 12:13
Note: Adding new disks to diskgroup invokes implicit rebalancing of all the disks within the diskgroup.Instance: ASM InstancePrivilege: SysdbaSyntaxALTER DISKGROUP diskgroup_name ADD [FAILGR… Read More
2009-12-19 10:46
Instance: ASM InstancePrivilege: SysdbaSyntax:DROP DISKGROUP diskgroup_name INCLUDING/EXCLUDING CONTENTS;Including Contents – Drops all the files associated with the disk group.Excludi… Read More
2009-12-19 10:20
Instance: ASM Instance.Privilege: SysdbaPre-requisite: Disks must be formatted. The path of the disk must be in the ASM_DISKSTRING. Oracle DB user must have read/write permission on the disk… Read More
2009-12-10 11:00
In this part we will see the ASM installation and ASM instance Creation.Step 1: Invoke the Oracle Universal Installer. In the Welcome Screen select Advanced Installation and click Next butto… Read More
2009-12-10 11:00
Hardware RequirementsRAM - 256MB Minimum. 512 MB RecommendedVirtual Memory - 512 MB to 1 GBDisk Space - 2.5 GB MinimumSoftware RequirementsSystem Architecture - Processor: Intel X86, AMD 64… Read More
2009-12-10 10:55
In the last part2 we discussed ASM installation. In this part we will see the RDBMS installation. Step 1: Invoke the OUI. Select the Advanced installation option and then click Next.Step 2:… Read More
2009-11-25 13:03
In this post I will provide you with some commonly used ASM commands and how to use it to perform some day to day activities.Before invoking the ASM command, set the following environmental… Read More
2009-11-06 11:43
ASMLIB is a storage management interface. ASMLIB is not required for ASM to function; it is an add-on library that simplifies the tasks of managing and discovering the disks.Function of ASML… Read More
Subscribe to Oracle Database Administration
Get updates delivered right to your inbox!