Backup & Recovery
Oracle Flashback
Oracle flashback allows you to move database back in time. You can use flashback technology to move entire database or a particular table...
Oracle RMAN Administration
We will be looking at various ways in which we can use Oracle RMAN utility and configure different options available for a DBA. Configure...
Oracle Database Cold Backup & Recovery
Oracle Cold Database backup is rarely used these days. DBAs hardly take cold database backup but sometimes it is important to take one...
RMAN Single Datafile Recovery
In this article we will be looking at how to recover a single datafile attached to a tablespace using RMAN. We will be creating a test...
RMAN Point-In-Time-Recovery PITR
RMAN PITR allows you to specify a SCN number or a recovery time till when you want to recovery database. The PITR is used when you want...
RMAN DB Full Backup & Recovery
In this article we will be looking at RMAN incremental backup & how to perform database recovery using incremental backup. Take RMAN DB...
RMAN Incremental Backup & Recovery
In this article we will be looking at RMAN incremental backup & how to perform database recovery using incremental backup. Take RMAN...
RMAN in Data Guard Configuration
RMAN in Oracle Data Guard configuration works very normal like single standalone database. But, there are few important things you should...
Schedule RMAN Backup on Windows
Scheduling RMAN backups on a windows machine is little different than Linux machine. Windows uses bash shell and windows scheduler to...
Automate RMAN Backups via Catalog Scripts
You can take advantage of RMAN catalog scripts to automate RMAN backups on target databases. However, the biggest disadvantage is when...
RMAN Backups in RAC
All backups by default go to FRA disk group in RAC. Take RMAN backup to custom location in Oracle RAC RMAN> backup as compressed...