How to Restore Oracle Database using RMAN (with Examples) [Link]

com/2014/11/oracle-rman-restore/

≡ MENU

How to Restore Oracle Database using

RMAN (with Examples)
by RAMESH NATARAJAN on NOVEMBER 24, 2014

As a Linux sysadmin, you might recover a system from backup, which may
include Oracle Database.

So, it is essential for all admins to understand how to restore oracle database from
backup.

Typically, DBAs will use Oracle RMAN utility to take a hot backup of the database.

This tutorial provides an introduction on how to restore an Oracle database from

the RMAN backup.

If you are new to RMAN, you should first understand how to backup oracle
database using RMAN.

For the impatient, here is a quick snippet of one particular rman restore scenario.
Change this accordingly for your scenario. Read below to understand more details
about these commands.

RMAN> SET DBID 12345;

RMAN> STARTUP NOMOUNT;

1 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";

RMAN> RESTORE DATABASE;

RMAN> RECOVER DATABASE;

RMAN> ALTER DATABASE OPEN RESETLOGS;

Verify Backup Location

Before the restore, verify the current RMAN configuration on the server where
you’ll be performing the restore.

To connect to RMAN, execute the following rman command, which will take you
to the RMAN> prompt. From here, you can execute all RMAN commands.

$ rman target /

Recovery Manager: Release [Link].0 - Production on Mon Nov 17 11:17:11 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

connected to target database: DEVDB (DBID=821773)

RMAN>

Execute “show all”, which will display all current RMAN configuration. As you see
below, the current RMAN backup is located under “/backup/rman” directory.

RMNAN> SHOW ALL;

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/rman/ctl_%F';

CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 4;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

2 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/data/rman-backup/full_%u_%s_%p' MAXPIECESIZE 4096

CONFIGURE MAXSETSIZE TO UNLIMITED;

CONFIGURE ENCRYPTION FOR DATABASE OFF;

CONFIGURE ENCRYPTION ALGORITHM 'AES128';

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # defau

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/backup/rman/snapcf_med.f';

On a high-level, the following three steps are performed in recovering the

database from RMAN backup.

1. Restore controlfile from backup

2. Restore the databse
3. Recover the database

WARNING: Execute rman restore commands only on a test instance. If you

try these restore commands in a production instance, and if something goes
wrong, you’ll lose your production data.

Step 1: Restore ControlFile from Backup

First, you may want to restore the control file from the backup before you start the
restore.

This step is required only if you are restoring the backup on a new server where
the control file doesn’t exist. Or, if the control file on the system you are restoring
is corrupted or missing.

RMAN> SET DBID 12345;

RMAN> STARTUP NOMOUNT;

3 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";

RMAN> ALTER DATABASE MOUNT;

Before you start the RMAN restore process, do the following:

▪ Set the DBID. You can get the dbid from the name of the control file. This is
the number that comes after “ctrl_c-” and the next hyphen. Please note that
this depends on the controlfile format that was set on your system. Do a show
all to view the format. For this example, the format was: “ctl_%F”
▪ Startup the database in nomount option
▪ Restore the controlfile form the backup. In this example, the RMAN backup is
located under /backup/rman directory. Under this directory, you may have
multiple control files. Based on the tiemstamp pick the appropriate one for
which you have the full backup.
▪ After restoring the control file, mount the database.

The following is an example output of the restore controlfile command:

Starting restore at 22-NOV-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=124 devtype=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:02

output filename=/u01/oradata/devdb/[Link]

output filename=/u02/oradata/devdb/[Link]

output filename=/u03/oradata/devdb/[Link]

Finished restore at 22-NOV-14

When the RMAN backup was taken, if a tag was specified, you can also restore
controlfile based a tag name as shown below.

4 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

RMNAN> RESTORE CONTROLFILE FROM TAG 'WEEKLY_FULL_BKUP';

You can also use the autobackup option to restore the controlfile as shown below:

RMNAN> RESTORE CONTROLFILE FROM AUTOBACKUP;

Step 2: Restore the Database

To restore from the RMAN full backup that is located under the /backup/rman
directory, execute the following command.

RMAN> RESTORE DATABASE;

Apart from the above straight forward restore database, there are also few
variations of this command which are explained in the examples below. Use the
one that is appropriate for your situation.

The following is a sample output of the above restore database command:

RMAN>

Starting restore at 22-NOV-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=125 devtype=DISK

...

channel ORA_DISK_2: starting datafile backupset restore

channel ORA_DISK_2: specifying datafile(s) to restore from backup set

restoring datafile 00020 to /u01/oradata/devdb/dev01_1.dbf

restoring datafile 00021 to /u02/oradata/devdb/report_data.dbf

restoring datafile 00022 to /u01/oradata/devdb/[Link]

channel ORA_DISK_2: reading from backup piece /backup/rman/full_32qakgmpa_123456_1

5 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

channel ORA_DISK_4: starting datafile backupset restore

....

Step 3: Recover Database (and ResetLogs)

If you’ve restored the controlfile from the backup, you need to perform this step.

In the last step, recover the database, and then you should open the database with
resetlogs options as show below:

RMAN> RECOVER DATABASE;

RMAN> ALTER DATABASE OPEN RESETLOGS;

Restore Specific Tablespace

Instead of restoring the full database, you can also restore only specific tablespace
as shown below.

The following will restore only the dev1 tablespace

RMNAN> RESTORE TABLESPACE dev1;

You can also restore more than one tablespace by separating them with commas
as shown below. This will restore both dev1 and dev2 tablespace.

RMNAN> RESTORE TABLESPACE dev1, dev2;

Restore Specific Datafiles

You can also restore only a specific datafile from the backup using the restore

6 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

datafile command as shown below.

The following will restore only the dev1_01.dbf datafile.

RMNAN> RESTORE DATAFILE '/u01/oradata/devdb/dev1_01.dbf'

You can also restore more than one datafile by separating them with commas as
shown below. This will restore both dev1_01 and dev1_02 datafiles

RMNAN> RESTORE DATAFILE '/u01/oradata/devdb/dev1_01.dbf', '/u01/oradata/devdb/dev1_02.dbf'

Instead of the datafile name, you can also specify the datafile number.

RMNAN> RESTORE DATAFILE 34, 35

The datafile number (file_id) can be found in the dba_data_files table:

SQL> select file_id, file_name from dba_data_files

FILE_ID FILE_NAME

---------- -------------------------------

34 /u01/oradata/devdb/dev1_01.dbf

35 /u01/oradata/devdb/dev1_02.dbf

Restore the Archived Redo Logs

The following will restore the archive logs to the default location.

RMNAN> RESTORE ARCHIVELOG ALL;

7 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

If you want to restore the archive logs to a new directory, do the following:

RMNAN> SET ARCHIVELOG DESTINATION TO '/home/arc_logs_new/';

RMNAN> RESTORE ARCHIVELOG ALL;

The following will restore only specific sequence number of the archive logs that
are between 153 and 175.

RMNAN> RESTORE ARCHIVELOG FROM SEQUENCE 153 UNTIL SEQUENCE 175;

You can also restore archivelogs by specifying the starting point of the SCN
number as shown below.

RMNAN> RESTORE ARCHIVELOG FROM SCN 56789;

Please note that when you issue the recover database as mentioned in the step 3
above, it will look for all required archive logs from the archive log destination
and applies them to the oracle database datafiles.

Recover Specific Tablespace or Datafile

Similar to restoring specific tablespace and datafile, depending on the restore
operation you did, perform the corresponding recover option. The following are
few examples:

RMAN> RECOVER TABLESPACE dev1;

RMAN> RECOVER TABLESPACE dev1, dev2;

RMAN> RECOVER DATAFILE '/u01/oradata/devdb/dev1_01.dbf'

RMAN> RECOVER DATAFILE 34, 35

8 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

Note: You can also append “DELETE ARCHIVELOG” option to the recover
command, which will delete the restored archive logs from the disk which are not
required anymore. For example:

RMNAN> RECOVER TABLESPACE dev1 DELETE ARCHIVELOG;

Preview the Restore

Before restoring the database, if you like to view the details of all the backupsets
that will be used along with the SCNs that are part of the backup file, you can
append “PREVIEW” to any of the restore databse command. Please note that the
preview output will be similar to the rman list summary command output.

This really doesn’t do the restore. This will only provide the report. You can use
this before you restore the database.

RMAN> RESTORE DATABASE PREVIEW;

Pelase note that if the output of the above PREVIEW command is too detailed,
and you need only the summary, you can execute the following PREVIEW
SUMMARY.

RMAN> RESTORE DATABASE PREVIEW SUMMARY;

The following is the sample output of the above preview summary:

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---

234587 B F A DISK 22-NOV-14 1 1 YES WEEKLY_FULL_BKUP

234588 B F A DISK 22-NOV-14 1 1 YES WEEKLY_FULL_BKUP

234589 B F A DISK 22-NOV-14 1 1 YES WEEKLY_FULL_BKUP

9 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

234580 B F A DISK 22-NOV-14 1 1 YES WEEKLY_FULL_BKUP

234581 B F A DISK 22-NOV-14 1 1 YES WEEKLY_FULL_BKUP

..

The following are also valid preview option. You can append SUMMARY to all of
the following commands:

RESTORE TABLESPACE dev1 PREVIEW;

RESTORE DATAFILE '/u01/oradata/devdb/dev1_01.dbf' PREVIEW;

RESTORE ARCHIVELOG ALL PREVIEW;

RESTORE ARCHIVELOG FROM SCN 234546 PREVIEW;

Validate the Backup Before Restore (Dry-run)

Before you perform the restore, you might want to really validate the backup to
make sure that the backup itself is not corrupted, and all the file required to
perform the backup is actually present in the backup directory.

RMAN> RESTORE DATABASE VALIDATE;

Depending on the size of the database this operation might take some time to
complete. Technically, this is same as restoring the database except that this
doesn’t do the real restore, and it performs only the Dry-run. The validate
operation will really read all the blocks in the RMAN backup to make sure they
are valid.

The following is a sample output of the restore validate command:

Starting restore at 22-NOV-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=123 devtype=DISK

10 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

...

channel ORA_DISK_1: starting validation of datafile backupset

channel ORA_DISK_2: starting validation of datafile backupset

channel ORA_DISK_1: reading from backup piece /backup/rman/full_3abcde4po_123456_1

channel ORA_DISK_2: reading from backup piece /backup/rman/full_32qakgmpa_123456_1

channel ORA_DISK_1: restored backup piece 1

...

channel ORA_DISK_2: validation complete, elapsed time: 00:53:11

Finished restore at 22-NOV-14

RMAN Restore Common Error Messages

The following are some of the most common RMAN restore error messages:

Error 1: Start-up mount might give the following RMAN-04014 error:

RMAN> STARTUP NOMOUNT

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of startup command at 10/03/2014 11:04:19

RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file

Linux-x86_64 Error: 2: No such file or directory

Additional information: 9925

Solution 1: Create the audit trial directory. Change the path to match your
system.

mkdir -p $ORACLE_BASE/admin/devdb/adump

Error 2: Restore controlfile might give the following RMAN-00558,

RMAN-01006, or RMAN-02001 error.

11 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

RMAN> RESTORE CONTROLFILE FROM /backup/rman/ctl_c-12345-20141003-03

RMAN-00558: error encountered while parsing input commands

RMAN-01006: error signaled during parse

RMAN-02001: unrecognized punctuation symbol "/"

Solution 2: Make sure to include the whole controlfile patch within quotes as
shown below.

RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";

Error 3: Restore controlfile (or restore database) might give the following
RMAN-03002, ORA-19870, or ORA-27040 error along with “Linux-x86_64
Error: 2: No such file or directory”.

RMAN> RESTORE CONTROLFILE FROM "/backup/rman/ctl_c-12345-20141003-03";

RMAN-03002: failure of restore command at 10/03/2014 11:12:25

ORA-19870: error while restoring backup piece /backup/rman/ctl_c-12345-20141003-03

ORA-19504: failed to create file "/u01/oradata/devdb/[Link]"

ORA-27040: file create error, unable to create file

Linux-x86_64 Error: 2: No such file or directory

Solution 3: In most cases it is missing directory. Create the appropriate

directories accordingly. You might also get not found messsage for
flash_recovery_area directory. So, create them both. Or, create whatever
directory the above error message is complaining about.

mkdir -p $ORACLE_BASE/oradata/devdb

mkdir -p $ORACLE_BASE/flash_recovery_area/devdb/

Error 4: When you alter database open resetlogs, you might get the following

12 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

ORA-01152 error message:

RMAN> ALTER DATABASE OPEN RESETLOGS;

ERROR at line 1:

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '/u01/oradata/devdb/[Link]'

Solution 4: You can try couple of things. First, try to recover database until
cancel as shown below. If that doesn’t help, remove the “UNTIL CANCEL” from
the following command, and specify the redo log file, when it asks for “Specify
log:” during the recover database command:

RMAN> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;

Tweet Add your comment

If you enjoyed this article, you might also like..

1. 50 Linux Sysadmin Tutorials ▪ Awk Introduction – 7 Awk Print
2. 50 Most Frequently Used Linux Examples
Commands (With Examples) ▪ Advanced Sed Substitution
3. Top 25 Best Linux Performance Examples
Monitoring and Debugging Tools ▪ 8 Essential Vim Editor Navigation
4. Mommy, I found it! – 15 Practical Fundamentals
Linux Find Command Examples ▪ 25 Most Frequently Used Linux
5. Linux 101 Hacks 2nd Edition eBook IPTables Rules Examples
▪ Turbocharge PuTTY with 12
Powerful Add-Ons

13 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

Tagged as: RMAN Backup Command, RMAN Restore Command, RMAN Restore Controlfile, RMAN Restore Datafile, RMAN

Restore from Disk, RMAN Restore Location, RMAN Restore Syntax, RMAN Restore Tablespace

Comments on this entry are closed.

Md. Mahfuzur Rhamah

November 25, 2014, 2:21 am

Helpful article
Thanks

Stome
December 16, 2014, 2:13 am

Dear Admin,
I am a beginner of ORACLE, (I had backup from other machine SID=orcl and for
my new server machine install with default setup also have SID=orcl)
When i type
RMAN> SET DBID 12345….; (old dibid in old server to recover)

Error:

executing command: SET DBID

RMAN-00571:
========================================================

14 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

===
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
===============
RMAN-00571:
========================================================
===
RMAN-03002: failure of CSET command at 12/16/2014 15:10:59
RMAN-06188: cannot use command when connected to a mounted target
database

Regard,
Stome

younme
March 13, 2015, 7:46 am

Your database is already mounted as per your error message. A mounted database
already has an DBID assigned. Your database will have to be started in nomount
mode to permit a DBID to be assigned. e.g. > “startup nomount;”.

RightDBA
May 13, 2015, 11:12 pm

A very nice article.

Thanks a lot for it.

Foued

15 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

September 6, 2015, 11:21 am

Thank you for sharing. Foued

Naresh
March 11, 2016, 12:20 am

Very good article.

Thanks

Next post: 7 Patch Command Examples to Apply Diff Patch Files in Linux
Previous post: Top 5 Best Chromebook Laptop (and Pros and Cons of Chrome OS)

RSS | Email | Twitter | Facebook

16 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

EBOOKS

Linux 101 Hacks 2nd Edition eBook - Practical Examples to Build a Strong Foundation in Linux

Bash 101 Hacks eBook - Take Control of Your Bash Command Line and Shell Scripting

Sed and Awk 101 Hacks eBook - Enhance Your UNIX / Linux Life with Sed and Awk

Vim 101 Hacks eBook - Practical Examples for Becoming Fast and Productive in Vim Editor

Nagios Core 3 eBook - Monitor Everything, Be Proactive, and Sleep Well

POPULAR POSTS
15 Essential Accessories for Your Nikon or Canon DSLR Camera

12 Amazing and Essential Linux Books To Enrich Your Brain and Library

50 UNIX / Linux Sysadmin Tutorials

50 Most Frequently Used UNIX / Linux Commands (With Examples)

How To Be Productive and Get Things Done Using GTD

30 Things To Do When you are Bored and have a Computer

Linux Directory Structure (File System Structure) Explained with Examples

Linux Crontab: 15 Awesome Cron Job Examples

Get a Grip on the Grep! – 15 Practical Grep Command Examples

Unix LS Command: 15 Practical Examples

15 Examples To Master Linux Command Line History

Top 10 Open Source Bug Tracking System

17 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

Vi and Vim Macro Tutorial: How To Record and Play

Mommy, I found it! -- 15 Practical Linux Find Command Examples

15 Awesome Gmail Tips and Tricks

15 Awesome Google Search Tips and Tricks

RAID 0, RAID 1, RAID 5, RAID 10 Explained with Diagrams

Can You Top This? 15 Practical Linux Top Command Examples

Top 5 Best System Monitoring Tools

Top 5 Best Linux OS Distributions

How To Monitor Remote Linux Host using Nagios 3.0

Awk Introduction Tutorial – 7 Awk Print Examples

How to Backup Linux? 15 rsync Command Examples

The Ultimate Wget Download Guide With 15 Awesome Examples

Top 5 Best Linux Text Editors

Packet Analyzer: 15 TCPDUMP Command Examples

The Ultimate Bash Array Tutorial with 15 Examples

3 Steps to Perform SSH Login Without Password Using ssh-keygen & ssh-copy-id

Unix Sed Tutorial: Advanced Sed Substitution Examples

UNIX / Linux: 10 Netstat Command Examples

The Ultimate Guide for Creating Strong Passwords

6 Steps to Secure Your Home Wireless Network

Turbocharge PuTTY with 12 Powerful Add-Ons

CATEGORIES
Linux Tutorials

Vim Editor

Sed Scripting

Awk Scripting

Bash Shell Scripting

Nagios Monitoring

OpenSSH

18 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

IPTables Firewall

Apache Web Server

MySQL Database

Perl Programming

Google Tutorials

Ubuntu Tutorials

PostgreSQL DB

Hello World Examples

C Programming

C++ Programming

DELL Server Tutorials

Oracle Database

VMware Tutorials

A���� T�� C������ U� S������ U�

G��� S����
Email Me : Use this Support this blog by
Contact Form to get in purchasing one of my
My name
touch me with your ebooks.
is
comments, questions or
Ramesh
suggestions about this Bash 101 Hacks eBook
site. You can also simply
drop me a line to say Sed and Awk 101 Hacks
hello!. eBook
Natarajan. I will be
posting instruction
guides, how-to, Follow us on Twitter Vim 101 Hacks eBook
troubleshooting tips and
tricks on Linux, database, Become a fan on Nagios Core 3 eBook
hardware, security and Facebook
web. My focus is to write
articles that will either
teach you or help you
resolve a problem. Read
more about Ramesh
Natarajan and the blog.

19 of 20 1/27/2026, 12:27 AM
How to Restore Oracle Database using RMAN (with Examples) [Link]

Copyright © 2008–2024 Ramesh Natarajan. All rights reserved | Terms of Service

20 of 20 1/27/2026, 12:27 AM