Blog Archives

How to take Data Pump Backup from a remote database

Oracle Data Pump is a new and unique feature of Oracle Database 11g Release 2. A new public interface package, DBMS_DATAPUMP, provides a server-side infrastructure for fast data and metadata movement between Oracle databases. It is ideal for large databases

Posted in Backup and Restore, DBA

A basic RMAN Backup

Hi I am discussing here basic RMAN backup and the example shows the easiest way to complete RMAN backup. Go to command prompt and type rman target / Now you are in RMAN prompt. Execute show all to view the

Tagged with:
Posted in Backup and Restore

how to make database archiving log mode

At first set the archiving log destination as follows: > alter system set log_archive_dest=’E:\archive’ scope=spfile; Then restart the database to make it effective and see spfile about the changes. To make the database in archiving mode follow the steps below

Posted in Backup and Restore