Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How does rman back up data files

2025-01-24 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)05/31 Report--

This article mainly explains "rman how to back up data files", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "rman how to back up data files"!

There are two ways to back up specified data files, specified data files and specified tablespaces

Specify backup data files

RMAN > backup datafile 4

Starting backup at 2017-07-30 13:09:40

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=18 device type=DISK

Channel ORA_DISK_1: starting full datafile backup set

Channel ORA_DISK_1: specifying datafile (s) in backup set

Input datafile file number=00004 name=/u01/app/oracle/oradata/test/users01.dbf

Channel ORA_DISK_1: starting piece 1 at 2017-07-30 13:09:40

Channel ORA_DISK_1: finished piece 1 at 2017-07-30 13:09:43

Piece handle=/home/oracle/1asal8ck_1_1 tag=TAG20170730T130940 comment=NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Finished backup at 2017-07-30 13:09:43

Backup tablespace

When backing up a tablespace, you are actually backing up the data files under the tablespace.

RMAN > backup tablespace users

Starting backup at 2017-07-30 13:10:30

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting full datafile backup set

Channel ORA_DISK_1: specifying datafile (s) in backup set

Input datafile file number=00004 name=/u01/app/oracle/oradata/test/users01.dbf

Channel ORA_DISK_1: starting piece 1 at 2017-07-30 13:10:30

Channel ORA_DISK_1: finished piece 1 at 2017-07-30 13:10:31

Piece handle=/home/oracle/1bsal8e6_1_1 tag=TAG20170730T131030 comment=NONE

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2017-07-30 13:10:31

Thank you for your reading, the above is the content of "rman how to back up data files". After the study of this article, I believe you have a deeper understanding of how rman backs up data files, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report