For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files). Specify EXTERNAL REDUNDANCY if you do not want mirroring by Oracle ASM. For example, you might choose EXTERNAL REDUNDANCY to use storage array protection features. Various…
Category: Administration
Data Guard Protection Modes in Oracle
In some situations, a business cannot afford to lose data. In other situations, the availability of the database may be more important than the loss of data. Some applications require maximum database performance and can tolerate some small amount of data loss. The following descriptions summarize the three distinct modes of data protection. Maximum availability…
Manual Install Enterprise Manager in Oracle
If you did not install Enterprise Manager, you could install manually DbConsole (Enterprise Manager). You have to execute below commands. If dbsnmp user is locked, you have to do unlock this user. Because dbsnmp user will use for EM installation. Install EM Open Command Prompt set ORACLE_HOME=c:\path\to\oracle\home set ORACLE_SID=DB_SID emca.bat -config dbcontrol db Note :…
RMAN List Command in Oracle
RMAN List Command queries can use for the historical information on the backups. The various options you can use with List command and their uses are discussed below. List Commands Examples RMAN> LIST ARCHIVELOG ALL; RMAN> LIST BACKUP OF ARCHIVELOG ALL; RMAN> LIST BACKUP; RMAN> LIST BACKUP OF DATABASE; RMAN> LIST BACKUP OF DATAFILE 1;…
Show First and Last Value of Data in Oracle
You can show first and last value of data which changes with update. Also you can show all values. Example Select versions_starttime, versions_endtime, salary from employees versions between scn minvalue and maxvalue where last_name=’King’;
Constraint Deferrable Types in Oracle
Constraints’s check time depend on deferrable parameters. If the parameter is set immediate, check time of your query is before the transaction is commit. Also, query will check when you execute query. If the parameter is set deferred, query will check when the transaction is commit; Deferrable initially immediate Deferrable initially deferred
Ocr Voting Disk in Oracle
Oracle Clusterware 10g, formerly known as Cluster Ready Services (CRS) is software that when installed on servers running the same operating system, enables the servers to be bound together to operate and function as a single server or cluster. This infrastructure simplifies the requirement for an Oracle Real Application Clusters (RAC) database by providing cluster…
Install Oracle 10g RAC on Windows Server 2003 x64 on VMware
I will explain how to install Oracle RAC 10g on Windows Server 2003 x64 Edition. I will tell installation step by step. You can find here for wide explain of that installation. 1 – VMware Configuration Add New Bridge Network. Add New Virtual Disks That 1 GB OCR, 1 GB Voting, 30 GB DATA, 30…
RAID (Redundant Array of Independent Disks)
RAID (redundant array of independent disks; originally redundant array of inexpensive disks) is a way of storing the same data in different places (thus, redundantly) on multiple hard disks. By placing data on multiple disks, I/O operations can overlap in a balanced way, improving performance. Since multiple disks increases the mean time between failures, storing…
Create Trigger in Oracle
A database trigger is a stored procedure that automatically executes whenever an event occurs. The event may be insert-delete-update operations. For example, Oracle initiates an ‘AFTER INSERT’ trigger after an insert event has occurred or an ‘AFTER UPDATE’ trigger after an update event has occurred. You can write triggers that fire whenever one of the…