Restore Tablespace, Archivelog and Datafile via RMAN | Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -5

Hi,

I will tell you about the RMAN (Recovery Manager) tool that we use frequently Backup and Restore operations in Oracle Databases in this fourth article of my tutorial series.

 

Read my rman backup tutorial series before this article with following links. We will use these backups in this restore recover tutorial series.

 

https://ittutorial.org/2019/03/27/oracle-rman-recovery-manager-backup-tutorials-8/

 

then read older article of this tutorial series with following link.

 

 

https://ittutorial.org/2019/03/28/oracle-rman-recovery-manager-restore-recover-tutorials-1/

https://ittutorial.org/2019/03/28/oracle-rman-recovery-manager-restore-recover-tutorials-3/

https://ittutorial.org/2019/03/29/oracle-rman-recovery-manager-restore-recover-tutorials-4/

 

 

You can restore users tablespace with following command.

RMAN> restore tablespace users;

Starting restore at 26-MAR-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=39 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00007 to /oradata/19c/DEVECI19C/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/1rttdk6g_1_1
channel ORA_DISK_1: piece handle=/u01/backup/1rttdk6g_1_1 tag=TAG20190326T143143
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 26-MAR-19

RMAN>

RMAN>

 

Make tablespace online.

 

[oracle@MehmetSalih backup]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 26 15:35:26 2019
Version 19.2.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.2.0.0.0

SQL> alter tablespace users online;

Tablespace altered.

 

 

You can restore any datafiles with its number like following.

 

RMAN> restore datafile 4;

Starting restore at 26-MAR-19
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /oradata/19c/DEVECI19C/undotbs01.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/1rttdk6g_1_1
channel ORA_DISK_1: piece handle=/u01/backup/1rttdk6g_1_1 tag=TAG20190326T143143
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 26-MAR-19

RMAN>

 

The following command is used to restore all archivelogs.

RMAN> RESTORE ARCHIVELOG ALL;   

The following command is used to restore Archivelog in a certain sequence range.

RMAN> RESTORE ARCHIVELOG FROM SEQUENCE 1453 UNTIL SEQUENCE 2013;


The following command is used to be able to restore archivelogs  from a certain sequence number.

RMAN> RESTORE ARCHIVELOG FROM LOGSEQ= 1453;   

In addition to this, the following command is used to restore archivelogs at certain time intervals.

RMAN> RESTORE ARCHIVELOG FROM TIME 'SYSDATE-10' UNTIL TIME 'SYSDATE-1';

The following command is used to restore Archivelogs in a specific SCN range.

RMAN> RESTORE ARCHIVELOG SCN BETWEEN 1453 and 2019;

 

https://ittutorial.org/2019/03/28/oracle-rman-recovery-manager-restore-recover-tutorials-2/

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

11 comments

  1. Whatever the response you receive, you can rest assured that it’s the truth for the individual.
    What you are related is to carefully manage your betting money such that
    you won’t go wasting them that much. http://cairpatientregistry.org/__media__/js/netsoltrademark.php?d=sky777.group

  2. Whatever the response you receive, you can rest assured that it’s the truth for the individual.
    What you are related is to carefully manage your betting money such that you
    won’t go wasting them that much. http://cairpatientregistry.org/__media__/js/netsoltrademark.php?d=sky777.group

  3. Howdy! Someone in my Facebook group shared this website with us so I came to
    take a look. I’m definitely loving the information. I’m book-marking and will
    be tweeting this to my followers! Excellent blog and wonderful design. I am sure this post has touched all the internet people, its really really pleasant
    article on building up new blog. I will
    immediately grab your rss as I can not find your email
    subscription hyperlink or newsletter service. Do you have any?
    Please permit me recognize so that I may just subscribe.
    Thanks. http://starbucks.com

  4. Thanks , I have recently been searching for information approximately this tpic for a long timee
    aand yours is the greatest I’ve came upon till now. However,
    what in regards too the bottom line? Are you surre concerning the
    supply?

  5. Then familarise yourself with how it operates.

  6. Good web site you have got here.. It’s difficult to find high-quality writing
    like yours these days. I seriously appreciate people like
    you! Take care!! https://www.muktwioutt.com

  7. Good web site you have got here.. It’s difficult to
    find high-quality writing like yours these days.

    I seriously appreciate people like you! Take care!! https://www.muktwioutt.com

  8. From the wall to visually free up floor spacé.

  9. We absolutely love your blog and find most of your post’s to be exactly what I’m looking for.
    Does one offer guest writers to write content to suit your needs?

    I wouldn’t mind creating a post or elaborating on some of the subjects you
    write with regards to here. Again, awesome website!

Leave a Reply

Your email address will not be published. Required fields are marked *