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/
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
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
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
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?
Then familarise yourself with how it operates.
Some are very consistent and predictable.
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
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
From the wall to visually free up floor spacé.
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!