Create databases of any size and complexity in a completely visual way. SlyDB generates databases complete with all necessary forms, fields, formulas, multimedia features and interactive behavior.

Oracle Database 11g now offers a way to quickly identify users with default passwords.

A consistent backup of the database is one taken when the database is in a consistent state, that is, one taken after the database has been shut down normally (using SHUTDOWN NORMAL, SHUTDOWN IMMEDIATE or SHUTDOWN TRANSACTIONAL).

Archived redo logs are the key to successful media recovery. Back them up regularly. You can back up logs with BACKUP ARCHIVELOG, or back up logs while backing up datafiles and control files by specifying BACKUP ... PLUS ARCHIVELOG.

There are three distinct options available for an installer of an Oracle database. Those available storage options for database files are File Systems, Oracle’s Automatic Storage Management (ASM), or Raw Devices.

A complete high availability and disaster recovery strategy requires dependable data backup, restore, and recovery procedures. Oracle Recovery Manager (RMAN), a command-line and Enterprise Manager-based tool, is the Oracle-preferred method for efficiently backing up and recovering your Oracle database.

A user deletes data from a table and commits it. How do you retrieve that data? If using a version of Oracle with flashback technology AND you are made aware of the error while the undo information is still retained that’s not so much of a problem.

You can use the RMAN DUPLICATE command to create a duplicate database from backups of the target database (primary database) while retaining the original target database.

you execute a SQL statement in parallel, then the default behavior is for Oracle to run the parallel processes only on the instances that offer the service that you used to connect to the database.

Oracle RAC systems provide two methods of failover to provide reliable access to data:Connection failover and Transparent Application Failover

Install Oracle Clusterware and Oracle Database software using Oracle Universal Installer (OUI), and create your database with Database Configuration Assistant (DBCA). This ensures that your Oracle RAC environment has the optimal network configuration, database structure, and parameter settings for the environment that you selected.

Backing up all or part of your database is accomplished by using the BACKUP command from within the RMAN client.RMAN uses the configured settings and channels for your database, the record of previous backups in the RMAN repository and the control file's record of the structure of your database to determine an efficient set of specific steps to perform in response to a BACKUP command, and then carries out those steps.

The latest version of SQL Server is Microsoft SQL Server 2005, this was released on 7th November 2005, at the time of writing this article I do not know of many organisations that are utilising SQL Server 2005 in a production environment but many organisations that utilise Microsoft SQL Server as a database solution have SQL Server 2005 setup in a test environment and have plans to migrate their production environments to this latest version in the future.

Oracle RAC extends Oracle Database so that you can store, update, and efficiently retrieve data from multiple instances on different servers at the same time. Oracle RAC provides the software that allows the servers to work together in what is called a cluster.

This article is aimed to help DBAs to assess their current level of risk, and then provide practical, applicable knowledge to appropriately secure the Oracle database. This article is designed to help you establish a practical security program for Oracle databases. We will create a means for measuring and assessing the security of your databases, and give you tools to create a security scorecard for each of your Oracle databases.