Recovery from missing or corrupted datafile
Scenario: (When you take cold backup means consistent backup) If your database is running in archive log mode and you take cold backup means consistent…
Category: Backup/Recovery
How to Perform User Managed Inconsistent Backup & Recovery (With Example)
1. Backup all data file and Control file by using following commands on every Sunday. (BACKUP SCRIPTS) host ocopy C:OracleRDBMS*.001 e:temphost del C:OracleRDBMS*.001 /qset echo…
Type of Recovery and Difference between Resetlog and No resetlogs Option
omplete Recovery Complete recovery can be done with the database OPEN unless the SYSTEM or UNDO tablespaces are damaged (this will terminate the instance). When…
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…
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…
HOW TO PERFORM BLOCK MEDIA RECOVERY WHEN BACKUPS ARE NOT TAKEN BY RMAN.
To Perform Block Media Recovery when there are OS-backups available, but NO RMAN backups. Consider that a block corruption is reported in the database and…
Restoring an RMAN Backup to Another Node
In certain circumstances, it may be desirable to restore a database from an RMAN backup onto a machine other than the original host. For example,…
Redolog file Recovery
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,…
Controlfile Recovery
Recovery from missing or corrupted control file Case 1: A multiplexed copy of the control file is available. On startup Oracle must read the control…
Datafile Recovery
Recovery from missing or corrupted datafile(s): Case 1: Recovery from corrupted or missing datafile This scenario deals with a situation where a datafile has gone…