Important situations of Oracle Data Guard Nologging or unrecoverable operations are not applied to standby – so be cautious in using those options. Alarming data block corruption error messages are reported if a user attempts to access any nologging or unrecoverable data blocks. ‘Drop tablespace’, ‘drop datafile’, ‘rename datafile’, and add/drop online redo log files…
Category: Backup And Recovery
How to Add Standby Logfile in Oracle
If you want to use real-time apply Oracle Data Guard, you have to add standby logfile to standby database. Show Logfiles Before Add SQL> select * from gv$logfile; INST_ID GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE 1 3 ONLINE +DATA/testdb/onlinelog/group_3.14134123 NO 1 1 ONLINE +DATA/testdb/onlinelog/group_1.35116731 NO 1 2 ONLINE +DATA/testdb/onlinelog/group_2.32513245 NO 1 4 ONLINE +DATA/testdb/onlinelog/group_4.12255335 NO 1…
Oracle Data Pump (expdp and impdp) in Oracle
Oracle Data Pump is faster and more flexible alternative to the “exp” and “imp” backup system used in previous Oracle versions. impdp and expdp commands use Oracle Directory for processing of backups. Create Directory CONN SYS AS SYSDBA CREATE OR REPLACE DIRECTORY dirname AS ‘/u01/backup/’; GRANT READ, WRITE ON DIRECTORY dirname TO backupuser; Tables Export…
Oracle Data Guard Timeliness Status in Oracle
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…
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,…