Case 2: All members of a log group lost
In this case an incomplete recovery is the best we can do. We will lose all transactions from the missing log and all subsequent logs.…
Category: Backup/Recovery
Time-Based, Change-Based, or SCN-based Incomplete Recovery
Incomplete recovery uses a backup to produce a non-current version of the database. In other words, you do not apply all of the redo records…
Recover Tablespace
To recover from a case of a dropped tablespace, the Tablespace Point In Time Recovery (TSPITR) method cannot be used. When you drop a tablespace,…
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…
Case 2: All control files lost
What if you lose all your control files? In that case you have no option but to use a backup control file. The recovery needs…
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 5: If all database lost and we have no backup of newly created data file.
Step 1 Restore database and mount the database Step 2 Recover the database SQL> recover database using backup controlfile; Step 3 Check file status SQL>…
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 ;…
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…