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


 

 

 

 

 

 

 

 

 

Recovering Database running in NOARCHIVELOG mode using RMAN Continued...  

Step 3

After restoring the controlfile to "/u02/oracle/testdb/" directory, shutdown the instance and copy just restored controlfile to original locations

$sqlplus

Enter User: / as sysdba
SQL>shutdown immediate;
SQL>Exit
$

Copy controlfile to original locations

$ cp control.ora ./test/control01.ctl
$ cp control.ora ./test/control02.ctl

Step 4

Start RMAN and Start and mount the database

start the database

Now give RESTORE DATABASE command

RMAN> restore database

restore database

NEXT STEP

 

 


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