Failover Cluster System Benefits Protection at the instance level through redundancy Automatic failover in the event of a failure (hardware failures, operating system failures, application or service failures) Support for a broad array of storage solutions, including WSFC cluster disks (iSCSI, Fiber Channel, and so on) and server message block (SMB) file shares. Disaster recovery…
Category: Databases
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…
SQL Server 2012 Top 12 Features
Microsoft has introduced SQL Server 2012 to the world and it’s time for IT professionals to start to come to speed on what’s new in this highly anticipated version of SQL Server. 1. AlwaysOn Availability Groups — This feature takes database mirroring to a whole new level. With AlwaysOn, users will be able to fail…
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…