Case 4: Lost datafile and No backup (When database abnormal terminated)
Step 1 Startup the database with mount option SQL> startup mount Step 2 Recreate datafile SQL> alter database create datafile ‘’ as ‘’ size ;…
Category: Oracle Database
Case 3: lost data file and we have no backup (When database open)
Step 1 offline the datafile SQL> alter database datafile ‘’ offline; Step 2 Create datafile SQL> Create database create datafile ‘’ as ‘’ size ;…
Case 2: Recover from corrupted or missing data file (When database already open)
This scenario deal with a situation where data file has gone missing or corrupted and databases already open. If the database is already open when…
Case 1: Recover from corrupted or missing data file
This scenario deal with a situation where data file has gone missing or corrupted at the time of open the database. This scenario deals with…
RMAN: Restore Concept
Use the RMAN RESTORE command to restore the following types of files from copies on disk or backups on other media: • Database (all datafiles)…
Different Type of Recovery
Complete Recovery Complete recovery can be done with the database OPEN unless the SYSTEM or UNDO tablespaces are damaged (this will terminate the instance). When…
Case 1: A multiplexed copy of the control file is available.
On startup Oracle must read the control file in order to find out where the datafiles and online logs are located. Oracle expects to find…
Case 3: If missing Redo log is CURRENT
When a current redo log is lost, the transactions in the log file are also lost before making to archived logs. Since a DB startup…
Case 2: Only A redo log file backup copy available (but Redo Log is not current and archived)
If a redo log is missing, it should be restored from a Cold backup (if redo log backup available in Sunday Cold Backup) if possible.…
Case 1: A multiplexed copy of the missing log is available.
If a redo log is missing, it should be restored from a multiplexed copy, if possible. Here’s an example, where I attempt to startup from…