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.

 

 

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

 

 

 

 

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;

 

Mehmet Salih Deveci

I am Founder of 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 mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

10 thoughts on “Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -5