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: Backup/Recovery
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…
Complete Steps for Using RMAN Catalog
Recovery manager is a platform independent utility for coordinating your backup and restoration procedures across multiple servers. Create Recovery Catalog • First create a user…
How to Configure RMAN
RMAN can invoked from the command line on the database host machine like so: C:>rman target sys/sys_password Recovery Manager: Release 9.2.0.1.0 – Production Copyright (c)…
RMAN with Recovery Catalog
Deciding Whether to Use RMAN with a Recovery Catalog By default, RMAN connects to the target database in NOCATALOG mode, meaning that it uses the…
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…