Oracle Database File System creates a file system interface for files and directories stored in a database. When the file system is mounted programs can store and manipulate files that are held in the database […]
Using an Oracle Wallet with dbfs_client
You can use an Oracle Wallet to mount the file system using dbfs_client without having to enter a password. Using a wallet allows you to do the mount in the background in a more secure […]
Configure Flashback Database
As your database grows larger the length of time required to recover to a point in time grows. In some cases time required to restore all files to perform a point in time recovery becomes […]
Moving/Renaming Redo Log Files
It is possible to move/rename the online redo logs should the need arise. This document will detail the steps required to move/rename the online redo logs in an 11gR2 environment on Linux. These steps also […]
Moving/Renaming Datafiles While the Database is Online
It is possible to move and or rename datafiles while the database is online provided the tablespace in which the files belong is a non SYSTEM tablespace and does not contain any active ROLLBACK or […]
Moving/Renaming Control Files
It is possible to move/rename the database’s control files should the need arise. This document will detail the steps required to move/rename the control files in an 11gR2 environment on Linux. These steps also apply […]
Setting up RMAN for backup and recovery using Database Control
Using Database Control you can configure RMAN to back up you database to disk or tape with relative ease. This document will detail how to configure RMAN for disk based backups and perform a backup.
Enable/Disable Archive Log Mode 10g/11g using Database Control
Database Control makes a lot normal administrative tasks easier. You can enable and disable Archive Log Mode with a few mouse clicks as this document will detail. If you would like to do this through […]
Enable/Disable Archive Log Mode 10g/11g
Note: It is recommended to perform a backup of the database (after a shutdown normal or immediate) prior to changing the archive status of a database. If you would like to perform these tasks using […]
Database Control (dbconsole) will not start
A common problem with 10g and higher database is that Database Control fails to start after installation. This more common on desktop and laptop installs but the resolution is the same.
Database Startup and Shutdown through JDBC
Starting in 11gR1 you have the ability to stop and start the database through a JDBC connection.
Configure Static Service Information for a Database
The PMON process registers service information with the local listener by default. For most uses this is all that is needed to successfully connect to the database for use. If you are using a database […]
I just got/found an ORA-00600 after doing < X >. What should I do?
You have just been alerted that the database has encountered an ORA-00600, what should you do?