oracle sql and dba tutorial logo

Oracle DBA

Learn Oracle 11g / 12c Database Admin step by step



Oracle SQL

Tutorial for Oracle SQL

 

Oracle DBA Interview Questions

Most asked Oracle DBA Interview Questions.

60 Technical Questions
42 Backup & Recovery Questions

Unix For Oracle DBA 20 Questions


Download Oracle 11g / 12 c Software

Links to Download Oracle 12c / 11g for Linux, Windows etc.



Disaster Recovery using RMAN

Suppose we have lost all the datafiles, logfiles and even control file and parameter file is also lost.

This usually happens when the Primary Disk is damaged

Then to recover the database from this kind of failure we need to do disaster recovery or full database recovery

 Assumption

To restore and recover the database do the following

Step 1

If you have lost the primary disk where O/s and Oracle was installed. Then, install a new disk and format and install the same operating system and same version of Oracle database software which was install before failure

Step 2

Make sure RMAN backups are available and also make sure archive log files of this database are also accessible

Start RMAN by typing the following command

$ export ORACLE_SID=test
$ rman target / nocatalog

start-rman-in-disaster-recovery

Now the most important thing we need to do now is to set the database ID (DBID) at RMAN prompt. The DBID uniquely identifies the database.

If you have already noted down the DBID of the database then you can straight forward type the DBID at the RMAN prompt.

Otherwise if you have not noted down the DBID then the other ways you can get the DBIDx is

Once you got the DBID then set it by typing the following command

RMAN> set dbid=2195428530

set dbid in rman

Continue Next Page >

 

 


HomeContact Us

Data Loader

Data Loader is a simple yet powerful tool to
export and import Data between many common database formats


Forms Data Loader

Tool to load data into Oracle E-Business Suite R12 / Oracle Apps using Macros and Forms Record and Playback

Interface Computers Academy © 2007-2017 All Rights Reserved