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.


MySQL Tutorial

Learn MySQL step by step


 

 

 

 

 

 

 

 

 

Disaster Recovery using RMAN page 3 

 

Step 5

Now shutdown the instance as we have started with the default parameters  and restart the instance with the just restored SPFILE

RMAN> shutdown
RMAN> exit
RMAN> startup nomount;

shutdown and restart instance

Step 6

Now restore Control file from autobackup by typing the following command

RMAN> restore controlfile from autobackup;

restore controlfile from autobackup

After restoring the controlfile we can now mount the database. To mount the database,  type the following command

RMAN> alter database mount;

mount db after restoring controlfile

 

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