With the flashback database feature, the hours-long restore-recover process can be completed in a few minutes. You can roll back and open your database …
Read More »dbtut
Database Mirroring On SQL Server
Microsoft has announced that it will remove Database Mirroring in the future because it has developed the Always On technology. But since SQL Server …
Read More »Restore Operations With rman
RMAN is a tool also recommended by Oracle for backup and recovery. There are many recovery scenarios. The main ones are: Recovering a database …
Read More »SQL Server Replication Types
Replication is one of the High Availability solutions. But it is not usually used as a High Availability solution. We would use SQL Server Always …
Read More »SQL Server Storage Concepts (Page, Extents, GAM, SGAM, PFS, IAM, BCM, DCM)
Page is the most basic unit of SQL Server on storage. Each page consists of 8 KB. The mdf or ndf files that allocate …
Read More »SQL Server Service Is Not Starting Due to Tempdb
SQL Server re-creates tempdb on predefined folders each time sql server service starts. In the article “How To Move The Tempdb Database To Another …
Read More »How To Delete an ASM Diskgroup
There are several methods to delete the disk group from an ASM. It is possible to do this operation with “Enterprise Manager”, asmca and …
Read More »Some Tips About ASM On Solaris
The partition of the disk to be allocated to ASM should not start from the 0th cylinder. You must start at least from the …
Read More »What is Mounted Drive and How to Create It
We use letters like C, D, E when defining disks on “Windows Server”. If the number of our disks increases, we may not be …
Read More »Correction of Corrupted UNDO tablespace.
If the Oracle UNDO table space is corrupted, it may be possible to get the error as follows. ORA-00376: file string cannot be read …
Read More »