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 5

After restoring is finished, open the database by resetting the logs by typing the following command

RMAN>alter database open resetlogs

alter database open

That's it the database is restored but since the database is running in NOARCHIVELOG mode you will loose the transactions occurred after the last full backup. If possible you have to reenter all lost transactions manually which is difficult in most of the cases.

 

 

 

 

 

 

 

 

 


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