If you use Oracle Data Guard, you have to check timeliness status every time. The below query will give to timeliness status. The differences between results have to be 1-2 when you use real time apply Data Guard. Otherwise, your Data Guard is not real time and has a problem. Timeliness Status Query SQL> SELECT…
Category: Backup And Recovery
RMAN List Command in Oracle
RMAN List Command queries can use for the historical information on the backups. The various options you can use with List command and their uses are discussed below. List Commands Examples RMAN> LIST ARCHIVELOG ALL; RMAN> LIST BACKUP OF ARCHIVELOG ALL; RMAN> LIST BACKUP; RMAN> LIST BACKUP OF DATABASE; RMAN> LIST BACKUP OF DATAFILE 1;…
How to Take Export Backup in Oracle on Windows Servers
If you want to take export backup on windows servers, you can take with batch scripts and windows schedule tasks. You can create backup directory for this scripts and backups. We will use EXPORTDIR directory and below data, scripts, daily directories. You have to create three scripts file below scripts directory for this issue. Firstly,…
Export and Import Data in Oracle
Oracle’s export (exp) and import (imp) utilities are used to perform logical database backup and recovery. When exporting, database objects are dumped to a binary file which can then be imported into another Oracle database. These utilities can be used to move data between different machines, databases or schema. However, as they use a proprietary…
Delete Archivelog Using RMAN in Oracle
If your storage is about full, you must either delete old backup and archivelog or move to tape. If you want to delete archivelog from FRA(ASM Storage-Flash Revovery Area) or filesystem for win space, you can use below commands. You can delete archivelog safely, because archivelog deleting does not harm to database. Archivelog List Commands…
Archivelog Mode Open and Close in Oracle
Most of the High Availability features of Oracle require you to enable ARCHIVELOG mode for your database. When you enable this mode redo logs will be archived instead of overwritten. The archivelogs are stored in a seperate place usually can backed up regularly by your standard filesystem backup system. Archive logs are utilized by RMAN,…