We take complete physical backup of database by copying physical database files including datafiles, control files, password file and parameter file. Backup can be online backup or offline backup. In online backup, our database is in open stage and datafiles have different SCN. Continue reading Archivelog mode concepts | Oracle Hot backup and cold backup
Often database developers require temporary storage location which is private to session. To accomplish this requirement, Oracle database allows us to create Temporary tables. Temporary tables are of two types Continue reading Oracle Temporary Table
When a query tries to modify database, original data entries are kept in separate location and then changes are applied to datafiles. The data which is kept in separate location is called Undo data. Undo data is used to maintain data integrity and data consistency. Oracle uses Undo data in following situations Continue reading Undo Management and Undo Tablespace | Undo Retention
Following section explains how we can take full database backup using RMAN command line interface on windows.
Before tacking backup, decide which type of backup you want to take. You can take online or offline backup using RMAN. Continue reading RMAN script to take full database backup
Recovery Manager (RMAN) is client/server utility provided by oracle to perform backup and recovery operations on oracle database. RMAN is available in command-line interface as well as in Enterprise manager GUI. RMAN is part of oracle database and does not require separate installation or configuration. Continue reading Oracle RMAN
Suppose we have a text file named “emp.data”. This text files contains employees data in following format,
1, Michle , clerk
2, king , manager
3, joe , clerk
What if we want to use this data in SQL query? Remember we do not want to import this data in oracle database but we want to reference this data from its physical location. To achieve this oracle database has provided a feature called External Tables. Using this feature, we can register “emp.dat” file in oracle database as external table. Continue reading Oracle External Table