Case 5: Redo log is not CURRENT and not archived, means missing file is in ACTIVE status.
If the redo log is lost before it is archived then there are a few transactions in the redo log that are lost too. Since…
Category: Backup/Recovery
Case 4: All redo log file or any one redo log file missing and we have no backup copy of redo log file or no multiplexing redo log file.
If all or some redo log is missing. Here’s an example, where I attempt to startup from SQLPlus when a redo log is missing: SQL>…
Different Type of RMAN Backup
Full Backups A full backup reads the entire file and copies all blocks into the backup set, only skipping datafile blocks that have never been…
RMAN Backup Terminology
Oracle provides a tool for Database backup and restore operation is called RMAN. RMAN is a client/server application that uses database server sessions to perform…
User Managed Backup Terminology
(Operating system command are used to make backups when database is closed or open in this terminology) Whole database backup refer to a backup of…
Recovery from Block Corruption
Recovery from block corruption It is possible to recover corrupted blocks using RMAN backups. This is a somewhat exotic scenario, but it can be useful…
Monitoring Recovery Manager Jobs
Sometimes it is useful to identify what a server session performing a backup or copy operation is doing. You have access to several views that…
Introduction
In general, backup and recovery refers to the various strategies and procedures involved in protecting your database against data loss and reconstructing the data should…
Disaster recovery
How to perform a disaster recovery of an Oracle server using Manual Backup Method 1.Pre-requisites:The following are the pre-requisites to fully recover an Oracle database…
Recovery from missing or corrupted redo log group
Recovery from missing or corrupted redo log group: Case 1: A multiplexed copy of the missing log is available. if a redo log is missing,…