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
Oracle instance consists of SGA and oracle processes. Oracle processes can be divided into server processes and background processes. Oracle database uses background processes to perform overall database operations, for example, database writer process writes dirty buffer from database buffer cache to datafiles. Continue reading Oracle PGA
If you have an older version of Developer 6i and try to connect to Database server 11g, connection fails with following error message
ORA-02248: invalid option for ALTER SESSION
To resolve this problem simply upgrade your Developer 6i release by Continue reading ORA-02248 error while connecting Developer 6i to Database 11g
In this post, you will learn how to recover a database using RMAN. To recover database, an RMAN backup is required. In last article, it was explained that how we can take backup using RMAN. Continue reading RMAN Recovery | Restore Controlfile