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…
Tag: Database Administration
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
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…
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…
Delete Duplicate Rows Without All Records in Oracle
If you want to delete duplicate rows but not all rows in table, you can use a procedure. For example, you have 10 duplicate rows and you want to delete 9 rows, then you can use procedure to delete process. For instance, you have a table as tmp_table. tmp_table’s columns are id,name,surname,city,phone. You want to…
How to Take Export Backup in Oracle on Windows Servers
If you want to take export backup on windows servers, you can take with batch scripts and windows schedule tasks. You can create backup directory for this scripts and backups. We will use EXPORTDIR directory and below data, scripts, daily directories. You have to create three scripts file below scripts directory for this issue. Firstly,…
Schedule Backup in SQL Server 2008 Express Edition
If you use SQL Server Express, You can take schedule backup with sql script and windows task schedule. Firstly, you have to create backup script, after you have to create batch file for task schedule. Create Backup Script BACKUP DATABASE [dbname] TO DISK = N’D:\SQLBackup\dbname.bak’ WITH NOFORMAT, NOINIT, NAME = N’dbname-Full Database Backup’, SKIP, NOREWIND,…