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 2


Step 3

Since we don't even have SPFILE, we need to start the instance with default parameters

Start database instance with default parameters by typing the following command at RMAN prompt

RMAN> startup force nomount;

startup force rman


Step 4

Now restore SPFILE from autobackup by typing the following command

RMAN>restore spfile  from autobackup;

When we give the above command RMAN will fail with the following output

restore spfile from autobakup

To restore SPFILE we need to give the location of the autobackup file. You can view the location and name of the most recent autobackup files by looking into the flash_recovery_area/autobackup folder

In our case flash_recovery_area is set to /u02/oracle/testdb/flash/TEST

After going into this directory, go to autobackup directory and search for the latest autobackup file.

autobackup files

In our case the latest autobackup file is o1_mf_s_926930278_d1pq2srv_.bkp

Now we need to restore SPFILE from this file by typing the following command

RMAN> restore spfile from

restore spfile


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